Forum Replies Created

Viewing 15 posts - 1,321 through 1,335 (of 3,543 total)

  • RE: Are the posted questions getting worse?

    Grant Fritchey (6/30/2009)

    mjarsaniya (6/30/2009)

    Very few people in here would claim to be experts. I sure don't.

    :laugh: You are far too modest Grant 😉

    June 30, 2009 at 8:26 am

    #1017605

  • RE: Are the posted questions getting worse?

    GilaMonster (6/30/2009)

    David Burrows (6/30/2009)

    There is a member with the name 'Anonymous'

    Yeah, but I don't think it's that. If you check the screen shot, there's no profile details, the name is...

    June 30, 2009 at 8:24 am

    #1017601

  • RE: Are the posted questions getting worse?

    GilaMonster (6/30/2009)

    Can someone send me a PM please. There looks like there's something buggy, every PM I've received in the last week has been from 'Anonymous' and has no profile...

    June 30, 2009 at 7:12 am

    #1017539

  • RE: get real!

    SanjayAttray (6/29/2009)

    in SQL server 2005 result is 1.234568E+09

    while in SQL 2000 result is 1.2345679E+9

    Does it make any difference ?

    It is dependant on the client tool

    QA shows...

    June 30, 2009 at 6:51 am

    #1017527

  • RE: Are the posted questions getting worse?

    GilaMonster (6/29/2009)

    Grant Fritchey (6/29/2009)

    I used to have the 'Lack of planning' saying on the front of my PC.

    I use to have MYOB

    Mind Your Own Business to remind me not...

    June 29, 2009 at 8:47 am

    #1016872

  • RE: Are the posted questions getting worse?

    Doc (6/23/2009)

    RBarryYoung (6/23/2009)

    Impressive Bio Mr. Young

    Nice pic too! 😉

    June 23, 2009 at 7:54 am

    #1013942

  • RE: How to transpose from Row to Columns with out using Pivot

    Also you can achieve the same using PIVOT

    e.g.

    SELECT ACCT_DEBTOR,

    [1] AS [LandLineNumber1],

    [2] AS [LandLineNumber2],

    [3] AS [LandLineNumber3]

    FROM (SELECT ACCT_DEBTOR,OCCURRENCE,LANDLINE_CONTACT_NO FROM Post_File082_Landline_No) a

    PIVOT(MAX(LANDLINE_CONTACT_NO) FOR OCCURRENCE IN ([1],[2],[3])) p...

    June 23, 2009 at 6:49 am

    #1013876

  • RE: Are the posted questions getting worse?

    :ermm: The THREAD is practising medicine now :blink:

    Get therapy and vent your spleen all at the same time :w00t:

    June 23, 2009 at 5:36 am

    #1013845

  • RE: Are the posted questions getting worse?

    ... RBAR to the max behind the scenes ...

    Well RBAR is better than FUBAR 😛

    June 22, 2009 at 3:45 am

    #1013177

  • RE: Are the posted questions getting worse?

    Shame they couldn't be directed to 'he who cannot be named'

    He'd be able to provide suitable answers 😀

    June 19, 2009 at 6:31 am

    #1012330

  • RE: decimal

    ta.bu.shi.da.yu (6/18/2009)

    Ah... but how would you get around that? Is there any way of disabling the rounding?

    Use FLOOR 🙂

    June 18, 2009 at 7:20 am

    #1011721

  • RE: Are the posted questions getting worse?

    This is getting way tooooo serious 🙂

    The THREAD's gonna get ya 😛

    June 18, 2009 at 1:58 am

    #1011503

  • RE: one character of data

    VM (6/17/2009)

    Thank you for all this wonderful information!

    I apologise for such a sloppy question. The thing I wanted to mainly emphasise with this question was that "correct datatypes be chosen...

    June 17, 2009 at 6:55 am

    #1010867

  • RE: one character of data

    Paul White (6/17/2009)

    There is a risk of taking this too seriously you know...

    Most of the recent QODs seem to have been posted by the author of this, and from memory,...

    June 17, 2009 at 6:52 am

    #1010865

  • RE: one character of data

    Hugo Kornelis (6/17/2009)

    David Burrows (6/17/2009)

    But those advocating nchar are also making an assumption :blink:

    Anyone using nchar on an assumption deserves Pork Chops thrown at them in my view :w00t:

    Hi David,

    If...

    June 17, 2009 at 6:48 am

    #1010863

Viewing 15 posts - 1,321 through 1,335 (of 3,543 total)