I have a temporary shoppingcart-table that I want to transfer to an OrderDetail-table. See following code:
CREATE PROCEDURE add_orderdetails
@.CartID int,
@.OrderID int
AS
BEGIN TRAN AddOrderDetail
INSERT INTO OrderDetails
(OrderID, ProductID, Quantity, Price)
VALUES
(@.OrderID, SELECT ProductID, Quantity, Price FROM Cart WHERE CartID=@.CartID)
COMMIT TRAN AddOrderDetail
GO
The OrderID and CartID are inputs from an asp-page.
I got an syntax-error near SELECT and ')'.
I hope someone is able to help me with this. I will be very grateful!I helped myself. If I remove the VALUES, and put the SELECT-sentence like this:
SELECT @.OrderID AS OrderID, ProductID, ....
Jippi :o)
|
No comments:
Post a Comment