Forum Replies Created

Viewing 15 posts - 8,356 through 8,370 (of 9,399 total)

  • RE: Query is updating all records, not one

    Your first query was updating T_VM_QUEUE where STATUS_CD was equal to the value returned by the subquery used in the where clause. The second one is updating only one...

    February 26, 2014 at 5:52 am

    #1692238

  • RE: Parse Info Out of FileName

    Jeff Moden (2/25/2014)

    This should handle pretty much anything you can throw at it.

    -- DROP TABLE #FileName

    --===== Create a test table with some normal and "odd" file/path names.

    SELECT FileName =...

    February 26, 2014 at 5:46 am

    #1692236

  • RE: Intersecting - 1

    Nice and simple, but it's been a long while since I've seen a question on INTERSECT or EXCEPT. Thanks.

    February 26, 2014 at 5:29 am

    #1692232

  • RE: Today's Random Word!

    Stuart Davies (2/26/2014)

    BWFC (2/26/2014)

    Ed Wagner (2/24/2014)

    Daniel Bowlin (2/24/2014)

    SQLRNNR (2/24/2014)

    Ed Wagner (2/24/2014)

    crookj (2/24/2014)

    BWFC (2/24/2014)

    SQLRNNR (2/21/2014)

    BWFC (2/21/2014)

    SQLRNNR (2/21/2014)

    dingleberry

    Clinker

    Klink

    Jail

    Bail

    Water

    board

    surf

    Surf and turf

    Shrimp

    potted

    Plant

    February 26, 2014 at 5:22 am

    #1692231

  • RE: Parse Info Out of FileName

    EricEyster (2/24/2014)

    At some point, this type of logic becomes easier to write and maintain as a script task embedded in a package.

    Agreed. I'm not at all an SSIS guy...

    February 25, 2014 at 11:13 am

    #1692015

  • RE: Stored Procedure Boundaries

    Nice and simple question. Thanks.

    February 25, 2014 at 5:20 am

    #1691823

  • RE: Are the posted questions getting worse?

    Lynn Pettis (2/25/2014)

    Last night home. Start my journey back to Afghanistan Tuesday morning.

    Have a safe flight and be safe while you're there. How long is this deployment scheduled...

    February 25, 2014 at 5:16 am

    #1691820

  • RE: Today's Random Word!

    Daniel Bowlin (2/24/2014)

    SQLRNNR (2/24/2014)

    Ed Wagner (2/24/2014)

    crookj (2/24/2014)

    BWFC (2/24/2014)

    SQLRNNR (2/21/2014)

    BWFC (2/21/2014)

    SQLRNNR (2/21/2014)

    dingleberry

    Clinker

    Klink

    Jail

    Bail

    Water

    board

    surf

    Surf and turf

    February 24, 2014 at 9:13 am

    #1691610

  • RE: Today's Random Word!

    crookj (2/24/2014)

    BWFC (2/24/2014)

    SQLRNNR (2/21/2014)

    BWFC (2/21/2014)

    SQLRNNR (2/21/2014)

    dingleberry

    Clinker

    Klink

    Jail

    Bail

    Water

    February 24, 2014 at 6:48 am

    #1691508

  • RE: Columns in Sub Queries

    Bob Cullen-434885 (2/24/2014)

    OK. I got it wrong, and now I know why I got it wrong. What I cannot understand is why it behaves like that in the first place!...

    February 24, 2014 at 6:39 am

    #1691505

  • RE: Columns in Sub Queries

    Good questions. I've seen this gotcha rear its ugly head several times. It makes sense once you find it, but finding it is the hard part.

    February 24, 2014 at 5:22 am

    #1691489

  • RE: Today's Random Word!

    Daniel Bowlin (2/21/2014)

    crookj (2/21/2014)

    WotD - Minutiae

    atom

    Bomb

    February 21, 2014 at 7:51 am

    #1691121

  • RE: Backup/Restore

    That was a good question. Thanks.

    February 21, 2014 at 5:50 am

    #1691068

  • RE: Are the posted questions getting worse?

    wolfkillj (2/20/2014)

    SQLRNNR (2/20/2014)

    Revenant (2/20/2014)

    The Dixie Flatline (2/20/2014)

    GilaMonster (2/20/2014)

    stormsentinelcammy (2/20/2014)

    will this forum thread ever get back on topic?

    After over 40 000 posts, I don't think it has a topic any longer.

    I...

    February 21, 2014 at 4:42 am

    #1691054

  • RE: Today's Random Word!

    EL Jerry (2/20/2014)

    SQLRNNR (2/20/2014)

    Ed Wagner (2/20/2014)

    Revenant (2/20/2014)

    sing4you (2/20/2014)

    Kurt W. Zimmerman (2/20/2014)

    crookj (2/20/2014)

    SQLRNNR (2/20/2014)

    JAZZ Master (2/19/2014)

    Daniel Bowlin (2/19/2014)

    Ed Wagner (2/19/2014)

    Kurt W. Zimmerman (2/19/2014)

    SQLRNNR (2/19/2014)

    Kurt W. Zimmerman (2/19/2014)

    crookj (2/19/2014)

    WotD - tedium

    boring

    drilling

    fraking

    Oil

    gas

    beans

    magical fruit

    ...

    February 20, 2014 at 12:13 pm

    #1690829

Viewing 15 posts - 8,356 through 8,370 (of 9,399 total)