select OriginalTable.nextval into new_doc_nv from dual; insert into OriginalTable (id,name) values (new_doc_nv,pname);
DECLARE @tmp TABLE(new_doc_nv INT NOT NULL,new_item_nv INT NOT NULL);
INSERT INTO @tmp ( new_doc_nv ) SELECT dbo.OriginalTable.ID FROM dbo.Documents;
INSERT INTO dbo.OriginalTable (ID, Name ) values(new_doc_nv,@name)
SELECT...INTO
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)