1
Answer

Can anyone tell me How to combine two rows into one.

Hi,
Can anyone tell me How to combine two rows into one.
 
EMPCode	    actHours	        actDate		rowno
107	    8.00		2013-01-21 	1
107	    8.30		2013-01-22 	1
107	    4.00		2013-01-23 	1
107	    4.00		2013-01-23 	2
107	    4.10		2013-01-24 	1
107	    4.20		2013-01-24 	2
107	    4.30		2013-01-25 	1
107	    4.30		2013-01-25 	2
 
I want the result as follows:
 
actHours	   actDate	
8.00		   2013-01-21 
8.30		   2013-01-22
8.00		   2013-01-23 
8.30		   2013-01-24
9.00		   2013-01-25
 
Any help will be appreciated. Thanks in advance Smile | :)

Answers (1)