Post reply

problem with variables..

  • July 26, 2010 at 1:20 am

    #157100

    Hi Everyone..

    I have modified date in my source table,i want ot do incremental loading,i want to save the last modified date in one table and i want to compare with that date like modified date > saved date,like this scenario i wants to do incremental loading,can any one tell me the solution that how can i achieve this.And i want to create a variable that each time it should take the last modifieddate .

    Regards..
    guru12

  • July 26, 2010 at 1:41 am

    #1198050

    use getdate() for last_modified... gives current datetime....

  • July 26, 2010 at 1:44 am

    #1198052

    Hi Sumit..

    Can you briefly explain it,step by step.

    Regards..
    guru12

  • July 26, 2010 at 3:36 am

    #1198086

    This thread looks very similar to this one:

    http://www.sqlservercentral.com/Forums/Topic955373-148-1.aspx#bm955545

    Why are you asking the same, or nearly the same, question again? What was wrong with the solutions proposed?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • July 26, 2010 at 3:46 am

    #1198090

    Hi phil,

    Actual the problem was i want to compare with the last modified date and above that date i want to load,your solutions are fine what you have given earlier,but i need to load above the modified date records,so i want to pass variables ,can you give the solution.

    Regards..
    guru12

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

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