Erik - if I've understood the requirements correctly, I think what you want to do is this...

INSERT INTO UserSpecialty
SELECT @UserId, UserSpecialtyCD
FROM   Specialty
WHERE  SpecialtyName IN ('Butcher', 'Baker',...

Pappo - until someone (Brian ?!?!) comes up with something less convoluted, you could use something like this...of course, the assumption is that all the "key" names are going to...

Just as an fyi...epiphanies are always "sudden"....sorry - today is my "conservationist" day - no room for redundancies...

alright - chiming in! Rudy's mention of "a clockwork orange" really brought back memories - read & reread the book to tatters - ditto with "on the beach" & "the...

Ha ha - I was wondering who would "pick on" that...threw me off for a split second...or do I mean microsecond ?!?!

This is listed under Yukon and I don't know if sql 2005 has a method of getting this, but there was a similar decimal separator post on 2K that...

lo siento...should have put it in quotes and told you that it was "tongue in cheek"..

For portability and storing International Data...from BOL..

"International Data and Unicode

Storing data in multiple languages within one database is difficult to manage when using only character data and code pages. It...

ciara - please do not cross post...noel - your friend has responded to the other thread- as usual the comments are a "must...

Don't you worry about my posts "drying up"...I get plenty of fodder from other threads..

As for "keeping me on my toes"...yes indeed -...

Yes - but you didn't think of the "minimalist" usage at first did you...had to make you put your thinking cap on, didn't I ?!?!...

declare @waccessno varchar(20)
set @waccessno = '000095011A-99-000462'
if @waccessno...

You have to use dynamic sql for this....

declare @churn varchar(20),@churn1 varchar(20)
set @churn='1005'
set @churn1='base'+@churn
print @churn1
--select * from @churn1 - INCORRECT
exec('select * from ' + @churn1)

read this wonderful article ...

Steve - the rule is that you have to sign in as yourself - else I'm going to retain my "Bunny" alias for as long as it takes...