Forum Replies Created

Viewing 15 posts - 616 through 630 (of 8,731 total)

  • RE: Are the posted questions getting worse?

    jonathan.crawford - Wednesday, April 11, 2018 10:08 AM

    I think that's a DE-forester.

    I would pick the Subaru out of that list....

    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

    April 11, 2018 at 10:21 am

    #1986399

  • RE: Are the posted questions getting worse?

    Grant Fritchey - Wednesday, April 11, 2018 6:56 AM

    Luis Cazares - Wednesday, April 11, 2018 6:52 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

    April 11, 2018 at 9:31 am

    #1986384

  • RE: Are the posted questions getting worse?

    I have no musical ability, but I learned some piano and french horn. I can remember some of the piano, but won't recommend to be around if I try to...

    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

    April 11, 2018 at 6:52 am

    #1986329

  • RE: Query Help on PIVOT

    Here's the explanation on the code shown by Saravanan.
    An Alternative (Better?) Method to UNPIVOT (SQL Spackle) - SQLServerCentral
    And obviously, the explanation of UNPIVOT can be found...

    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

    April 11, 2018 at 6:40 am

    #1986325

  • RE: Convert Negative values -2.56 to (2.56) in excel

    komal145 - Tuesday, April 10, 2018 9:11 AM

    hi , 
    I have a package right now which loads data from Table to a  .csv...

    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

    April 10, 2018 at 9:43 am

    #1986162

  • RE: RUN a stored procedure or function for every SQL session automatically

    skb 44459 - Tuesday, April 10, 2018 8:10 AM

    Is there a way to run a stored procedure or a function for every...

    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

    April 10, 2018 at 8:38 am

    #1986143

  • RE: Are the posted questions getting worse?

    WayneS - Tuesday, April 10, 2018 8:07 AM

    There's nothing wrong with those roads. You just need the proper vehicle for them....

    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

    April 10, 2018 at 8:14 am

    #1986138

  • RE: Table Valued Function causing performance issue

    One simple test that I keep available for demonstrating performance of scalar functions.
    There's no data access or any real work being done in the functions, it's just the cost...

    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

    April 10, 2018 at 7:20 am

    #1986115

  • RE: Using CASE in a View

    ordnance1 - Monday, April 9, 2018 1:29 PM

    Taking your advice I have moved to the query editor and just trying to converter...

    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

    April 9, 2018 at 1:36 pm

    #1986026

  • RE: Using CASE in a View

    The first thing that you should do is to get out of the view designer and use the query editor.
    Then write the query as you want it in 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

    April 9, 2018 at 12:42 pm

    #1986015

  • RE: Are the posted questions getting worse?

    GilaMonster - Sunday, April 8, 2018 4:46 AM

    Michael L John - Saturday, April 7, 2018 5:46 PM

    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

    April 9, 2018 at 7:46 am

    #1985960

  • RE: Convert ORACLE code to SQL

    There are many problems with that query, but I tried to get it correct. This might give you an idea on what could work.
    I'm guessing that this is 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

    April 9, 2018 at 6:58 am

    #1985945

  • RE: Removing stored procedures to move to cloud

    Steve Thompson-454462 - Friday, April 6, 2018 10:49 AM

    Luis Cazares - Tuesday, April 3, 2018 12:59 PM

    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

    April 6, 2018 at 11:11 am

    #1985830

  • RE: Retreving phone numbers based on phone type

    mcfarlandparkway - Wednesday, April 4, 2018 9:11 AM

    i have a table where it has empid, phone type and phone number

    one employee has...

    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

    April 4, 2018 at 9:24 am

    #1985486

  • RE: I need to divide my total by the QTY, but QTY lives on every row

    My guess is that you might need to use the OVER clause. However, it's hard to be sure. Check the articles on my signature for further help.

    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

    April 4, 2018 at 6:21 am

    #1985442

Viewing 15 posts - 616 through 630 (of 8,731 total)