Forum Replies Created

Viewing 15 posts - 4,951 through 4,965 (of 9,399 total)

  • RE: Today's Random Word!

    djj (10/13/2015)


    anthony.green (10/13/2015)


    Ed Wagner (10/13/2015)


    Eirikur Eiriksson (10/12/2015)


    Luis Cazares (10/12/2015)


    crookj (10/12/2015)


    djj (10/12/2015)


    eccentricDBA (10/9/2015)


    Ed Wagner (10/9/2015)


    Luis Cazares (10/9/2015)


    Eirikur Eiriksson (10/9/2015)


    Ed Wagner (10/9/2015)


    DonlSimpson (10/9/2015)


    anthony.green (10/9/2015)


    Ed Wagner (10/9/2015)


    crookj (10/9/2015)


    Ed Wagner (10/9/2015)


    happygeek (10/9/2015)


    Deadlock victim!

    Cost

    Expense

    Revenue

    Tax

    Tariff

    Price Increase

    Pint

    Pitcher

    Round

    Parrotheads

    Paradise

    ...

  • RE: INTERSECT

    Nice question, thanks. It's also a very efficient approach.

  • RE: Today's Random Word!

    Eirikur Eiriksson (10/12/2015)


    Luis Cazares (10/12/2015)


    crookj (10/12/2015)


    djj (10/12/2015)


    eccentricDBA (10/9/2015)


    Ed Wagner (10/9/2015)


    Luis Cazares (10/9/2015)


    Eirikur Eiriksson (10/9/2015)


    Ed Wagner (10/9/2015)


    DonlSimpson (10/9/2015)


    anthony.green (10/9/2015)


    Ed Wagner (10/9/2015)


    crookj (10/9/2015)


    Ed Wagner (10/9/2015)


    happygeek (10/9/2015)


    Deadlock victim!

    Cost

    Expense

    Revenue

    Tax

    Tariff

    Price Increase

    Pint

    Pitcher

    Round

    Parrotheads

    Paradise

    Snake Eyes (pair a...

  • RE: Are the posted questions getting worse?

    Luis Cazares (10/12/2015)


    ChrisM@Work (10/12/2015)


    Luis Cazares - happy birthday geezer. No idea how but it came up in some feed or other on my phone. Hope you had a great day...

  • RE: Are the posted questions getting worse?

    I see the sports spam has returned. Sigh.

  • RE: Split apart filenames into a database

    It looks to me like you need an efficient way of splitting your comma-delimited lists by the comma. Jeff Moden has an excellent article on just such a splitter....

  • RE: Today's Random Word!

    Luis Cazares (10/9/2015)


    Eirikur Eiriksson (10/9/2015)


    Ed Wagner (10/9/2015)


    DonlSimpson (10/9/2015)


    anthony.green (10/9/2015)


    Ed Wagner (10/9/2015)


    crookj (10/9/2015)


    Ed Wagner (10/9/2015)


    happygeek (10/9/2015)


    Deadlock victim!

    Cost

    Expense

    Revenue

    Tax

    Tariff

    Price Increase

    Pint

    Pitcher

    Round

  • RE: Need explanation for this.

    ScottPletcher (10/9/2015)


    A subquery can refer to a column in the outer/main query. Thus, SQL is comparing the column to itself. You need to prefix the column with the...

  • RE: Today's Random Word!

    DonlSimpson (10/9/2015)


    anthony.green (10/9/2015)


    Ed Wagner (10/9/2015)


    crookj (10/9/2015)


    Ed Wagner (10/9/2015)


    happygeek (10/9/2015)


    Deadlock victim!

    Cost

    Expense

    Revenue

    Tax

    Tariff

    Price Increase

  • RE: Today's Random Word!

    crookj (10/9/2015)


    Ed Wagner (10/9/2015)


    happygeek (10/9/2015)


    Deadlock victim!

    Cost

    Expense

    Revenue

  • RE: Whats the count???

    Luis Cazares (10/9/2015)


    I couldn't find the explanation on why does the TRY...CATCH would reset the value of @@ROWCOUNT.

    From BOL

    Statements such as USE, SET <option>, DEALLOCATE CURSOR, CLOSE CURSOR, BEGIN TRANSACTION...

  • RE: Whats the count???

    Good question. I use @@ROWCOUNT quite a bit and find it quite useful, but you have to follow the rules. Thanks for a good question.

  • RE: Today's Random Word!

    happygeek (10/9/2015)


    Deadlock victim!

    Cost

  • RE: Today's Random Word!

    djj (10/8/2015)


    Ed Wagner (10/8/2015)


    whereisSQL? (10/8/2015)


    Ed Wagner (10/8/2015)


    whereisSQL? (10/7/2015)


    DonlSimpson (10/7/2015)


    crookj (10/7/2015)


    Ed Wagner (10/7/2015)


    whereisSQL? (10/7/2015)


    ZZartin (10/7/2015)


    crookj (10/7/2015)


    djj (10/7/2015)


    Renew

    Subscription

    Drive

    Fly

    The Wall

    pink

    floyd

    Mayweather

    Rousey

    Armbar

    Tapout

    Machine

    Rage

  • RE: Today's Random Word!

    whereisSQL? (10/8/2015)


    Ed Wagner (10/8/2015)


    whereisSQL? (10/7/2015)


    DonlSimpson (10/7/2015)


    crookj (10/7/2015)


    Ed Wagner (10/7/2015)


    whereisSQL? (10/7/2015)


    ZZartin (10/7/2015)


    crookj (10/7/2015)


    djj (10/7/2015)


    Renew

    Subscription

    Drive

    Fly

    The Wall

    pink

    floyd

    Mayweather

    Rousey

    Armbar

    Tapout

Viewing 15 posts - 4,951 through 4,965 (of 9,399 total)