SQLServerCentral / Discuss Content Posted by Narayana Raghavendra / Article Discussions / Article Discussions by Author / Multiple Table Insert / Latest Posts

RE: Multiple Table Insert

KoldCoffee — Mon, 19 Dec 2011 18:11:09 GMT

I have made a copy of Narayana's sproc on my Northwind db. Also, I've made two copies of Employees table calling them Employees1 and Employee2. When I exec the sp_multi_inserts sproc on Northwind database I get the following error:Msg 156, Level 15, State 1, Line 2Incorrect syntax near the keyword 'SELECT'.Execute statement looks as follows:USE NorthwindGODECLARE @DELIMITER AS VARCHAR(200)DECLARE @INSERT_PART AS VARCHAR(2000)SET @DELIMITER = 'ZZZYYYXXX'SET @INSERT_PART = 'WHEN EMPLOYEEID < 5' + @DELIMITER + 'INTO EMPLOYEES1 (LASTNAME, FIRSTNAMEVALUES (LASTNAME, FIRSTNAME)' + @DELIMITER + 'WHEN EMPLOYEEID >4' + @DELIMITER + 'INTO EMPLOYEES2 (LASTNAME, FIRSTNAME) VALUES (LASTNAME, FIRSTNAME)'EXEC SP_MULTI_INSERTS 'SELECT EMPLOYEEID, LASTNAME, FIRSTNAME FROM EMPLOYEES', @INSERT_PART, @DELIMITER, ''What is wrong with how I'm executing the sproc?

RE: Multiple Table Insert

Nilesh-637319 — Fri, 22 Feb 2008 22:11:48 GMT

I have problem with store procedure, I cant use strord procedure in my project.....SO can u tell me how to insert multiple table by code not procedure.....

RE: Multiple Table Insert

rajenshah — Tue, 18 Nov 2003 02:27:00 GMT

Thanks for code and explanation. I guess i could put the conditions in a separate table and use the data to create the parameters required for this stored procedure.Edited by - rajenshah on 11/18/2003 02:28:04 AM

Multiple Table Insert

Raghavendra Narayana — Sun, 16 Nov 2003 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/nraghavendra/multipletableinsert.asp