Home Forums SQL Server 2005 SQL Server 2005 General Discussion Update stmt with in a cursor RE: Update stmt with in a cursor

  • December 18, 2013 at 10:47 am

    #1674520

    Using these two querys

    Select * from SNLunchSevereNeeds Where SystemCertificationID in(

    Select SystemCertificationID from SNSystemCertification where FiscalYear=2014 and

    SystemID=749 And IsActive=1 )

    Select * from SNLunchSevereNeeds Where SystemCertificationID in(

    Select SystemCertificationID from SNSystemCertification where FiscalYear=2013

    And IsActive=1)

    How can I update data from last year to current year (need to check system certification id from both the tables)

    see the current fiscal year for all the systems who are eligible.(updating from last year to current year)