update d set d.pro_ID_vahedMali = m.pro_ID_vahedMali from GardesheChek d inner join DaryaftPardakht m on m.ID = d.DaryaftPardakht_ID where d.pro_ID_vahedMali = -1 go update d set d.fc_ID = (select ID from Finance_Cycle f where d.Tarikh >= f.TarikhAz and d.Tarikh <= f.TarikhEla) from GardesheChek d inner join DaryaftPardakht m on m.ID = d.DaryaftPardakht_ID where d.fc_ID = -1