Help for this pls stored procedure

[sebastien1101]

In my stored procedure i have :
EXECUTE ('select ' + @TotalRecords + ' = count(*) from clients')

It doesn't work!
and i don't know how i can ?

[Michel Posseth [MCP]]

No this doesn`t work :-)

as with a execute statement you are now creating the following string to
execute 'select = count(*) from clients'
so it will result in an error

if it is so that the stored procedure itself should return this value then

SELECT COUNT(*) FROM clients should do the trick

if it is your intention that the variabel @TotalRecords should hold the
value then

SELECT @TotalRecords=COUNT(*) FROM clients

wil do what you want

you may also perform anny select query and then read the @@ROWCOUNT value

HTH

Michel Posseth [MCP]

"sebastien1101" <se***********@hotmail.fr> schreef in bericht
news:11**********************@v46g2000cwv.googlegr oups.com...

In my stored procedure i have :
EXECUTE ('select ' + @TotalRecords + ' = count(*) from clients')

It doesn't work!
and i don't know how i can ?