Yes, I ended up doing it that way as I could not find a way to do it dynamically. Only problem now is for any release I will need to...

Hi.

It was actually one my first options I looked at before trying to do it the more complicated way lol..however, this would only work if the child tables did not...

brilliant, thanks lads..

ah, so running this SP all the time will not actually create rows? only update the identity?

this is not a port from oracle or anything like that.

Basically all it is, is a table with this one row, which needs to hold a number for the next...

ah sorry, i typed it out from memory and put it back to front...I did actually have the update first as I think it only locks in teh transaction if...

its sql server 2008 full version. I have checked microsoft update and its fully up to date

then i really dont know what im doing wrong

Here is the full SP definition...just in case there is something wrong with how Im creating teh SP for it not to work.

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROC [dbo].[udp_test]

...

What key are you using to go through each line? I was using F11

There is defo something wrong with my sql server install or something then...as thats what I would expect, but it doesnt actually happen!

Hi.

Yes the code getting run is different, that code was put for ease of understanding. Basically, then code has one select statement in each if statement...with multiple joins on tables,...

yes I am in debug mode. I use key F11 to step into the SP from the SP call, and can actually see the little arrow sign on the left...

thanks for your help, found where it is I need to change

ah sorry, yeah its 2000 im using. Where can i see the maintenance plan?