{"id":799,"date":"2008-09-26T23:06:00","date_gmt":"2008-09-26T23:06:00","guid":{"rendered":"http:\/\/mooredynasty.net\/?p=799"},"modified":"2014-12-18T23:06:18","modified_gmt":"2014-12-18T23:06:18","slug":"sql-temp-table-nested-proc-calls","status":"publish","type":"post","link":"https:\/\/mooredynasty.net\/index.php\/2008\/09\/sql-temp-table-nested-proc-calls\/","title":{"rendered":"SQL Temp Table, Nested Proc Calls"},"content":{"rendered":"

CREATE PROCEDURE [dbo].[marctest2]
AS
SET NOCOUNT ON
INSERT INTO #marc VALUES (4, ‘Test 4’)
INSERT INTO #marc VALUES (5, ‘Test 5’)
INSERT INTO #marc VALUES (6, ‘Test 6’)
GO
CREATE PROCEDURE [dbo].[marctest1]
AS
SET NOCOUNT ON
CREATE TABLE #marc
(
    id int,
    data varchar(10)
)
INSERT INTO #marc VALUES (1, ‘Test 1’)
INSERT INTO #marc VALUES (2, ‘Test 2’)
INSERT INTO #marc VALUES (3, ‘Test 3’)
exec marctest2
INSERT INTO #marc VALUES (7, ‘Test 7’)
INSERT INTO #marc VALUES (8, ‘Test 8’)
select * from #marc
go
EXEC [dbo].[marctest1]<\/p>\n","protected":false},"excerpt":{"rendered":"

CREATE PROCEDURE [dbo].[marctest2] AS SET NOCOUNT ON INSERT INTO #marc VALUES (4, ‘Test 4’) INSERT INTO #marc VALUES (5, ‘Test 5’) INSERT INTO #marc VALUES (6, ‘Test 6’) GO CREATE PROCEDURE [dbo].[marctest1] AS SET NOCOUNT ON CREATE TABLE #marc (     id int,     data varchar(10) ) INSERT INTO #marc … <\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[],"class_list":["post-799","post","type-post","status-publish","format-standard","hentry","category-development"],"_links":{"self":[{"href":"https:\/\/mooredynasty.net\/index.php\/wp-json\/wp\/v2\/posts\/799","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mooredynasty.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mooredynasty.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mooredynasty.net\/index.php\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/mooredynasty.net\/index.php\/wp-json\/wp\/v2\/comments?post=799"}],"version-history":[{"count":1,"href":"https:\/\/mooredynasty.net\/index.php\/wp-json\/wp\/v2\/posts\/799\/revisions"}],"predecessor-version":[{"id":800,"href":"https:\/\/mooredynasty.net\/index.php\/wp-json\/wp\/v2\/posts\/799\/revisions\/800"}],"wp:attachment":[{"href":"https:\/\/mooredynasty.net\/index.php\/wp-json\/wp\/v2\/media?parent=799"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mooredynasty.net\/index.php\/wp-json\/wp\/v2\/categories?post=799"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mooredynasty.net\/index.php\/wp-json\/wp\/v2\/tags?post=799"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}