Mar 16, 2004 #1 hmckillop Programmer Oct 30, 2001 1,540 GB How do I insert the results of a stored procedure into a table? i.e. INSERT INTO (exec 'aba_lockinfo')
How do I insert the results of a stored procedure into a table? i.e. INSERT INTO (exec 'aba_lockinfo')
Mar 16, 2004 #2 jgoodman00 Programmer Jan 23, 2001 1,510 You cannot do this AFAIK, because an sp returns a result, not a table/recordset etc. A UDF should be able to do this though, as they can be selected from... James Goodman MCSE, MCDBA http://www.angelfire.com/sports/f1pictures Upvote 0 Downvote
You cannot do this AFAIK, because an sp returns a result, not a table/recordset etc. A UDF should be able to do this though, as they can be selected from... James Goodman MCSE, MCDBA http://www.angelfire.com/sports/f1pictures
Mar 16, 2004 #3 swampBoogie Programmer Jan 6, 2003 1,660 SE Code: insert into t exec procedurename param, param Upvote 0 Downvote