Forum Replies Created

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

  • RE: avoid install localdb through SSDT installer

    sqlfriends (9/8/2016)


    There is no localdb in BI tools in previous SQL version, so I don't think it is necessary if we have a full version of SQL installed.

    This is an...


  • RE: how boolean is converted to bit

    mcfarlandparkway (9/8/2016)


    I have a source like

    pkg_in.xml_p (decode(b.is_flg,1,'False','True'), 'ISDFLG')

    So from source is returning true or false

    When source is loaded into destination how this Boolean is converted to...


  • 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...


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