INSERTe et SELECT under TRIGGER

Kan det virkelig passe at man ikke kan følgende:

CREATE TRIGGER booking_til_salg
ON superSalg
AFTER INSERT
AS
BEGIN

DECLARE @bookingnr INT
SELECT @bookingnr = (SELECT bookingnr FROM INSERTED)

DECLARE @ordrenr INT
SELECT @ordrenr = (SELECT ordrenr FROM INSERTED)

INSERT INTO salg (forestillingsnr, saedeID, ordrenr)
VALUES ((SELECT forestillingsnr, saedeID FROM booking WHERE bookingnr = @bookingnr), @ordrenr)

DELETE FROM superBooking WHERE bookingnr = @bookingnr
DELETE FROM booking WHERE bookingnr = bookingnr

END

jeg får en fejl om at man ikke må bruge subqueries i denne sammenhæng :-(

/kovalt