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

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • 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