Forum Replies Created

Viewing 15 posts - 44,836 through 44,850 (of 59,063 total)

  • RE: The February 2009 Energy Update

    Steve Jones - Editor (3/3/2009)

    That's an interesting idea. Not sure how it will work with drywall and the studs, but something to look at.

    Dab of hot melt glue about once...

    March 3, 2009 at 6:26 pm

    #952812

  • RE: Rand() function error

    john.arnott (3/3/2009)

    In that regard, the two functions both now behave the same in providing a consistent result when referenced multiple times.

    Of course it will... they've used the same GUID 3...

    March 3, 2009 at 4:40 pm

    #952796

  • RE: Are the posted questions getting worse?

    Bruce W Cassidy (3/3/2009)

    [font="Verdana"]Do we get a pic of Lynn being "cannonised", and Jeff in a cardinal's frock?[/font]

    Heh... there already was one somewhere in the more than 2100 posts on...

    March 3, 2009 at 4:31 pm

    #952793

  • RE: Are the posted questions getting worse?

    Greg Edwards (3/3/2009)

    'What' are you tryinig to accomplish? at times can help get requirements out.

    Tried that several times... That's about the time that some of the arrogant buggers come out...

    March 3, 2009 at 4:13 pm

    #952783

  • RE: Are the posted questions getting worse?

    Bob Hovious (3/3/2009)

    I think Greg stated it well. Don't put the OP on the defensive.

    As for my calling a "cursor" a dirty word.... I wasn't trying to...

    March 3, 2009 at 4:09 pm

    #952780

  • RE: Removing cursor from TSQL - 1

    But.... just to be clear, Dugi... this one doesn't have anything to with a Tally table... just good programming.

    March 3, 2009 at 3:36 pm

    #952760

  • RE: Removing cursor from TSQL - 1

    [font="Arial Black"]Dugi... [/font]if I may suggest, it's better to give someone no answer than to give them what might be one of the worst answers for replacing cursors. Temp...

    March 3, 2009 at 4:26 am

    #952313

  • RE: Calculating Work Days

    Lynn Pettis (2/19/2009)

    I don't think our PeopleSoft Admin has gotten around to this, so I thought I'd drop a line. She found your routine quite elegant and saved her...

    March 2, 2009 at 8:44 pm

    #952207

  • RE: Preceding with N'

    karthikeyan (2/24/2009)

    Hi

    The below query is invoked by apps.

    SELECT TOP 100 S.*, STA.VALUE STATUS_DESC FROM MSGS MG (NOLOCK) join STATUS STA on STA.STATUS=MG.STATUS where 1=1 AND (oid IN...

    March 2, 2009 at 8:41 pm

    #952206

  • RE: Calculate Moving Average Over Last 12 Months

    nick_hodge (2/20/2009)

    Thanks both for your help. I have this actual T-SQL but it times out (Timeout expired). (I have to calculate the inventory value but have tried on a test...

    March 2, 2009 at 8:36 pm

    #952204

  • RE: Removing cursor from TSQL - 2

    john.arnott (3/2/2009)

    Lynn, I probably should have used something more than a winking emoticon to show that I am certainly aware of the term but was just trying to show Jeff...

    March 2, 2009 at 6:57 pm

    #952193

  • RE: Are the posted questions getting worse?

    Bob Hovious (3/2/2009)

    Gail and Steve, I understand why you always want to discuss the full problem when you see someone about to go seriously wrong. But there is...

    March 2, 2009 at 6:32 pm

    #952192

  • RE: question, urgent please!!!

    ganci.mark (3/2/2009)

    If there is a good, reason how is this? You can use cursor but I prefer using identity field which I added to table. If the...

    March 2, 2009 at 6:19 pm

    #952190

  • RE: Are the posted questions getting worse?

    Bob Hovious (3/2/2009)

    Gail and Steve, I understand why you always want to discuss the full problem when you see someone about to go seriously wrong. But there is...

    March 2, 2009 at 6:14 pm

    #952188

  • RE: Rand() function error

    john.arnott (3/2/2009)

    So what's wrong with RAND(), you may be wondering? As Jeff notes, the RAND (and also the NEWID) functions are deliberately designed to be invoked a single time in...

    March 2, 2009 at 5:46 pm

    #952183

Viewing 15 posts - 44,836 through 44,850 (of 59,063 total)