looks like there is high activity is going on that database. Try running this when no users are connected.

Yes, you can write a procedure to do. It should take around 1-2 hours to write.

Loop throught each database and then throught each table. Dynamically create sql statement to search...

 Try this

SELECT

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

FROM dbo.Orders

GROUP BY MONTH(InvoiceDate), YEAR(InvoiceDate), Type

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

check files in this or similar folders

C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG

Post the error log file

I do not think it is possible in 1 query. You will need a loop or temp table / variable to solve this

Thanks Mike

but what if they are just a dot and the size is not big enough  to draw that kind of a line

As I mentioned in my solution we do not have a real good logical answer but after reading other answer LIKE , break the wall, smash the bulb , pull the...

I wish someone have an answer better than mine (looking for 'out of the box' )

Steve

Just want to confirm is the answer logical or something stupid like

you switch on light switch for "room one" wait for 10 minutes , go to 2nd room switch on light switch...

Link server may be the cause for slow performance

I think it is left outer join. I may be wrong

If I am not mistaken. To make a parameter optional you have to pass a default value or NULL.

for example

Create proc ABC

(

@Parameter1 INT = NULL

)

I am not clear as who will be getting the books?

Well I still do not have an answer infact, now this scenario is working as an advantage for us