Forum Replies Created

Viewing 15 posts - 2,851 through 2,865 (of 8,731 total)

  • RE: SSIS automation through command line

    Brandie Tarvin (5/16/2016)

    Luis, do you use config files for this package?

    Is this package an older one that is just now being upgraded to SQL 2012 or is it a new...

    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

    May 16, 2016 at 11:41 am

    #1879328

  • RE: SSIS automation through command line

    Brandie Tarvin (5/16/2016)

    Luis Cazares (5/16/2016)

    The problem is only when running from the IS Catalogs.

    I do not understand what you mean by this statement. Do you mean running via SSMS with...

    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

    May 16, 2016 at 9:12 am

    #1879290

  • RE: SSIS automation through command line

    Shawn Melton (5/16/2016)

    You need to review how you are calling the packages, and under what account it is running. If you are using Windows Authentication then whatever account is calling...

    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

    May 16, 2016 at 8:56 am

    #1879283

  • RE: Are the posted questions getting worse?

    I know most of you don't even want to spell SSIS, but for those that like it, I'd appreciate some help in here: http://www.sqlservercentral.com/Forums/Topic1786539-364-1.aspx

    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

    May 16, 2016 at 8:21 am

    #1879259

  • RE: Question About Getting Max Dense_Rank Number

    Have you tried COUNT(DISTINCT )?

    SELECT myvalue = COUNT( DISTINCT TotalSalesAmt)

    FROM SalesItem2

    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

    May 13, 2016 at 1:40 pm

    #1879038

  • RE: How to get output from a select to a file ?

    For a one time or manual process, you could choose the option "Results to File".

    You might be able to go around the xp_cmdshell process by creating a job with 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

    May 13, 2016 at 9:41 am

    #1878952

  • RE: Are the posted questions getting worse?

    ChrisM@Work (5/13/2016)

    Sean Lange (5/13/2016)

    Brandie Tarvin (5/13/2016)

    For those who hadn't heard, THIS happened.

    Yay.

    EDIT: I should add I'm not trying to start a debate. I just wanted to pass along the news.

    IMHO...

    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

    May 13, 2016 at 9:28 am

    #1878945

  • RE: Need help on Sorting...

    viralbpandya (5/12/2016)

    I am not getting desired result for above.

    I want to sort the data first by "Planned Delivery Data" and than by "Order No".

    Use

    ...

    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

    May 13, 2016 at 6:39 am

    #1878879

  • RE: Today's Random Word!

    crookj (5/12/2016)

    ThomasRushton (5/12/2016)

    Ed Wagner (5/12/2016)

    Grumpy DBA (5/12/2016)

    whereisSQL? (5/11/2016)

    Ed Wagner (5/11/2016)

    Hogwarts

    Dementor

    Azkaban

    Sirius Black

    Dog star

    Lassie

    Rin Tin Tin

    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

    May 12, 2016 at 7:15 am

    #1878580

  • RE: Need help on Sorting...

    Then don't use functions on the ORDER BY clause.

    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

    May 12, 2016 at 7:05 am

    #1878559

  • RE: Using computed Columns to Create another Computed Column

    Just be aware that scalar udfs would prevent parallelism on all the queries they're used. A complex calculation won't have this problem.

    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

    May 12, 2016 at 6:54 am

    #1878536

  • RE: Possible to also show the date a topic was started?

    jasona.work (5/11/2016)

    Something like a "First post" column, or including it in the "Started By" column when viewing a forum / list of results.

    It would certainly make it easier to filter...

    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

    May 11, 2016 at 12:01 pm

    #1878352

  • RE: Simple SQL challenge - who can solve

    Lynn Pettis (5/11/2016)

    DuncEduardo (5/11/2016)

    Yes but you've explicitly stated numbers corresponding to calendar months from Jan - Nov. I try to avoid any form of "hard-coding".

    Nice solution though

    Luis's solution only 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

    May 11, 2016 at 10:31 am

    #1878309

  • RE: Are the posted questions getting worse?

    Phil Parkin (5/11/2016)

    Eirikur Eiriksson (5/11/2016)

    Sean Lange (5/11/2016)

    WHY OH WHY can we not get the spam under control on this site? Every morning it is about 2 spams for every actual...

    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

    May 11, 2016 at 10:22 am

    #1878307

  • RE: Simple SQL challenge - who can solve

    DuncEduardo (5/11/2016)

    I've used mixture of "while", "getdate()", "datediff" and for the minute size of it, works well.

    I'd consider tally table for something more substantial, but for the sake of 12...

    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

    May 11, 2016 at 8:39 am

    #1878260

Viewing 15 posts - 2,851 through 2,865 (of 8,731 total)