Yeah that is what I already did, Thanks

vivek.verma (9/15/2010)[/b]

---

Thanks guys 🙂

@Wayne

Your solution is also working, is it some way possible to order the final result by date desc as the present final result set is as order...

Thanks guys 🙂

@Wayne

Your solution is also working, is it some way possible to order the final result by date desc as the present final result set is as order by...

@ ColdCoffee

The other code also worked well, and off course I will prefer less number of lines as it is somewhat good for speed. Thanks again

@ColdCoffee

Hey thanks it worked like a charm and code is also too well explained, and don't know how you got it that somewhere my requirement will be data for all...

Hi Jeff,

Thanks for your reply. Yes I am using SQL Server 2005 (I am not such a newbie to SQL though :P)

Regards,

Vivek

Also Wayne, I really liked your way of posting the code with comments..not everyone does like this.. It really helped in understanding the code..

Hi Wayne, many thanks for your reply. I am a newbie programmer and I have dealt more with programming rather then database and sql queries. In my present job I...