Forum Replies Created

Viewing 15 posts - 4,636 through 4,650 (of 8,731 total)

  • RE: Finding distinct columns issue

    Maybe someone can find a better way of doing this, but here's an option.

    It unpivots the table to order the 3 values, assigns a row number for each value and...

    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 22, 2015 at 7:47 am

    #1814111

  • RE: Running Sum with Reset Option & SQL BULK update

    Read the following article and consider using the Quirky Update described in it. It also describes different approaches.

    http://www.sqlservercentral.com/articles/T-SQL/68467/

    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 22, 2015 at 7:17 am

    #1814097

  • RE: Select queries with a join sometimes fail on some remote PC's

    Have you read this?

    https://support.microsoft.com/en-us/kb/942861

    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 22, 2015 at 7:13 am

    #1814096

  • RE: Increase ecessivo tempdb

    You need to review the processes running that increase the size of TempDB. Probably large loads that need ordering, index rebuilds or bad queries. You could use extended events 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

    July 22, 2015 at 7:06 am

    #1814094

  • RE: export data from sql server to excel

    Would the Import/Export Wizard could help you? It uses SSIS to export the data and you can save the package to edit it or run it anytime.

    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 22, 2015 at 7:01 am

    #1814092

  • RE: Are the posted questions getting worse?

    Ed Wagner (7/22/2015)

    Brandie Tarvin (7/22/2015)

    Here's my fun thing for the day:

    2 a.m. Email: Disk X on non-prod server test is full

    2 a.m. Email: Disk Y on non-prod server qa is...

    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 22, 2015 at 6:51 am

    #1814089

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (7/22/2015)

    BWFC (7/22/2015)

    'Why didn't this appear on your report? It's wrong. There's been an incident and you've made us look bad in front of government.' - The...

    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 22, 2015 at 6:49 am

    #1814087

  • RE: Help with Accumulation

    You're right Jacob. That's what I get for not testing my code. 😀

    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 21, 2015 at 2:01 pm

    #1813958

  • RE: Help with Accumulation

    This might help you. Be sure to test it and understand it. Ask any questions that you might have.

    WITH CTE AS(

    SELECT *,

    ...

    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 21, 2015 at 1:50 pm

    #1813956

  • RE: Using PIVOT question - Very newbie

    You can use PIVOT or you can use cross tabs. I personally prefer cross tabs.

    To do this correctly, you need to create a row number for each item in the...

    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 21, 2015 at 9:51 am

    #1813894

  • RE: Today's Random Word!

    DonlSimpson (7/21/2015)

    Ed Wagner (7/21/2015)

    BWFC (7/21/2015)

    jasona.work (7/21/2015)

    Ed Wagner (7/21/2015)

    whereisSQL? (7/21/2015)

    djj (7/21/2015)

    Ed Wagner (7/21/2015)

    Eirikur Eiriksson (7/20/2015)

    Ed Wagner (7/20/2015)

    whereisSQL? (7/20/2015)

    DonlSimpson (7/20/2015)

    crookj (7/20/2015)

    Gang

    Sam Cooke

    Sing

    Concert

    Instrument

    Harmony

    Discord

    Rumor

    Mill

    Cider

    House

    Home

    Heart

    Liver

    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 21, 2015 at 9:44 am

    #1813891

  • RE: SQL to determine if a non-attendance is a “DROPOUT”

    aslam.jeewa (7/21/2015)

    Thank you so much, Luis C - Works perfectly.

    The most important part. Do you understand how it works? Remember that you will need to support this code.

    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 21, 2015 at 9:38 am

    #1813887

  • RE: Help with query

    Hi,

    As mentioned by Sean, it's better if you provide sample data in a consumable format. This time I did it because I have free time.

    The logic wasn't very clear, but...

    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 21, 2015 at 9:33 am

    #1813886

  • RE: Query runs fine individually but not together.

    Lynn Pettis (7/21/2015)

    Okay, help us help you. Please post the DDL (CREATE TABLE Statement) for the table(s) involved, sample data for the table(s) (INSERT INTO statements), and expected results...

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

    #1813870

  • RE: Guidance on best string manipulation technique (image included)

    Christopher Kutsch (7/21/2015)

    This version cannot keep up with XML splitting or CLRs, but won't fail on reserved characters like ampersands. For a tool that is used in ETL and non-OLTP...

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

    #1813868

Viewing 15 posts - 4,636 through 4,650 (of 8,731 total)