[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..