InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 10:48:49 GMT20http://www.sqlservercentral.com/Forums/Topic1405467-391-1.aspx[quote][b]gsd1 (1/10/2013)[/b][hr]Hi, Why the following code gives error? I have @temp table variable already declared, @p_SampleRecords variable already declared and assigned a value.Declare @strSql varchar(max)set @strSql = 'select top ' + cast(@p_SampleRecords as varchar) + ' * from @temp order by TStamp desc'Exec (@strSql)Thanks & Regards,[/quote]Your dynamic sql runs in a new batch. You think you have @p_SampleRecords variable already declared and assigned a value but that is not in the same batch. From what you posted I don't think you need dynamic sql at all.Thu, 10 Jan 2013 07:55:15 GMTSean Langehttp://www.sqlservercentral.com/Forums/Topic1405467-391-1.aspxHi, Why the following code gives error? I have @temp table variable already declared, @p_SampleRecords variable already declared and assigned a value.Declare @strSql varchar(max)set @strSql = 'select top ' + cast(@p_SampleRecords as varchar) + ' * from @temp order by TStamp desc'Exec (@strSql)Thanks & Regards,Thu, 10 Jan 2013 07:52:31 GMTgsd1