Post reply

split big query into two different query using global temp table

  • April 14, 2014 at 2:49 am

    #284482

    Hi All,

    I need urgent help, i have a query which has more than 4000 char and SSIS 2008 R2 support max 4000 char, so i need to split this query in tow different query using global temp table so i can put them in two execute sql task. Please find attached query.

    Thanks in advance...

  • April 14, 2014 at 3:15 am

    #1705679

    wouldn't creating a proc for this script and calling it in one Execute SQL task would do ?

    (by the way I did not go through the query..at this time of the day I'm too lazy to go through that code:-D )

  • April 14, 2014 at 3:32 am

    #1705688

    sorry but i cant use strorproc

  • April 14, 2014 at 6:37 am

    #1705737

    After just perusing the query I do not think you will be able to split it in two, it is too large.

    Even after replacing tab and crlf with space and removing excessive white space it is too large.

    My suggestion is to remove the first part of date processing and variable setting to separate task

    Make the last set of updates/delete which are not dependant on the temp tables to another task

    Split the rest into smaller tasks to produce resultsets that you can further merge or combine

    Far away is close at hand in the images of elsewhere.
    Anon.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply