Полезный запрос на обновление tbl_user for BILLING'a
Код:
insert into BILLING.dbo.tbl_personal_billing (id, BillingType, EndDate, RemainTime)
select id, 1, GETDATE(), 0 from RF_USER.dbo.tbl_rfaccount
insert into BILLING.dbo.tbl_user (UserID, Cash)
select id, 0 from RF_USER.dbo.tbl_rfaccount
update RF_User.dbo.tbl_rfaccount
set accounttype = 1
where accounttype = 0
Запрос делаем
Databases