Forum Replies Created

Viewing 15 posts - 1,096 through 1,110 (of 4,080 total)

  • RE: Are the posted questions getting worse?

    SQLRNNR (6/13/2011)

    The Dixie Flatline (6/11/2011)

    "OK you <insulting term removed> there's a new kid on the block and he doesn't stand for BS"

    Obviously not... the Back Street Boys are a...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

    June 13, 2011 at 9:42 am

    #1337853

  • RE: Need to filter by date range...

    Jeff Moden (6/12/2011)

    The Dixie Flatline (6/11/2011)

    That guy's about as useless as a varchar(1). -- Original

    I like that quote. Here's another one that I frequently use on managers that promise...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

    June 13, 2011 at 9:24 am

    #1337834

  • RE: Are the posted questions getting worse?

    I might actually enjoy working for people who knew what it meant. 😀

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

    June 12, 2011 at 6:30 pm

    #1337540

  • RE: A Saturday QOTD - If you get it right and live in Nashville, TN a few Happy Hour Brews are on ME!

    I suspect the TRY...CATCH doesn't work the way you expect because the TRY is actually succeeding.

    Procedure dbo.sp_start_job runs twice, successfully sending start job requests over to SQLServerAgent...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

    June 12, 2011 at 5:41 pm

    #1337534

  • RE: Looking for help in T-SQL

    It seems simple enough. Do four different insert queries.

    1. Insert Into PaymentItems Select (some columns)

    2. Insert Into PaymentItemD_zAgro Select (some columns) where Type = 'agro'

    3....

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

    June 12, 2011 at 5:30 pm

    #1337531

  • RE: Are the posted questions getting worse?

    If I passed, could I add "Thread Certified" to my resume` ?

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

    June 12, 2011 at 5:21 pm

    #1337529

  • RE: Select From Table Before Transaction Begin

    Saif:

    What we are hearing is that you want to audit the changes: logging the data before the update is committed along with the data after the update is committed. ...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

    June 12, 2011 at 7:26 am

    #1337455

  • RE: money or decimal type

    You can use either. I typically use decimal.

    With respect to performance. You will not see a significant difference, if any, between the two.

    Money types provide display...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

    June 11, 2011 at 9:16 pm

    #1337430

  • RE: Need to filter by date range...

    You are joining two subsets of the cookies table to each other. Assuming you want filter each set by those dates, you simply need to add...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

    June 11, 2011 at 9:09 pm

    #1337429

  • RE: Are the posted questions getting worse?

    Is there such a thing as an LVP?

    I'm looking for an attainable goal for the 2nd half of the year.

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

    June 11, 2011 at 9:04 pm

    #1337428

  • RE: Are the posted questions getting worse?

    "OK you <insulting term removed> there's a new kid on the block and he doesn't stand for BS"

    Obviously not... the Back Street Boys are a totally different boy-band than...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

    June 11, 2011 at 7:06 am

    #1337376

  • RE: Are the posted questions getting worse?

    GilaMonster (6/9/2011)

    I post too much.

    APPLAUSE!

    THUNDEROUS APPLAUSE !!

    BRAVA !!!

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

    June 11, 2011 at 6:58 am

    #1337375

  • RE: Select From Table Before Transaction Begin

    Read up on the OUTPUT clause as someone previously suggested. It does exactly what you want to do.

    It will enable you to store before/after data from every...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

    June 11, 2011 at 6:55 am

    #1337374

  • RE: Invalid In Select List Because Not In GROUP BY Clause

    He said "sample" data. Feel free to make up fictional values to hide proprietary information so long as those values recreate the problem you are experiencing.

    The reason...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

    June 7, 2011 at 7:00 am

    #1334963

  • RE: Calculations in query

    Frankly, this strikes me as the sort of problem that might be better done on the client side, but you can test this logic out.

    Basically, the...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

    June 6, 2011 at 5:08 pm

    #1334737

Viewing 15 posts - 1,096 through 1,110 (of 4,080 total)