Yeah, How you could keep the code format?

I don't seem to find a way

besides the above correction I believe that to use the connection object to execute the procedure is not the best way I would recommend you use the command object instead

if you are using sp3 and hopefully you are then you will have to consider the effects of cross database ownership chaining

that's a job for the front end

SELECT SUM(*) as FINALVALUE

FROM

(

select count(*) as Count_A from A

UNION ALL

select count(*)  as Count_B from B

UNION ALL

select count(*)  as Count_C from C

UNION ALL

select count(*) as Count_D from D

UNION ALL

select -1*count(*) as...

I just have a deja vu

Look at this thread

if you can use ADP then That will make your life A LOT easier

try to move as much as possible to the server side and encapsulate the logic in stored procedures.

without more details all I can do is just guess

is it like:

Select tblName , Cnt

Form (your query)

UNION ALL

SELECT 'ALL' , Count(*)

FRom (your query)

HTH

I really believe certifications add NOTHING. I took the tests and saw a lot of people pass them with me and most didn't have any clue of the theory/practice. Is...

every time you need to delete a lot of records it is a good thing to make a back up first that way...

Glad I helped

If you want to know about the cons and pros of dynamic sql take alook at this

following the racosta great suggestion a good thing would be to let a job doit for you

could some app be changing the sa password?

That's scary!