btw - I started another thread over in DTS ...

On your marks!

Get set!

GO!

Well that kinda helps .... could you give me an example of code that might achieve this please.

"How do I do this in SQL Server please........"

.........eh?

Awwww, thats no fun .... where's the flying fists?

Seriously tho, thanks to both of you. Following the posts after my feedback, I was...

Well this is really really gonna upset you then. Because I picked the one i felt had paid the closest attention to the original.

Hi Folks,

I went with the second example, and after a few minor changes had it up and running in about 5 mins.

Here is what I ended up with......

------------------------------

CREATE Procedure...

Brilliant !

Thanks for the quick response. I am now back home (could remote access but, contrary to my employers beliefs, I have a life) I will test this soon and...