USE [DatabaseName]
GO

DECLARE @YYYYMM		INT
SET @YYYYMM = 201305

/**** UPDATE TRAILING PROJECT STATUS ****/
UPDATE ptd
SET ptd.Status = 'T'
FROM dbo.CTC_PTD ptd
	INNER JOIN dbo.CTC_FINISHED fin ON ptd.strProject = fin.strProject AND ptd.[System] = fin.[System]
WHERE ptd.FiscalPeriod = @YYYYMM AND fin.Finished_Period < @YYYYMM
GO

/**** UPDATE TIP INTO CTC_PTD ****/

UPDATE ctc
SET ctc.Current_TIP_Approved = tip.TIP_Amount, ctc.TIP = tip.TIP_Current, ctc.PTD_TIP = tip.TIP_Current + tip.TIP_Previous
FROM dbo.CTC_PTD ctc 
	INNER JOIN TIP_RECOGNITION tip ON ctc.strProject = tip.strProject AND ctc.[System] = tip.[System] AND ctc.FiscalPeriod = tip.FiscalPeriod
WHERE ctc.FiscalPeriod = @YYYYMM 
GO