Thanks

I like the idea and we could do something like that.  If we're going down that road, though, I think I'd rather have the deploy set to some staging area...

If you are saying that women need to be mindful of how they dress and and act,...

OK, that's working for one table (I've got a bunch of others to roll it out to).  I do have a follow up question though.  Is there any reason I...

Aha!  I didn't spot that you could type directly...

^That's the approach I started out with but I came unstuck when setting the temp table as the destination.  Temp tables (global or local) just aren't available in the target...

That's both a relief and not.  Nice to know I'm...

Thanks, that's interesting.  I'll pass it to the security expert and maybe that'll let...

^+1 to that question.  The suggestion sounds like it might be perfect for me but there's bits in there I'm not sure how to do - ie, how to push...

Well how big are the data sets you're talking about here? Are they small enough you...

Blimey, loads of stuff to respond to.  Thanks for all the input folks.

A bit of background that might help (I didn't include it before because it doesn't really...

  I was afraid you'd...

Weird.  Don't know who posted this but it seems to have...

I absolutely agree but I don't feel that should be mutually exclusive with GUI tools.  I...

The UPRN is included in a lot of the sources we get but many of them don't include it.  I wish they did, my life would be a whole lot...

Yes, I think I can make the assumption that there will only be a single part to remove.  So that should do what I'm looking for.  I hadn't considered using...