Forum Replies Created

Viewing 15 posts - 23,056 through 23,070 (of 26,486 total)

  • RE: Sql QUERY Help

    GilaMonster (1/9/2009)


    Lynn Pettis (1/9/2009)


    GilaMonster (1/9/2009)


    It's do-it-yourself sample data. Values at the top of the post, insert statements at the bottom. 😛 😀

    That I think not. Too many data columns...

  • RE: Image is Everything

    gcopeland (1/9/2009)


    As the resident HR guy, I note a few pretty vicious posts. That is ok, I have been dispensing unsolicited advice to my fellow techies for decades, and...

  • RE: Datediff not calculating corectly

    scared him off maybe? Hoepfully Peso's link he will follow.

  • RE: Sql QUERY Help

    GilaMonster (1/9/2009)


    Lynn Pettis (1/9/2009)


    hmmmm, something missing I am. No data I see in the insert statements.

    It's do-it-yourself sample data. Values at the top of the post, insert statements at...

  • RE: data block

    dumbing down I think. Mind readers we aren't, though benefit it might be...

  • RE: Sql QUERY Help

    GilaMonster (1/9/2009)


    Great, we've got table structure and sample data.

    Based on the sample data you have posted, what are the exact results that you want? Post exactly what values you need...

  • RE: Adding running number on groups of records in a table

    Jeff Moden (1/9/2009)


    Lynn Pettis (1/9/2009)


    Good to see you back in a good mood! You're no fun when your grumpy!:w00t:

    Opportunities to hurl some well deserved pork overhand always bring the...

  • RE: File System Task failing

    I think it was Jack Corbett who suggested this in another thread (I may have the wrong name) but you may want to look at the File Properties Task offered...

  • RE: Adding running number on groups of records in a table

    Jeff Moden (1/9/2009)


    BWAA-HAAA!!! Everything that comes around, goes around. Talk about nearly instant gratification... Pork chops... AWAY!! 😛

    http://www.sqlservercentral.com/Forums/Topic632886-149-1.aspx?#BM633444

    I feel MUCH better, now. 😉

    Good to see you...

  • RE: Hospitality Book

    Glen Parker (1/9/2009)


    Hi Troops

    I have an on-line Hospitality Book which is audited 6 monthly ie audit column set to 1 (default = 0)

    I am attempting to select only records with...

  • RE: Adding running number on groups of records in a table

    Jeff, I think you handled that one very well. It is one that could have gotten nasty. I'd make another comment, but...

    Hey, while I'm here, have you...

  • RE: Datediff not calculating corectly

    Peso (1/9/2009)


    Thank you!

    I have that link on my favorites sites collection.

    BTW, are yo having a bad hair day? (Just saw your avatar) 😉

    hmmm, no. Several starwars films I saw...

  • RE: Datediff not calculating corectly

    Peso (1/9/2009)


    Lynn Pettis (1/8/2009)


    Didn't someone write an article that talked about how DATEDIFF and DATEADD worked? I can't find one on SSC, so it may have been an article...

  • RE: PeopleSoft sp_cursorexecute Slow after Upgrade to 2005

    Sorry, had a few meetings, and then had to leave work for another meeting (non-work related). Let us know if that helps your performance issue.

    Also, if you copy the...

  • RE: Are the posted questions getting worse?

    Amazing, isn't it? Three days ago I scraping ice off my car, today I walked at lunch without a jacket!

Viewing 15 posts - 23,056 through 23,070 (of 26,486 total)