Forum Replies Created

Viewing 15 posts - 6,181 through 6,195 (of 8,731 total)

  • RE: Are the posted questions getting worse?

    wolfkillj (7/7/2014)

    Sean Lange (7/2/2014)

    Stefan Krzywicki (7/2/2014)

    Sean Lange (7/2/2014)

    Stefan Krzywicki (7/2/2014)

    Koen Verbeeck (7/2/2014)

    Jo Pattyn (7/1/2014)

    Funny! :w00t:

    Anyway the Belgium Red Devils got past the USA soccer team after a thrilling match.

    It was...

    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

    July 7, 2014 at 9:53 am

    #1727466

  • RE: What are the difference between update statistics and execution plan in sql server

    It might be more logical if we change some words in the question:

    What are the differences generated by update statistics on an execution plan in sql server?

    Answer: It depends....

    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

    July 7, 2014 at 9:42 am

    #1727459

  • RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

    david.holley (7/7/2014)

    Jeff Moden (7/7/2014)

    jfogel (7/7/2014)

    Great, just great. A year ago I wrote something that has to break down a CSV-style parameter string and it uses a loop to do it....

    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

    July 7, 2014 at 9:19 am

    #1727440

  • RE: Code Names

    GilaMonster (7/4/2014)

    Forums are going to be quiet today. How am I supposed to keep myself entertained on a Friday afternoon at work now? 🙁

    You can report spam :sick:

    I'm not...

    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

    July 4, 2014 at 8:30 am

    #1727095

  • RE: The way to beat spam SQL Server Central

    Most people make their first post asking for help with zero points. That would be restricting the help too much. Adding complication to the creation of new accounts to prove...

    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

    July 4, 2014 at 8:23 am

    #1727093

  • RE: Order of IN operator

    atultiwari.eng06 (7/4/2014)

    I m using oracle sql developer...

    any good solution for that??

    The solution that I posted? It will work on most RDBMS including Oracle.

    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

    July 4, 2014 at 8:10 am

    #1727091

  • RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

    You don't need a different tally table for each procedure. You only need one and you'll just determine the range when you query it.

    You could as well create a view...

    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

    July 4, 2014 at 8:03 am

    #1727088

  • RE: Get Date in Range

    So, based on your posted data. What's the result that you're expecting?

    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

    July 4, 2014 at 7:51 am

    #1727085

  • RE: Create Function - Query works fine stand-alone but has error message for the line

    I'm not sure that you need a function.

    Here's an example using the over clause to solve the problem and at the same time the iTVF option. I strongly suggest 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

    July 3, 2014 at 3:51 pm

    #1726974

  • RE: Function Calls two other functions - If, else - then used in View - Is it OK or can it be improved

    Can you post the code for R_35A and R_35B functions? This sounds like it will generate a terrible bottleneck. Could you post as well an example on how do 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

    July 3, 2014 at 3:30 pm

    #1726971

  • RE: How long do you give a new job

    Evil Kraig F (7/3/2014)

    winston Smith (7/3/2014)

    dan-572483 (7/3/2014)

    Of course if you're a good DBA, not only will put out the fires, you will put processes in place to prevent fires from...

    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

    July 3, 2014 at 2:14 pm

    #1726959

  • RE: Order of IN operator

    Those are independent clauses.

    You could work more to give the correct order.

    SELECT empid

    FROM consumer

    WHERE empid in (2323,1236,5623)

    ORDER BY CASE WHEN empid = 2323 THEN 1

    ...

    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

    July 3, 2014 at 12:12 pm

    #1726927

  • RE: Create Function - Query works fine stand-alone but has error message for the line

    I'm not sure where to start. Your variable assignment is completely wrong.

    In other order of ideas, you could change your scalar function into an inline table valued function which should...

    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

    July 2, 2014 at 5:17 pm

    #1726663

  • RE: SQL Server 2008 performance issue

    Lansend1 (7/2/2014)

    With regards to " you might need a qualified professional" do you mean an SQL professional ?

    Yes, even if you have highly qualified professionals helping on this site, sometimes...

    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

    July 2, 2014 at 5:09 pm

    #1726661

  • RE: Generate column numbers using dynamic SQL and pivot command

    I'm giving a completely different approach here.

    If you insert a pivot table in excel, you can connect directly to the table and pivot any way you want. Being a pivot...

    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

    July 2, 2014 at 4:00 pm

    #1726651

Viewing 15 posts - 6,181 through 6,195 (of 8,731 total)