Stored procedure syntax

  • Thread starter Thread starter martinharvey via DotNetMonster.com
  • Start date Start date
M

martinharvey via DotNetMonster.com

This is probably a very simple question but i am having problems with a
stored procedure syntax.

I want to insert fields with preset values (DateCreated/OrderVerified)

and two values (Name/ Address1) from a databletable called
"Customer" and insert both of these into a datatable called "Orders"



I have tried the following syntax but it is not working. Can anyone tell me
where i am going wrong


CREATE PROCEDURE SP_CreateOrder

(@CustomerID Varchar(50))

AS
INSERT INTO Orders (DateCreated, Verified)
VALUES ( GETDATE(), 0,)
AND INSERT Into Orders (Name, Address)
SELECT (Customer.Name, Customer.Address)
FROM Customer

WHERE CustomerID = @CustomerID


Many thanks martin
 
CREATE PROCEDURE SP_CreateOrder

(@CustomerID Varchar(50))

AS
INSERT Into Orders (DateCreated, Verified, Name, Address)
SELECT ( GETDATE(), 0, Customer.Name, Customer.Address)
FROM Customer

WHERE CustomerID = @CustomerID

Eliyahu
 
Eliyahu said:
CREATE PROCEDURE SP_CreateOrder

(@CustomerID Varchar(50))

AS
INSERT Into Orders (DateCreated, Verified, Name, Address)
SELECT ( GETDATE(), 0, Customer.Name, Customer.Address)
FROM Customer

WHERE CustomerID = @CustomerID

Eliyahu
Click to expand...
many thanks

martin
This is probably a very simple question but i am having problems with a
stored procedure syntax.
Click to expand...
[quoted text clipped - 22 lines]
Many thanks martin
Click to expand...
Click to expand...
 
Back
Top