I don't think you can assign a variable from an exec that way.
usually it's like
exec @foo = sprocname
However if it turns out you can and it's some other error, I would be
very interested in finding out.
you might want to do something like this:
begin
Declare @rowcount as int
set @rowCount = (SELECT COUNT(*) FROM report)
print @rowcount
end
It just ocucured to me that I am assuming SQL Server.
darthsmily
Keith R. Pinster wrote:
>This is too weird. I'm trying to loop through my tables to get row
>counts. I have a cursor which runs through the tables fine. In the
>loop, I execute this statement:
>
>SET @rowCount = EXEC ('SELECT COUNT(*) FROM ' + @tableName)
>
>and I get an error saying that there is Incorrect syntax near the
>keyword 'EXEC'. However, if I just run the statement:
>
>EXEC ('SELECT COUNT(*) FROM ' + @tableName)
>
>it works fine. Can't I set a variable using dynamic SQL this way? I
>was sure I had done it before...
>
>KRP
>
>
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
>
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.298 / Virus Database: 265.6.4 - Release Date: 12/22/2004
------------------------ Yahoo! Groups Sponsor --------------------~-->
$4.98 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/Q7_YsB/neXJAA/yQLSAA/dpFolB/TM
--------------------------------------------------------------------~->
|
