What is the best way to Aggregate query results

> I may have to use a temparay table

... or a table variable. What is your loop doing? Is it possible to write the query without a loop?

Yes I am doing that but its returning seperate queries,

declare @month int
set @month = 0
while (@month <12)

BEGIN
select stuff


SET @month=@month + 1
end

I may have to use a temparay table

Use the database aggregate functions so your query only returns one row.