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

Sreejesh SPPosted Mar 26, 2013, 7:02 AM
Please use the below sql query
select sum(actHours),sum(actDate) from tableName
Group by actDate
Thanks
Sreejesh