Here I am having the code.
It showing the entire record i need to show only one record with bill number.
In my case bill number 13 showing 3 results i need only last record with this id.
create procedure [dbo].[bindgv]
as
select [Bill Number],Date,Name,Particulars,Amount from Sontra_task
order by Date desc
Bill.No | Date | Name | Part. | Amount
17 | 2013-12-25 | Amar | FFR2 | 5788
12 | 2013-12-12 | ashraf | FFR2 | 566
2 | 2013-12-10 | Amrita | FF$ | 5454654654
13 | 12/28/2013 | Dawood | b | 2000
13 | 12/28/2013 | Dawood | c | 3000
13 | 12/28/2013 | Dawood | a | 1000
6 | 12/14/2013 | Komal FFR1 | 1500
i want to show the result like the following ...
17 2013-12-25 Amar FFR2 5788
12 2013-12-12 ashraf FFR2 566
2 2013-12-10 Amrita FF$ 5454654654
13 12/28/2013 Dawood b 2000
6 12/14/2013 Komal FFR1 1500
Could anybody suggest me for a perfect query.
Thank you