Forum Replies Created

Viewing 15 posts - 1,801 through 1,815 (of 8,731 total)

  • RE: Output Full Result Set to a Table - Article

    Welsh Corgi (12/1/2016)

    I just ask for guidance.

    I think that it is pretty clear what I want.

    I'm sure that you've been guided to this article before, but this is an example...

    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

    December 1, 2016 at 9:39 am

    #1915478

  • RE: Output Full Result Set to a Table - Article

    Welsh Corgi (12/1/2016)

    Luis Cazares (12/1/2016)

    Welsh Corgi (12/1/2016)

    ok, I'm sorry for not being clear.

    The following article is great but it does it drops off on returning full record set.

    https://www.simple-talk.com/sql/ssis/ssis-basics-using-the-execute-sql-task-to-generate-result-sets

    I need 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

    December 1, 2016 at 9:33 am

    #1915474

  • RE: Output Full Result Set to a Table - Article

    Welsh Corgi (12/1/2016)

    ok, I'm sorry for not being clear.

    The following article is great but it does it drops off on returning full record set.

    https://www.simple-talk.com/sql/ssis/ssis-basics-using-the-execute-sql-task-to-generate-result-sets

    I need to get the result set...

    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

    December 1, 2016 at 9:25 am

    #1915471

  • RE: Recursive CTE as View not Table Function

    SteveD SQL (12/1/2016)

    Hi Luis,

    Thanks for responding but similar to John's solution, since this is using the RootRunLogID, it doesn't allow me to filter on other RunLogs 5 thru...

    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

    December 1, 2016 at 9:23 am

    #1915469

  • RE: Today's Random Word!

    djj (12/1/2016)

    aPed001 (12/1/2016)

    Pod

    Pea

    Poe

    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

    December 1, 2016 at 9:09 am

    #1915465

  • RE: SQL Query

    Is the Med_Rec_Nbr a varchar? If it's an integer or other numeric type, you won't be able to add leading zeros.

    Here's an example:

    SELECT Nbr,

    RIGHT(REPLICATE('0',7)+Nbr,7)

    FROM (VALUES('1'),

    ...

    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

    December 1, 2016 at 9:05 am

    #1915458

  • RE: Output Full Result Set to a Table - Article

    You mean like using a query/stored procedure as source in the Data Flow task?

    That's part of SSIS 101.

    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

    December 1, 2016 at 8:41 am

    #1915443

  • RE: Best way to automate running adhoc scripts?

    WebTechie (12/1/2016)

    I would like to have an app built also.

    However, as I mentioned, I am the new guy on the block. Senior guy, but still the new guy.

    I don't...

    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

    December 1, 2016 at 8:33 am

    #1915437

  • RE: Today's Random Word!

    Grumpy DBA (12/1/2016)

    BWFC (12/1/2016)

    Rover

    Mars

    Chocolate

    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

    December 1, 2016 at 7:25 am

    #1915406

  • RE: Best way to automate running adhoc scripts?

    I'd go with the SSIS option because I know how to do it and it's pretty simple. This article might help: http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/99287/

    Another option, which might be preferred by others 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

    December 1, 2016 at 7:20 am

    #1915402

  • RE: Recursive CTE as View not Table Function

    You might want something like this?

    WITH cte_RunLogandChildren AS

    (

    -- Anchor

    SELECT rl.RunLogID AS RootRunLogID

    ,rl.RunLogID

    ...

    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

    December 1, 2016 at 6:47 am

    #1915391

  • RE: TSQL query

    abhisheka.dalal (11/30/2016)

    Thanks Kevin ... this worked for me .. i have a function in place to reformat the start date and enddate to a month end date... So i should...

    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

    November 30, 2016 at 10:12 am

    #1915230

  • RE: TSQL query

    TheSQLGuru (11/29/2016)

    Numbers Table #FTW!!

    For people that are not native English speakers, it would be easier to understand numbers table instead of tally table.

    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

    November 29, 2016 at 2:35 pm

    #1915051

  • RE: Best way to narrow results

    You could use the lookup transformation. Set the larger table as source and then the filter table in the lookup transformation. Be aware that it will have to load 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

    November 29, 2016 at 1:52 pm

    #1915038

  • RE: Time for a consultant

    TheSQLGuru (11/29/2016)

    Anything that allows developers to slap together code more quickly is inversely proportional to the performance and scalability you will get from that code.

    Loved this phrase.

    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

    November 29, 2016 at 1:21 pm

    #1915036

Viewing 15 posts - 1,801 through 1,815 (of 8,731 total)