Forum Replies Created

Viewing 15 posts - 4,711 through 4,725 (of 5,685 total)

  • RE: Today's Random Word!

    Cigar!

    (and congratz! 🙂 )

    December 7, 2010 at 10:30 am

    #1259688

  • RE: Group Islands of Contiguous Dates (SQL Spackle)

    Jeff Moden (12/7/2010)

    Craig... it was your code that clarified it all here. Thanks again for the wonderful "cover" while I was busy.

    It was my pleasure. No code though,...

    December 7, 2010 at 10:25 am

    #1259685

  • RE: Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

    steven.malone (12/7/2010)

    It shows how America-centric SQL programmers are.

    1d4 means One Pound, Four Pence in England.

    And the irony there is that Gail's from South Africa... 🙂

    December 7, 2010 at 9:48 am

    #1259639

  • RE: Data Reader Source Problem

    Hey Brain,

    The error of import is at the top of the script:

    ODBC SQL Server Driver][SQL Server]Login failed for user 'cw_user'. ERROR [01S00]

    cw_user either lost its password via some...

    December 7, 2010 at 12:40 am

    #1259406

  • RE: Group Islands of Contiguous Dates (SQL Spackle)

    Alright, let's make the data a little more real world scenario.

    You have a contractor who comes by and does work as needed. You're looking for a per problem average...

    December 7, 2010 at 12:01 am

    #1259396

  • RE: Alter View from Trigger Hangs

    Because of the choices MS made regarding pivot, this is a case of dynamic SQL being the best choice. I would pursue it that way in your stored procedure....

    December 6, 2010 at 11:52 pm

    #1259394

  • RE: Group Islands of Contiguous Dates (SQL Spackle)

    Relax auto, you're not dumb. If you haven't had a need for it the test data doesn't make sense out of the gate. This comes up a lot,...

    December 6, 2010 at 11:21 pm

    #1259385

  • RE: Finding non-contiguous data

    CELKO (12/6/2010)

    You cannot do much math with the IT data type -- it is a seriously restricted integer (i.e NULL-able and all the math operators) in T-SQL now, but it...

    December 6, 2010 at 11:14 pm

    #1259382

  • RE: Alter View from Trigger Hangs

    doug.milostic (12/6/2010)

    Hi everyone

    I have a requirement to issue an "ALTER VIEW" statement preferably from a tables update/insert trigger.

    :blink: Why would you want to do that? I've got to hear...

    December 6, 2010 at 11:02 pm

    #1259379

  • RE: Finding non-contiguous data

    WayneS (12/6/2010)

    No problem, I can beat that. Me.smack.Craig!

    Me.Duck (WayneS.smack.Craig, const_ImitateNeo). 😛 :w00t:

    What can I tell ya? Looked too good to be that easy and my eyes played tricks...

    December 6, 2010 at 5:56 pm

    #1259311

  • RE: Celko - Division with a Remainder - Whaaaa?

    autoexcrement (12/6/2010)

    Would anyone care to take a whack at breaking this example down into pieces and/or plain-language to explain further? I suspect it has something to do with the movie...

    December 6, 2010 at 5:52 pm

    #1259310

  • RE: Finding non-contiguous data

    CELKO (12/6/2010)

    A little change in the DDL makes life more relational. Never sue BIT flags in SQL; that is assembley language.m Alo, MySQL has a nice conventon for numeric momth...

    December 6, 2010 at 5:24 pm

    #1259305

  • RE: Finding non-contiguous data

    mister.magoo (12/6/2010)

    Another "ugly" method...just for the sake of it...

    select *,

    CASE WHEN 32*Work0110+16*Work0210+8*Work0310+4*Work0410+2*Work0510+Work0610 NOT IN (0,1,2,3,4,6,7,8,12,14,15,24,28,30,31,32,48,56,60,62,63) THEN 'Y' ELSE 'N' END

    from #Employee

    I believe this method is for when your juniors...

    December 6, 2010 at 4:41 pm

    #1259300

  • RE: Finding non-contiguous data

    mister.magoo (12/6/2010)

    HI Craig, can you explain why? It produces the correct answer for me...

    It works just fine. Apologies, very nice solution. I'll be --------------> way for a bit.

    I...

    December 6, 2010 at 4:20 pm

    #1259287

  • RE: Finding non-contiguous data

    mister.magoo (12/6/2010)

    Probably not the most elegant answer you will receive....

    Just a head's up, that code will fail for EmployeeId 1005.

    I need more coffee, or glasses.

    December 6, 2010 at 4:16 pm

    #1259283

Viewing 15 posts - 4,711 through 4,725 (of 5,685 total)