re: Gift Peddie: Yep IT men are how do spell shallow?

I resemble that remark - I'm superficial, not shallow.

GP, It's actually such a rarity to...

A support group or 12-Step program for the avatar-challenged?

"Hi, my name is James...and I don't have an avatar on SQLCentral".

"Hi James".

Ok, I've been wanting to upload one too but don't know...

Sergiy & Ben,

Ben, thanks for brainstorming on this...you brought up some things I really need to consider - possibly a whole new approach.

Sergiy - Sql did not recognize ID_col...

Bert - was that boss short, fat, with pointy hair?

Observations on teamwork gleaned over the years...

I have worked in some companies where someone with the most knowledge was 'proprietary' about that knowledge. They were reluctant to share for fear...

I've experienced this as well - a small thing but irritating none the less.

I've actually avoided that path because of 1) the late nights and weekends it possibly requires and 2) I feel like there's more creativity in development (bet some replies come in about...

Andrew,

This may be overkill - but this proc will find a field occurence in any sql module.

I do not take credit for this proc - I got it via SQLCentral...

Hey Matt, you're dead on about Robin...smart and attractive...cloning her might be the answer!

I second Tony's comments...first thing in the morning I devote time to perusing your newsletter. I always get something useful out of it. Somestimes I put an article or script...

I totally agree with you on this. It's odd to me how many men I encounter that don't understand friendships between men and women - it's either intimacy or nothing. When...

Excellent article on T-SQL/Excel:

http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/

The one on Letterman the other night that tosses a can of beer to you.

Since we are talking about stange behavior regarding 'in', learned this the hard way about 'not in':

select count(*) from table1 where fieldA not in (select fieldA from table2)

can yield incorrect...

Many thanks to Clive and Steve for the replies...we will check these out. In the meantime, more suggestions are welcome.