Bitbucket,

Those are simple inserts I was doing something a little bit different here...

INSERT INTO #Answers(Answer)

EXEC @Procedure @Parameter

This does work but it only inserts one column. I would like to insert...

Perfect, thanks Lowell

Many thanks Gianluca and Chris, it is working just like expected. 😀

Gianluca,

Almost there, unfortunately we are not on SQL 2005 yet so ROW_NUMBER() doesn't work.. :(. is there an equivalent to this for 2000???

Gianluca, yes and I get this error on the first insert..

Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.

**EDIT** I posted...

Gianluca, I tried your approach, and it is still giving me the dupes, so here are my tables and sample data.

CREATE TABLE [dbo].[InventoryStage](

[SerialNumber] [varchar](20) NULL,

[TagNumber] [varchar](8) NULL,

[UnitCode] [varchar](7) NULL,

[ItemNumber] [varchar](6)...