update ServiceCredits  set SpaTransferFlag=1
where CreditNo in (select SC.CreditNo  from SpaReservations SR,ServiceCredits SC
where SC.SpaReservationFk=SR.N
  and SR.IfPayed=2
  and SC.WhoPays=SR.GuestFK
  and SC.SpaGuestTypeFlag=SR.GuestType)
  
GO

update Services
Set ServiceType=0
where ServiceType is null

GO

update Services
Set TimeSteps=0
where TimeSteps is null