Hi,

I've only just realised that I never said thank you for your help with this query. So, thanks very much guys - much appreciated

Hi

I've only just realised that i never said thank you for your help with this query! So, thanks very much guys - much appreciated.

how can i put the whole thing inside a transaction in the stored procedure?

Can anyone pls help with maybe a skeleton of what the stored procedure should look like?

PERFECT!.

Many thanks GSquared - just what i was looking for - saved me hours of typing!

thank you

Many thanks guys. Below is an example: The whole case statement is actually contained inside a function that is called with the appropriate fieldname to get the department for that...

Very clear indeed. It suddenly became very obvious! Many thanks Gianluca.

omg! I have definitely been starring at this TOO long! I was suddenly obvious AFTER you pointed it out.

I guess this case is closed then.

Many thanks for all your help...

I am getting close guys! David's code below:

seems to do what i wanted, but threw me a suprise when I tested...

Thanks so much for taking the time to answer this guys – I really appreciate it. Unfortunately the field that is left empty when the rest of fields are shifted...