HI thanks for giving time for my problem.

I want to say that i want to show top 10 records nd their aggregate and rest of others records which not...

Hi Ken,

ya same as u told me.....this is might be solution of my problem.

Thanks a lot for giving me ur precious suggestion.

with lot of regards..

Praveen Rewadia

hi

i think month last is fixed, u have to find on current date and subtract from the last date.

then u can try

declare @today as int

set @today = datepart(dd,getdate())

this...