InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 14:36:04 GMT20http://www.sqlservercentral.com/Forums/Topic1052323-391-1.aspxThank u so much. It works.Mon, 24 Jan 2011 21:26:04 GMTisaac.ahttp://www.sqlservercentral.com/Forums/Topic1052323-391-1.aspx[quote][b]isaac.a (1/24/2011)[/b][hr]beginDECLARE @deldate varchar(10)='01/01/1960', @tblname varchar(50) = 'CACCOUNTSTMT', @ssql varchar(200) set @ssql = 'set @deldate = (select max(Convert(varchar(10) ,RowCreateDate,103)) from ' +@tblname +')' print @ssql --set @deldate = @ssql exec(@ssql) print 'deledate' print @deldateendgives the following errorMust declare the scalar variable "@deldate".can any one help on this?[/quote]In the dynamic sql, you are setting a variable that doesn't exist in the context of the dynamic sql connection.Use the solution David supplied to pass it in and get the results back out.Mon, 24 Jan 2011 09:07:42 GMTWayneShttp://www.sqlservercentral.com/Forums/Topic1052323-391-1.aspxtry exec sp_executesql @ssql,N'@deldate varchar(10) OUTPUT',@deldate OUTPUT instead of exec(@ssql) Mon, 24 Jan 2011 06:44:25 GMTDavid Burrowshttp://www.sqlservercentral.com/Forums/Topic1052323-391-1.aspxbeginDECLARE @deldate varchar(10)='01/01/1960', @tblname varchar(50) = 'CACCOUNTSTMT', @ssql varchar(200) set @ssql = 'set @deldate = (select max(Convert(varchar(10) ,RowCreateDate,103)) from ' +@tblname +')' print @ssql --set @deldate = @ssql exec(@ssql) print 'deledate' print @deldateendgives the following errorMust declare the scalar variable "@deldate".can any one help on this?Mon, 24 Jan 2011 06:39:21 GMTisaac.a