Forum Replies Created

Viewing 15 posts - 481 through 495 (of 4,080 total)

  • RE: Are the posted questions getting worse?

    GilaMonster (7/23/2015)

    !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

    !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

    Superfluous additional exclamatory congratulations, Gail!

    But for some strange reason this is unsurprising.

    __________________________________________________

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

    July 24, 2015 at 3:46 pm

    #1814923

  • RE: need help in converting nvarchar to datetime

    There are better ways to include column names with output. I don't know of any other system that handles column names the way that view does. ...

    __________________________________________________

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

    July 24, 2015 at 2:45 pm

    #1814918

  • RE: need help in converting nvarchar to datetime

    Just saw your last post. Why on earth are you trying to put text for column headers at the front of your actual data?

    Of course "Call...

    __________________________________________________

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

    July 24, 2015 at 2:19 pm

    #1814913

  • RE: need help in converting nvarchar to datetime

    It may be that some of the values in your table do not represent valid dates.

    If you try to convert to datetime and any row has a bad value...

    __________________________________________________

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

    July 24, 2015 at 2:13 pm

    #1814912

  • RE: EAV's and NVP's are bad. So... What do YOU use as an alternative?

    I inherited a large EAV (TRANSLATE_CODE_VALUE) that contained descriptions matched to a series of single-character codes across dozens of columns in several primary tables. The schema...

    __________________________________________________

    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 8, 2015 at 8:37 am

    #1803708

  • RE: A Case FOR Cursors...

    Brian J. Parker (6/5/2015)

    This is completely branching off the topic of the original article, but... I've grown accustomed to instantiating a Tally table whenever possible in any database I work...

    __________________________________________________

    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 5, 2015 at 1:28 pm

    #1803460

  • RE: A Case FOR Cursors...

    No argument with the statement that cursors are acceptable where row by row processing can't be avoided. The reason relative newcomers to SQL are warned away from...

    __________________________________________________

    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 5, 2015 at 10:36 am

    #1803394

  • RE: Searching for Plans

    Eric M Russell (5/18/2015)

    Iwas Bornready (5/18/2015)

    What a great idea. I totally agree. Let me see if I can optimize it even more and then force sql to use my version.

    Real...

    __________________________________________________

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

    May 18, 2015 at 2:50 pm

    #1798844

  • RE: Searching for Plans

    Um... guys... did you look at when this thread started. Your advice is about 5 years too late 😉

    __________________________________________________

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

    May 15, 2015 at 12:14 pm

    #1798297

  • RE: Group data into 15 minute intervals

    Dangit, I read all the way down thinking about the VALUES clause and you beat me to it.

    __________________________________________________

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

    April 9, 2015 at 4:40 pm

    #1790045

  • RE: Are the posted questions getting worse?

    Grant Fritchey (3/12/2015)

    I seem to be the harbinger of doom.

    Terry Pratchett has died.[/url]

    Miskatonic alumni often are.

    __________________________________________________

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

    March 12, 2015 at 1:53 pm

    #1783713

  • RE: Force Index Query Hints

    I agree with EMarkM that 99.99% of the time its a mistake to force use of an index. Not to be unkind, but the optimizer knows what...

    __________________________________________________

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

    March 11, 2015 at 3:40 pm

    #1783459

  • RE: Conditional Join Statement

    When you do a left join or a right join or a full outer join or an outer APPLY, unmatched rows return NULL values. Use 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

    March 10, 2015 at 1:16 pm

    #1783065

  • RE: SQL Function : Find ‘X’ Business Days in the Future

    Wow.... five years...

    Here is a quick example of a Calendar table. If you will search this site under the words "Calendar Table" you will...

    __________________________________________________

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

    February 14, 2015 at 12:57 pm

    #1777692

  • RE: Are the posted questions getting worse?

    Ed Wagner (7/31/2014)

    SQLRNNR (7/31/2014)

    swasheck (7/31/2014)

    To qualify my statement, I have no personal context for anything involving Jeff Moden and I'd welcome him. I've only perused SSC forums in the past...

    __________________________________________________

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

    July 31, 2014 at 2:13 pm

    #1734254

Viewing 15 posts - 481 through 495 (of 4,080 total)