Forum Replies Created

Viewing 15 posts - 946 through 960 (of 8,731 total)

  • RE: Strange COALESCE issue

    This appears to be a bug in SQL Server (or a feature?). It's easily corrected if you remove the derived table and use a direct query.

    DECLARE...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    October 2, 2017 at 11:02 am

    #1961922

  • RE: Are the posted questions getting worse?

    Thom A - Monday, October 2, 2017 7:57 AM

    Anyone got any idea what time 2017 goes up, or is it just (at...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    October 2, 2017 at 10:10 am

    #1961909

  • RE: Code-first vs database-first, any new developments?

    Steve Jones - SSC Editor - Friday, September 29, 2017 9:47 AM

    To be fair, plenty of people use tools (ErWin, Er/Studio, Visio,...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    September 29, 2017 at 11:18 am

    #1961704

  • RE: ?? on Finding records with caharacters before and after in a string??

    sgmunson - Friday, September 29, 2017 8:45 AM

    jbalbo - Friday, September 29, 2017 8:26 AM

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    September 29, 2017 at 8:53 am

    #1961675

  • RE: saving variable from a stored proc

    rs80 - Thursday, September 28, 2017 11:42 AM

    Is it possible to replicate this code from a stored procedure in a SSRS dataset?

    exec...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    September 28, 2017 at 12:01 pm

    #1961431

  • RE: Are the posted questions getting worse?

    Thom A - Thursday, September 28, 2017 9:19 AM

    Lynn Pettis - Thursday, September 28, 2017 9:11 AM

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    September 28, 2017 at 9:35 am

    #1961388

  • RE: Are the posted questions getting worse?

    Apparently, we got an Oracle fan that likes to resurrect things, like 7 year old threads or his 7 year old account.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    September 28, 2017 at 9:08 am

    #1961379

  • RE: A Window Function question...

    The first query is simulating an aggregate function. It's not returning all rows, just one for each customer. The second query will return one row per order.
    You don't need...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    September 28, 2017 at 8:51 am

    #1961375

  • RE: An exercise in query optimisation.....

    sgmunson - Thursday, September 28, 2017 8:27 AM

    kevaburg - Thursday, September 28, 2017 8:17 AM

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    September 28, 2017 at 8:43 am

    #1961369

  • RE: An exercise in query optimisation.....

    Then, the first thing you need to practice is how to generate sample data that is large enough to test for performance.
    Here are 2 articles that can help you...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    September 28, 2017 at 8:40 am

    #1961367

  • RE: An exercise in query optimisation.....

    kevaburg - Thursday, September 28, 2017 4:48 AM

    Hi all,

    I am starting to work in an environment where database DevOps plays a very...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    September 28, 2017 at 8:12 am

    #1961358

  • RE: Which is better and Why.?

    kannan_egd - Thursday, September 28, 2017 7:43 AM

    Oracle is always best and better than SQL server. When come to data warehouse...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    September 28, 2017 at 8:10 am

    #1961357

  • RE: Reading a CSV

    Revenant - Wednesday, September 27, 2017 7:51 PM

    It is nice to see A NFL-related question that does not assume that you know...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    September 28, 2017 at 6:49 am

    #1961323

  • RE: Import question

    EDIT: Disregard, I misunderstood.

    If that's for reporting, I suggest that you do it on the front end.
    However, here are 2 articles that can show you the path...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    September 27, 2017 at 1:30 pm

    #1961237

  • RE: Are the posted questions getting worse?

    Sean Lange - Wednesday, September 27, 2017 7:18 AM

    We had a guy in here a few years ago who wrote a...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    September 27, 2017 at 8:16 am

    #1961150

Viewing 15 posts - 946 through 960 (of 8,731 total)