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

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

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]



Show quoteHide quote

Is there a Filename.IsValid function anywhere?
knowing when file has been totally transferred
urgent: formatting XL cells
radio button user settings
Reusing VB.NET Form dialogs in VC apps
Working with data adapter/binding source at runtime
Combobox, Count Entries
Successfully executing queries
Starter Kit Problem
Using new control that inherits from Form