﻿------------------------------- انتقال به فیلد جدید
--select d.* 
update d set d.Taf_ID_Wage = d.Taf_ID
from DaryaftPardakht d
	inner join Tafsili taf on d.Taf_ID = taf.ID and taf.Dom_ID_Noe = 48 /*هزینه*/
where
	d.Dom_ID_NoeMaster = 39 and 
	d.Dom_ID_NoeDetail = 45 and
	d.Taf_ID_Wage is null

---------------------------- خالی کردن فیلد قدیمی

--select d.* 
update d set d.Taf_ID = null
from DaryaftPardakht d
	inner join Tafsili taf on d.Taf_ID = taf.ID and taf.Dom_ID_Noe = 48 /*هزینه*/
where
	d.Dom_ID_NoeMaster = 39 and 
	d.Dom_ID_NoeDetail = 45 and
	d.Taf_ID_Wage is not null
