[RESOLVED] Dynmaic SQL Help.

[Chubby]

Hey Guys,

I've done this a zillion times but beingMonday its way over my poor head ....


I want to set a variable from an exec of a dynamic SQL but the syntax is wobbly.

Like below (just for explanation)

DECLARE @C Char(20)
DECLARE @SQL Char(200)

Set @SQL = 'Select Top 1(Name) from tbl_Addr'

Set @C = Exec(@SQL)

Done it before but can't remember how...

Thanks

Chubby..

[brucevde]

You cannot return a value when executing a dynamic t-sql statement, nor can you access the results of the statement unless they are placed in a global temporary table.

Perhaps you are thinking of the syntax of the Exec command to get the return value from a stored procedure.

Declare @C int

Exec @C = usp_SomeStoredProcedure

[Chubby]

You cannot return a value when executing a dynamic t-sql statement, nor can you access the results of the statement unless they are placed in a global temporary table.

Perhaps you are thinking of the syntax of the Exec command to get the return value from a stored procedure.

Declare @C int

Exec @C = usp_SomeStoredProcedure

ahh Bruce, Thanks for the reply. You can return the results to a variable (or variables), I remembered how I didi it. You use sp_executeSQL...

Cheers

Chubby..