Forum Replies Created

Viewing 15 posts - 3,256 through 3,270 (of 8,731 total)

  • RE: Calculate Percentile on Sql 2008

    Here's an article by Dwain Camps in which he explains how to use percentiles in versions previous to 2012. https://www.simple-talk.com/sql/t-sql-programming/using-the-t-sql-percentile-analytic-functions-in-sql-server-2000,-2005-and-2008/

    If anyone wants to give it a shot, here's the sample...

    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

    February 29, 2016 at 12:23 pm

    #1861920

  • RE: Today's Random Word!

    Ed Wagner (2/29/2016)

    crookj (2/29/2016)

    djj (2/29/2016)

    Grumpy DBA (2/29/2016)

    whereisSQL? (2/29/2016)

    Solo

    Han

    Leia

    Duplicate

    Copy

    Cat

    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

    February 29, 2016 at 12:09 pm

    #1861914

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (2/29/2016)

    Alan.B (2/29/2016)

    It's not a bad thing for a recruiter to work with the candidate to modify the resume for a position provided everyone is being...

    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

    February 29, 2016 at 12:00 pm

    #1861909

  • RE: Today's Random Word!

    Ed Wagner (2/29/2016)

    Grumpy DBA (2/29/2016)

    Ed Wagner (2/29/2016)

    Duck Hunt

    NES

    Mario

    Luigi

    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

    February 29, 2016 at 8:31 am

    #1861818

  • RE: Converting VARCHAR to BIGINT

    Jeff Moden (2/25/2016)

    Luis Cazares (2/25/2016)

    If by any chance you're working with SQL Server 2012 or later, you can use TRY_CAST or TRY_CONVERT.

    Have you compared it for performance?

    I hadn't test...

    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

    February 27, 2016 at 5:40 pm

    #1861662

  • RE: Please help fix this error in SSIS 2008 package, data flow..

    SSIS won't work correctly with temp tables. You need to use a permanent table for your script.

    Unless there's a workaround using certain settings, but I don't remember any.

    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

    February 26, 2016 at 7:19 pm

    #1861598

  • RE: Are the posted questions getting worse?

    SQLRNNR (2/26/2016)

    Grumpy DBA (2/26/2016)

    Sean Lange (2/26/2016)

    You are quite welcome. Happy to share the joy. At least is isn't "All Out of Love" from Air Supply. :w00t:

    Well, that's a good thing...

    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

    February 26, 2016 at 11:57 am

    #1861515

  • RE: sql substring help

    This is a bit safer than Gilbert's version.

    declare @test-2 table(Code varchar(18));

    insert into @test-2

    select aa.code from (

    select '0012345678912' union all

    select '00012345678912' union all

    select '000012345678912' union all

    select '0000012345678912' union all

    select '00000012345678912' union...

    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

    February 26, 2016 at 10:35 am

    #1861475

  • RE: Rewrite subquery

    Are you trying to get the median?

    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

    February 26, 2016 at 10:19 am

    #1861470

  • RE: Duplicates for my reorg select scripts

    It might be caused by partitions. I'm not sure what do you want to do with that.

    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

    February 26, 2016 at 10:17 am

    #1861468

  • RE: FIND column that hits criteria

    I can help you, just post sample data with CREATE TABLE and INSERT statements, so I don't waste time recreating it. You can find out how to do that in...

    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

    February 26, 2016 at 10:03 am

    #1861463

  • RE: Are the posted questions getting worse?

    Ray K (2/26/2016)

    Steve Jones - SSC Editor (2/26/2016)

    Ed Wagner (2/26/2016)

    Sean Lange (2/26/2016)

    Ed Wagner (2/26/2016)

    Grumpy DBA (2/26/2016)

    Hugo Kornelis (2/26/2016)

    Grumpy DBA (2/26/2016)

    For some unknown reason a terrible song has been stuck in...

    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

    February 26, 2016 at 9:10 am

    #1861439

  • RE: Extract specific words from row or leave blank?

    Use REPLACE?

    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

    February 26, 2016 at 9:07 am

    #1861438

  • RE: Error with syntax using ;With

    Semicolons are statement terminators not initiators.

    I'm not sure if you can use a WITH inside an IF condition.

    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

    February 26, 2016 at 7:56 am

    #1861397

  • RE: Today's Random Word!

    Grumpy DBA (2/26/2016)

    ThomasRushton (2/26/2016)

    djj (2/26/2016)

    Clinton

    dry-cleaning

    Blue Dress

    Spot

    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

    February 26, 2016 at 7:25 am

    #1861388

Viewing 15 posts - 3,256 through 3,270 (of 8,731 total)