Код:
DECLARE @t_guid uniqueidentifier, @deal INT
SELECT @t_guid = newid()
EXEC @deal = [gkArcade].[gk].[SYS_GEN_ID]
INSERT INTO [gkArcade].[gk].[TRANSACTS] (ACCOUNT, ACTIVITY, [DATE],
VALUE1, UNIT1, VALUE2, UNIT2, QUANT,
CREATOR, CREATORADDR, CREATORREF, CREATORDATE,
LEVEL2, [LEVEL], CARD, PERIOD )
VALUES( @CARD, 1, GETDATE(),
@PRICE, @UNIT, 1, 101, 1,
1, @MACHINE, NULL, GETDATE(),
@LEVEL2, @LEVEL, @CARD, NULL )
INSERT INTO [gkArcade].[gk].[GK_TRANSACTS]
([DATE],[ACTIVITY],[CARD],[ACCOUNT_TYPE],[VALUE],[QUANT],[CREATOR],[CREATORADDR]
,[DEAL],[LEVEL],[LEVEL2],[ARCADE],[GUID],[TRANSACT_GUID])
VALUES (GETDATE(),1,@CARD,11,0-@PRICE,1.00,1,@MACHINE,@deal,@LEVEL,@LEVEL2,1,newid(),@t_guid)
INSERT INTO [gkArcade].[gk].[GK_TRANSACTS]
([DATE],[ACTIVITY],[CARD],[ACCOUNT_TYPE],[VALUE],[QUANT],[CREATOR],[CREATORADDR]
,[DEAL],[LEVEL],[LEVEL2],[ARCADE],[GUID],[TRANSACT_GUID])
VALUES (GETDATE(),1,@CARD,3,1.00,0.00,1,@MACHINE,@deal,@LEVEL,@LEVEL2,1,newid(),@t_guid)
Просто скажите что вам нужно и я напишу код))