Try

Select {col1, Col2, ...Coln} From {Table}

Where Department+col1 <> '3A'

AND Department+col2 <> '2B'

AND Department+col3 NOT IN ('2C','3C')

See if that makes any difference.

Revision: "i think any manager WORTH HIS SALARY would quickly pick out who was genuine and who wasn't." Those managers that are not would be the reason for your second...

Thanks guys, it's always something simple. As for why use the quotes, that's because of an ID-10-t error.

At least I'm not nuts, just sloppy.

Thanks again!

I think this will work, if I understand what you're doing correctly - using Ryan's example, modify the assignment of @s-2 to be something like this:

DECLARE @maxrows int,...

Steve, I have to say that I disagree about the personality type in your article not being promotable simply because they wish to contain work to worktime. This may be...

The point isn't to let you not argue, it's to let you argue constructively, since you understand how best to get your point across to the other personality types.

Or,...

Andy, have to concur with the group. Great article! I moved from a supervisory position into a reporting role using SQL, due to a new dept forming. Although I...

Chris Morris (2/6/2008)

Nah, pretty...

Because we just have to be different. I'm going to go get my 'twelve barley-corns, round and dried' to measure something now . . .

I understand the datatype of DATETIME, but thought the point was to truncate the value to just the date, and not give me 00:00:00 at the end. I'm not...

why am I getting times in the result for all of these, when I want only the date portion?

Newbie of a newbie here, I'm working on a web development degree, so not close to being a dba or anything, but wanted to hang out around people who know...