Scott Elkin

Never had a good reason to do this up until now, but if you need to get a value from a generated sql string, there are a few hoops you must jump through. Example:

declare @table 		varchar(20) 	,@username 	varchar(30)

–can't use double quotes w/out this  SET QUOTED_IDENTIFIER OFF

–set your variablesselect @table = 'tblcustomers'	,@username = 'webmaster'

–create a temp table to hold your valuecreate table #temp (field varchar(50))

–insert the value into temp tableinsert into #tempexec ('select email from ' + @table + ' where username = “' + @username + '”')

–voilaselect field from #temp

drop table #temp

Reference: Getting Creative with EXEC and EXEC()