barnesco
asked on
Passing variable through dynamic query
How do I get the below to return @AttendDate--currently, it returns 0
DECLARE
@AttendDate varchar(10) = '10/1/2013',
@SQLQuery nvarchar(max)
SET @SQLQuery = 'SELECT
' + @AttendDate + ' AS AttendDate'
EXECUTE sp_executesql @SQLQuery
Thanks
DECLARE
@AttendDate varchar(10) = '10/1/2013',
@SQLQuery nvarchar(max)
SET @SQLQuery = 'SELECT
' + @AttendDate + ' AS AttendDate'
EXECUTE sp_executesql @SQLQuery
Thanks
ASKER
I don't get it.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://sequelserver.blogspot.ca/2007/01/return-value-from-dynamic-sql.html