Forum Replies Created

Viewing 12 posts - 2,431 through 2,442 (of 2,442 total)

  • RE: Excluding in a query with multiple conditions?

    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.

  • RE: Graduated..working..now what?

    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...

  • RE: Can't INSERT into temp table - why?

    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!

  • RE: Query Help - 3

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

    DECLARE @maxrows int,...

  • RE: Type A, B, or C

    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...

  • RE: Type A, B, or C

    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,...

  • RE: Management

    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...

  • RE: Get DATE part of the DATETIME

    Chris Morris (2/6/2008)


    jcrawf02 (2/6/2008)


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

    Nah, pretty...

  • RE: Get DATE part of the DATETIME

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

  • RE: Get DATE part of the DATETIME

    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...

  • RE: Get DATE part of the DATETIME

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

  • RE: Importance of UPSERT

    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...

Viewing 12 posts - 2,431 through 2,442 (of 2,442 total)