Hi Simon,

Thanks for the feedback (I think).

We are, as I said, very new to writing SQL scripts. If using sets is the way to go how do we change the...

Hi Guys,

Thanks for the input on this. We have done some work on this ourselves now and have come up with the following. We will try and make it a...

Hi Simon,

Thanks for teh feedback. The code works well except that on certain tables where 'CATEGORY' is the PK I get:

Server: Msg 2627, Level 14, State 1, Line 14

Violation of...