Want help for sql Query

See more:

SQL-Server-2005

SQL-Server

Hi.. friends

I want following type of output with sql query from tbale tblABC


OUTPUT
======

SrNo. Date BillNo Amount
=================================================
1 10-02-2012 VAT-1 1200.00
2 RET-4 50.00
3 RET-5 150.50
4 11-02-2012 VAT-2 1500.00
5 RET-6 2505.00
6 12-02-2012 VAT-3 05.00


from table which has following data


tblABC
======

SrNo. Date BillNo Amount
=================================================
1 10-02-2012 VAT-1 1200.00
2 10-02-2012 RET-4 50.00
3 10-02-2012 RET-5 150.50
4 11-02-2012 VAT-2 1500.00
5 11-02-2012 RET-6 2505.00
6 12-02-2012 VAT-3 05.00


The diffrence between the OUTPUT i want and table is that in
OUTPUT i don't want Date Reptetion as it is in table.

Please help how could i have it.