Well David - you too have said everything that is blindingly obvious but only after you have said it.

And everything you list is as old as the oldest profession...the bottom...

magyar - noel has the stored procedure all practically written out for you...

where he says:

Select @UniqueId = Scope_Identity(), @Err =@@Error

if @Err 0 Goto QuitWithRollback

-- Now use the ID from...

Alright guys - it's a challenge - I'm NOT going to tell you before officially disappearing as Sushila and I'm obviously not going to tell you when I transition as...

- I'm officially withdrawing from this post....I just CANNOT MATCH your typing speed!AAAARGH!

- big K - oh thanks - you know how much arguing with you has helped the numbers...

you post on this site:

1) The five inserts you have to do!

2) any other common fields besides uniqueID ?! that'll certainly help reduce the # of parameters being passed.

3) if...

guess it's better than rhyming with plain old vanilla...cheers!

You've nailed it - in concept atleast...now all you have to do is implement it!

Remi - WHAT is your typing speed ?! And man - you're ALL OVER THE PLACE - like some sort of ubiquitous spook....

cleaning for...

I know nothing about Access but could you not run a macro to do this for you?!?!

magyar (what a lovely name - makes me think of gypsies and dancing)...all you have to know is how to call a stored procedure from your application - we'll help...

So beautifully simple and so simply beautiful....(sounds of applause - darrell I'm sure you join me on this one)!!!

Salvatore - could you please do a "SELECT DISTINCT..." and then the rest of the query...?!?!

Also, re. the sample data I provided - I was just winging it...we really need...

or maybe a chris hedgate question...

actually for the very first time last night - i saw him online quite late...maybe he's sleeping in this morning ?!?!

so you're oldfashioned remi - waiting for a ring ?!?!...

I did something similar in QA and the execution plan shows the inserts (seemingly) being done serially! but then again I've never seen what a parallel query execution plan looks...