{"id":81,"date":"2009-10-26T08:27:36","date_gmt":"2009-10-26T08:27:36","guid":{"rendered":"http:\/\/blog.rabihtawil.com\/?p=78"},"modified":"2010-07-22T13:32:37","modified_gmt":"2010-07-22T13:32:37","slug":"create-temporary-table-in-dynamic-query","status":"publish","type":"post","link":"http:\/\/www.raytawil.com\/?p=81","title":{"rendered":"Create temporary table in dynamic query"},"content":{"rendered":"<div class=\"snap_preview\">\n<p>there are cases when you are forced to create temporary table in dynamic query.<\/p>\n<p>below is sample of creating temporary then select it in dynamic query.<\/p>\n<blockquote>\n<pre>declare @tableName varchar(30)\nset @tableName = 'TableB'\ndeclare @query nvarchar(4000)\nset @query = 'CREATE TABLE #'+@tableName+'\n                    ( id int,\n                      data varchar(30)\n                    )\n              insert into #'+@tableName+' values(1, ''Me'')\n              SELECT * from #'+@tableName\n exec sp_executesql @query<\/pre>\n<\/blockquote>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>there are cases when you are forced to create temporary table in dynamic query. below is sample of creating temporary then select it in dynamic query. declare @tableName varchar(30) set @tableName = &#8216;TableB&#8217; declare @query nvarchar(4000) set @query = &#8216;CREATE TABLE #&#8217;+@tableName+&#8217; ( id int, data varchar(30) ) insert into #&#8217;+@tableName+&#8217; values(1, &#8221;Me&#8221;) SELECT * [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[112],"tags":[35,82],"_links":{"self":[{"href":"http:\/\/www.raytawil.com\/index.php?rest_route=\/wp\/v2\/posts\/81"}],"collection":[{"href":"http:\/\/www.raytawil.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.raytawil.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.raytawil.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.raytawil.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=81"}],"version-history":[{"count":1,"href":"http:\/\/www.raytawil.com\/index.php?rest_route=\/wp\/v2\/posts\/81\/revisions"}],"predecessor-version":[{"id":165,"href":"http:\/\/www.raytawil.com\/index.php?rest_route=\/wp\/v2\/posts\/81\/revisions\/165"}],"wp:attachment":[{"href":"http:\/\/www.raytawil.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=81"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.raytawil.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=81"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.raytawil.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=81"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}