It only remains for PETA to call in with complaints about the canine references & women to protest about the off-colour humour - and Sean would've managed to insult...

- this's what happens when feelings are bottled up for too long - the floodgates open!!!...

why is 'God bless you' seen as a specific reference to Christians ?! My mother says that all the time and she's about as Christian as I am the Dalai...

sswords - this article has definitely turned out to be a pandora's box - the scariest thing is that the "kumbaya factor" that some of us shared has vanished in...

Just wanted to chime in with John and say that going to the Views folder in EM and building your query there is the best way to get most/all of...

nothing at all...Sean was under the misguided impression that his article may not be intriguing enough to catch everyones' attention, so he threw it in there as a combination of...

noel - I think the article's main purpose is to convey that "when in Rome, do..." - it's a question of adapting to the situation and "going with the flow"...

I, for one, am not complaining...nothing quite like the "whooshing" sound to break up the tedium of a Monday morning!!!

oh my God - ya think ?!?!

well - Sean's the only one who can tell us!

...thanks for reminding me...I too couldn't figure that one out and meant to ask...

you don't have to type the individual names...

if you notice shashank's sql is..

update table categories
set  faxnumber= 1234567
where cust_name IN (SELECT CUST_NAME FROM TABLE_NAME/CATEGORIES)

Good idea about practicing before an interview...if nothing else, I go through my resume to see if I still remember any details on projects I worked on 5 years ago...and...

Is there nothing else to identify these rows ?! A companyID perhaps ?! How many rows are there in all ?!

Just a note of caution when using the date format styles - 103 will give you dd/mm/yyyy whereas 101 will give you mm/dd/yyyy...

select convert(varchar,convert(datetime,'20050910'),103) as UKDate

select convert(varchar,convert(datetime,'20050910'),101) as USDate

Friday evening's a bad time...no time to test etc..

see if you can "play around" with this...

select max(region) Region, count(region) '# of signups', classID
from...