Posted by markjerz on 01/08/07 15:15

Hi,

Should be quite simple but can someone please tell me the best way to
count the number of rows in an UNION ALL statement.

I tried using @@ROWCOUNT but that doesn't seem to contain the correct
number.

Also, I assume that running the query again but just returning count(*)
instead of the data is horribly inefficient (plus the code is then
bloated.)?

Thanks,
Mark

• Next in forum: UPDATE a table with aggregate results for multiple columns
• Prev in forum: Damn! SQLServer2000 can't add a NOT NULL COLUMN even in one empty existing table!
• Thread view: Count the number of rows in a UNION ALL statement

[Reply to this message]