Link to home
Start Free TrialLog in
Avatar of barnesco
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
Avatar of Aneesh
Aneesh
Flag of Canada image

Avatar of barnesco
barnesco

ASKER

I don't get it.
ASKER CERTIFIED SOLUTION
Avatar of Sharath S
Sharath S
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial