sno date desc amt creit debit total 2 08/02/2012 PURCHASE A/C 23 34500.00 0.00 2 08/02/2012 SOMU 23 0.00 34500.00 NULL 3 08/02/2012 SALES A/C 24 0.00 6000.00 NULL 3 08/02/2012 DEVA 24 6000.00 0.00 NULL NULL 4 08/03/2012 SBI 14 0.00 1000.00 NULL NULL 4 08/03/2012 Cash A/c 14 1000.00 0.00 NULL 4 08/03/2012 Cash A/c 14 1000.00 0.00 NULL 4 08/03/2012 Cash A/c 14 1000.00 0.00 NULL
sno date desc amt creit debit total 2 08/02/2012 PURCHASE A/C 23 34500.00 0.00 2 NULL SOMU 23 0.00 34500.00 NULL 3 NULL SALES A/C 24 0.00 6000.00 NULL 3 NULL DEVA 24 6000.00 0.00 NULL NULL 4 08/03/2012 SBI 14 0.00 1000.00 NULL NULL 4 NULL Cash A/c 14 1000.00 0.00 NULL 4 NULL Cash A/c 14 1000.00 0.00 NULL 4 NULL Cash A/c 14 1000.00 0.00 NULL
With CTE_Test as (select sno,[date],[desc],amt,creit,debit,Total,Row_number() over (PARTITION By date order by sno) as rowno from tbl_temp) Select Sno, Case when rowno=1 then [date] else Null END, [desc],amt,creit,debit,Total from cte_test
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)