Forum Replies Created

Viewing 15 posts - 6,721 through 6,735 (of 13,877 total)

  • RE: Finding long running query and killing it

    Chitown (9/8/2016)


    --If my question isn't clear then please tell me?--

    Seriously? Your question was this

    Can please someone help me with this?

    That's a clear question, I'll agree. Possible answers that come to...

  • RE: Finding long running query and killing it

    Can please someone help me with this?

    With what, exactly?

    We're busy people and we're not paid to answer questions here, so ...

    Please be more specific, rather than asking people to examine...

  • RE: SQL Code QA

    david.wright-948385 (9/8/2016)


    Phil Parkin (9/8/2016)


    I disagree. It makes perfect sense. He *always puts ON clauses on separate indented lines* – perfectly consistent.

    That's the point I'm making - it's consistent, but no...

  • RE: Load few tabs from excel

    abhas (9/8/2016)


    Hi Philip,

    I am able to load all tabs but how to load the tabs whose name format is : 1Q17, 4Q16,3Q16 etc.

    Thanks,

    Abhas.

    To import data from one or more named...

  • RE: UDF - Is Transaction Control possible?

    Maybe you could make use of two or more SEQUENCEs. Take a read of this and see whether it could be of help.

  • RE: SQL Code QA

    david.wright-948385 (9/8/2016)


    drew.allen (9/7/2016)


    I always put my ON clauses on a separate indented line, because I want to keep it consistent. I treat short and long JOIN clauses the same,...

  • RE: SQL Code QA

    mister.magoo (9/7/2016)


    Phil Parkin (9/7/2016)


    One thing missing from SQL Prompt, however, is the ability to change between 'my' settings (whatever works for the individual) and 'company' settings (the common format). I'd...

  • RE: SQL Code QA

    Luis Cazares (9/7/2016)


    Jason A. Long (9/7/2016)


    Speaking for all the jerk code reviewers of the world... Yes, formatting counts, yes I'll give you crap over it (when you have to...

  • RE: Dynamic Connection String Passed Through C#

    Kyle Sherry (9/7/2016)


    Not a bad suggestion which I might try next. I came across this article which might address a solution. It looks promising. I'll post update if this works...

  • RE: Load few tabs from excel

    abhas (9/7/2016)


    Hello all,

    Hope all are doing good! 🙂

    I am having a excel sheet which will contains around 20-24 tabs. Among those tabs i need to load data whose tab...

  • RE: Dynamic Connection String Passed Through C#

    Kyle Sherry (9/7/2016)


    I'm trying to create an interface that a user can select an environment to execute a package against (development, sandbox or staging) and when they select an environment...

  • RE: Changing destination csv filename

    Brad Allison (9/7/2016)


    I guess I don't understand, but each month it runs, it would be a unique file name. So next month it should be something like 20161001.csv. ...

  • RE: UDF - Is Transaction Control possible?

    NewbyUser (9/7/2016)


    Hi everybody,

    i have a problem with a scalar valued function. There are two systems who will use the function to create new "OrderNumbers".

    Sometimes the two system use the function...

  • RE: Changing destination csv filename

    Koen Verbeeck (9/7/2016)


    Brad Allison (9/7/2016)


    Is it as simple as doing this: System.IO.File.Move(@"C:\From.txt", @"C:\TO.txt"); ?

    Except I need the "TO.txt" file to be YYYYMMDD.csv

    Yes, but be aware that the Move method cannot...

  • RE: Changing destination csv filename

    Or if you are happy writing some C# and using a Script Task (my preference), it takes only three or four lines of code. I can provide an example if...

Viewing 15 posts - 6,721 through 6,735 (of 13,877 total)