I have a result set like this
| CHASSIS | ENGINENO | RES1 | RES2 | COLOR | EXCISE | DELDATE |
| CHS21122015 | EN21122015 | 1 | 0 | NULL | NULL | NULL |
| TESTCHS50011 | EN50011 | 1 | 0 | NULL | NULL | NULL |
| CHS21122015 | EN21122015 | 0 | 1 | NULL | NULL | 1/8/2015 |
| TESTCHS50022 | EN50022 | 0 | 1 | NULL | NULL | 1/8/2015 |
| TESTCHS50023 | EN50023 | 0 | 1 | NULL | NULL | 1/8/2015 |
| TESTCHS50011 | EN50011 | 0 | 1 | NULL | NULL | 1/8/2015 |
RESULT SHUD BE
| CHASSIS | ENGINENO | RES1 | RES2 | COLOR | EXCISE | DELDATE |
| CHS21122015 | EN21122015 | 1 | 1 | NULL | NULL | 1/8/2015 |
| TESTCHS50011 | EN50011 | 1 | 1 | NULL | NULL | 1/8/2015 |
| TESTCHS50022 | EN50022 | 0 | 1 | NULL | NULL | 1/8/2015 |
| TESTCHS50023 | EN50023 | 0 | 1 | NULL | NULL | 1/8/2015 |
Ranjit PowarPosted Dec 22, 2015, 3:42 AM
Inam NPosted Dec 22, 2015, 3:24 AM
Ranjit PowarPosted Dec 22, 2015, 3:17 AM
Ranjit PowarPosted Dec 22, 2015, 3:10 AM
Inam NPosted Dec 22, 2015, 3:08 AM
Ranjit PowarPosted Dec 22, 2015, 3:00 AM