﻿update d set
    WeekOfYear = (
        SELECT COUNT(*)
        FROM Finance_Cycle_Detail X
        WHERE X.Year = D.Year
          AND X.JDate <= D.JDate
          AND X.Dom_ID_DayOfWeek = 673
    )  ,

    WeekOfMonth = (
        SELECT COUNT(*)
        FROM Finance_Cycle_Detail X
        WHERE X.Year = D.Year
          AND X.Month = D.Month
          AND X.JDate <= D.JDate
          AND X.Dom_ID_DayOfWeek = 673
    )  

FROM Finance_Cycle_Detail D
where WeekOfYear = -1 or WeekOfMonth = -1
	