Forum Replies Created

Viewing 15 posts - 1,171 through 1,185 (of 1,250 total)

  • RE: Number of Records Affected

    jayoub (2/6/2014)

    I would like to know how to run an update or delete query and have a chance to commit or not. Here is the issue. When I...

    February 6, 2014 at 8:48 am

    #1686646

  • RE: Today's Random Word!

    Sean Lange (2/6/2014)

    Ed Wagner (2/6/2014)

    SQLRNNR (2/6/2014)

    BWFC (2/6/2014)

    SQLRNNR (2/6/2014)

    Kurt W. Zimmerman (2/6/2014)

    BWFC (2/6/2014)

    Ed Wagner (2/6/2014)

    L' Eomot Inversé (2/6/2014)

    BWFC (2/6/2014)

    Animated

    Cartoon

    Bugs

    Bunny

    Fudd (Elmer J)

    Wabbit

    Won...wabbit, won wabbit, won, won, won 🙂

    Kill the wabbit

    It's wabbit season

    Duck...

    February 6, 2014 at 8:08 am

    #1686623

  • RE: Today's Random Word!

    SQLRNNR (2/6/2014)

    Kurt W. Zimmerman (2/6/2014)

    BWFC (2/6/2014)

    Ed Wagner (2/6/2014)

    L' Eomot Inversé (2/6/2014)

    BWFC (2/6/2014)

    Animated

    Cartoon

    Bugs

    Bunny

    Fudd (Elmer J)

    Wabbit

    Won...wabbit, won wabbit, won, won, won 🙂

    February 6, 2014 at 7:58 am

    #1686615

  • RE: Today's Random Word!

    Ed Wagner (2/6/2014)

    L' Eomot Inversé (2/6/2014)

    BWFC (2/6/2014)

    Animated

    Cartoon

    Bugs

    Bunny

    February 6, 2014 at 5:32 am

    #1686542

  • RE: Today's Random Word!

    Animated

    February 6, 2014 at 1:11 am

    #1686470

  • RE: Show All Rows When a Parameter is Null

    Bill Talada (2/5/2014)

    Your easiest solution might be to do this simple change. If a parameter is given a value, then a subset of rows will be returned. If...

    February 5, 2014 at 8:10 am

    #1686214

  • RE: Today's Random Word!

    Kurt W. Zimmerman (2/5/2014)

    Ed Wagner (2/5/2014)

    BWFC (2/5/2014)

    SQLRNNR (2/4/2014)

    toke

    Draw

    Shoot

    Skeet

    Clay

    February 5, 2014 at 7:07 am

    #1686192

  • RE: Today's Random Word!

    SQLRNNR (2/4/2014)

    toke

    Draw

    February 5, 2014 at 1:25 am

    #1686109

  • RE: Today's Random Word!

    Beyond

    Infinity 🙂

    February 4, 2014 at 1:12 am

    #1685749

  • RE: Stored Proc And View Giving Different Results

    GilaMonster (2/3/2014)

    BWFC (2/3/2014)

    I'm personally surprised not one of the auditors has said something like 'about these nolocks...'

    No, they won't. Most aren't technical and won't have any idea of the implications....

    February 3, 2014 at 7:00 am

    #1685470

  • RE: Stored Proc And View Giving Different Results

    GilaMonster (2/3/2014)

    BWFC (2/3/2014)

    I don't think we have much in the way of blocking problems, although it's not something that would necessarily come to my attention if we did.

    If you have...

    February 3, 2014 at 6:39 am

    #1685459

  • RE: Stored Proc And View Giving Different Results

    I don't think we have much in the way of blocking problems, although it's not something that would necessarily come to my attention if we did. My boss or...

    February 3, 2014 at 5:58 am

    #1685447

  • RE: Stored Proc And View Giving Different Results

    Jeffrey Williams 3188 (1/31/2014)

    Remove the Distinct in the view definition - that is going to eliminate rows from the grouping that are actually included in the procedure.

    The distinct will only...

    February 3, 2014 at 5:21 am

    #1685437

  • RE: Stored Proc And View Giving Different Results

    ChrisM@Work (1/31/2014)

    That's okay, it was always going to be a long shot with no sample data blah blah.

    I hope you can take away a few ideas from it though,...

    January 31, 2014 at 10:43 am

    #1685147

  • RE: Stored Proc And View Giving Different Results

    ChrisM@Work (1/31/2014)

    You might get some performance lift by jigging around with your filters. If you're going down this route then do take on board Gail's comments about DISTINCT. You might...

    January 31, 2014 at 7:47 am

    #1685060

Viewing 15 posts - 1,171 through 1,185 (of 1,250 total)