Home Forums SQL Server 2005 SQL Server 2005 General Discussion Need help on creating SQL statement for deriving Consecutive worked days. RE: Need help on creating SQL statement for deriving Consecutive worked days.

  • December 12, 2012 at 10:49 pm

    #1568152

    Hi Lyn,

    Thanks for ur reply i will test that soon. Currently i just do not know how to implement my 8 SQL statements in SSIS. TROUBLED:( Just by using this will be able to help me derive my target table but my supervisore hopes to see a neat process using SSIS.

    I did it by, using SQL statement 1 will create T1, then i use SQL statment to query from t1 to derive T2, then drop T1........to SQL8 to create TARGET_TABLE, drop T7. I know i have used a very noob way. How can i translate all these and use it in SSIS?