Not that I'll ever admit to swearing - but yes - I did say that - it's the fault of those "B-B Boys"...

Put the group hugs back - that's always a nice touch!

as for "search for there top 5" - what can I say but...

Thanks for posting those comments - though I must confess to being more curious about the -ve ones than the +ve !

I still do not understand why only the "Christians"...

you know remi - I actually have all the links saved in a text file somewhere for some of those posts were just so hilarious they would serve as a...

Alex - instead of dropping the "destination objects" have you tried just copying the data with the "append data" option instead of the "replace existing data" ?!?!

why am I being treated with contempt ?! - DAVID BURROWS - are you being a sore loser again ?!?! Where's the famous...

maybe David's in his "burrow"...?!?!

No - but you could be the "Burrows Bulldozer Boys"

ask dynamic david - he'll tell ya!

Farrell - stop being so paranoid!

No - the trap was specifically set for David - he walked into it - my work is...

keep getting sidetracked - meant to tell Vishal that if he posts the complete requirements maybe someone'll come up with a solution that does not involve dynamic sql at all...remi...

I think he's too "set in his ways"...

While I seldom agree with anything that GPF^.. has to say, I must admit that this one's a definite keeper!

I'm a little confused...

Thank you remi - so David - there's your answer - mine was actually a trap to lure in those who hadn't known about the * & exists combo...GOTCHA!

if one were to go only by the code snippet provided then it can all be condensed to...

IF NOT EXISTS(SELECT * FROM app_client WHERE first_name = @name AND last_name...