[@FlyGirl]

Rf_User to Billing

insert into BILLING.dbo.tbl_personal_billing (id)
select id from RF_USER.dbo.tbl_rfaccount

update RF_User.dbo.tbl_rfaccount
set accounttype = 1
where accounttype = 0

ADD_ACCOUNT_BILLING

DECLARE @name VARCHAR(13)
DECLARE @pw VARCHAR(13)
DECLARE @birth smalldatetime
DECLARE @email varchar(255)
DECLARE @status int
DECLARE @cash int
DECLARE @lama int

/****** Login ******/
SET @name = 'Admin'

/****** Password ******/
SET @pw = '0381956z'

/****** Birthday ******/
SET @birth = '2024-01-20 20:25:00'

/****** Your Email ******/
SET @email = 'Test@gmail.com'

/****** Set 2 for turn on Premium or Set 1 for turn off Premium ******/
SET @status = '2'

/****** How long players get premium service (in days) exemple : 1 for 1 days, 2 for 2 days, 3 for 3days. ******/
SET @lama = '5'

/****** Cashpoint amount ******/
SET @cash = '900000'


INSERT INTO [RF_USER].[dbo].[tbl_rfaccount] ([id],[password],[birthdate],[Email])
VALUES(CONVERT(BINARY(13),@name),CONVERT(BINARY(13),@pw),@birth,@email)

INSERT INTO [BILLING].[dbo].[tbl_UserStatus] ([id],[Status],[DTStartPrem],[DTEndPrem],[Cash])
VALUES(@name,@status,CONVERT(datetime,GETDATE()),CONVERT(datetime,GETDATE()+@lama),@cash)

При желании подправишь как нужно.