It must be done on presentation level, not in database.

Select your report resultset into temp table ( SELECT ... INTO #Table FROM ...) and LEFT JOIN this table to grouped select from itself.

SELECT A.*, B.bud-rent, COUNT(B.???)*100/COUNT(A.???) as bud-occ

FROM #Table...

SELECT T1.Broker

FROM (select Broker from loans

         where close_date between <your range>

         group by Broker) T1

LEFT JOIN (select Broker from loans

         where close_date between <last 90 days>

         group by Broker) T2 on...

I would suggest to read a little about data normalisation.

It dramatically improves performance for ALL queries, not just this one.

So, Ryan, you have used MAX() as well.

What's a difference?

You solution is just more complicated and more slow, but returns exactly the same result.

What exactly does not work?

You must loop through those 2 millons rows.

That's why there is no memory usage and your CPU is very busy.

You better create a view

CREATE VIEW CatSummary

AS

select CategoryID, count(*) as NbTot, sum(UnitsInStock) as NbUinS, sum(UnitsOnOrder) as NbUinO

from Products

GROUP BY CategoryID

and join this view to...

SELECT SUM(NetSales * CASE WHEN Type = 0 THEN 1 ELSE - 1 END)

FROM dbo.Orders

WHERE (MONTH(InvoiceDate) = @MonthNo) AND (YEAR(InvoiceDate) = @YearNo)

GROUP BY MONTH(InvoiceDate), YEAR(InvoiceDate) --, Type - remove...

Check out Output parameters in BOL.

There must be dosen clues just in this forum for the last week.

Would you bother to browse forum first?

Remove all declarations -

     declare @org_id int, @org_ver_id int, @last_updt_reg_id int

and do it set oriented.

update sa_entity

set last_updt_reg_id = dbo.function(i.org_id)

FROM inserted i

where sa_entity.org_id = i.org_id and sa_entity.org_ver_id =...

Actually David's solution suppose to do exactly what you are asking for.

You must have modified it a little, so it now requires replies.

Return to the original query logic.

Both are bad.

Put your values into temp table and join it to the tables from your query.

2 Mauro

All you ToDo's must be done in UDF's. If you cannot predict its contents you may set a trigger on the table to recompile UDF related to updated or...