Forum Replies Created

Viewing 15 posts - 286 through 300 (of 844 total)

  • RE: Convert string MMDDYYYY to a date

    To paraphrase your quote Eric, "The SSIS universe is complicated, but your SSIS life is only as complicated as you choose it to be."  
    I choose an uncomplicated SSIS life. 

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

  • RE: Convert string MMDDYYYY to a date

    Eric M Russell - Thursday, December 27, 2018 8:45 AM

    Performing transformation in the SELECT is OK, but staging the data to a...

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

  • RE: Convert string MMDDYYYY to a date

    Jeff Moden - Friday, December 21, 2018 2:06 PM

    Of course, there are those of us that don't use SSIS for any...

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

  • RE: Convert string MMDDYYYY to a date

    The first time I ran Eirikur's code the 'Cast Right Left Trim' was the fastest, I didn't get a screen shot of that.
    I've ran it about 6 times now, all...

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

  • RE: Convert string MMDDYYYY to a date

    Thanks Jeff and Eirikur.  Learned something new today, and I made a bad assumption that the substring would be the slowest solution.
    I have sent off an email asking that...

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

  • RE: Today's Random Word!

    Sean Lange - Tuesday, December 18, 2018 10:40 AM

    ZZartin - Tuesday, December 18, 2018 7:49 AM

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

  • RE: Code Reviews

    below86 - Friday, April 24, 2015 7:24 AM

    No code reviews, no DBA. Yes there are times we really should review some...

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

  • RE: Today's Random Word!

    DesNorton - Monday, December 10, 2018 2:05 AM

    Ed Wagner - Sunday, December 9, 2018 9:39 PM

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

  • RE: Today's Random Word!

    Ed Wagner - Friday, December 7, 2018 10:12 AM

    ZZartin - Friday, December 7, 2018 7:48 AM

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

  • RE: Today's Random Word!

    Ed Wagner - Wednesday, December 5, 2018 11:21 AM

    Hugo Kornelis - Wednesday, December 5, 2018 5:46 AM

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

  • RE: Two column body

    I see your issue now, I've never done that.
    Maybe check out trying to create a 'List' report.
    https://docs.microsoft.com/en-us/sql/reporting-services/tutorial-creating-a-free-form-report-report-builder?view=sql-server-2017

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

  • RE: Two column body

    Brad Allison - Tuesday, December 4, 2018 6:16 AM

    Forgive my ignorance as it has been several years since I have built a...

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

  • RE: Today's Random Word!

    saravanatn - Monday, December 3, 2018 7:37 AM

    Ed Wagner - Monday, December 3, 2018 5:54 AM

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

  • RE: Today's Random Word!

    Ed Wagner - Thursday, November 29, 2018 7:24 AM

    Revenant - Wednesday, November 28, 2018 2:37 PM

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

  • RE: CASE Statement

    From what I remember Informix isn't very good at telling you what part of the code it is having issues with,  it could be the CTE or the CROSS Apply. ...

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

Viewing 15 posts - 286 through 300 (of 844 total)