Stored procedure problem

[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 into a Datatable ("Orders") "Name" and "Address" from a
datatable called "customer"
with the parameters customerId = @CustomerId

I also want to insert into the same Datatable ("orders") at the same time
"Name" and "Cost"
from a datatable called "products". The input parameter for this is cartID =
@cartId

I have tried this but it doesnt seem to work. Can anyone tell me where i am
going wrong.

CREATE PROCEDURE SP_CreateOrder
(@CustomerID Varchar (50), @CartID Char (36))

AS

INSERT INTO Orders (Name, Address, Name, Cost)

SELECT customer.Name, customer.Address, products.Name, products.Cost

FROM Customer AND Products Join ShoppingCart ON Products.ProductID =
ShoppingCart.ProductID

WHERE ShoppingCart.CartID = @CartID AND customerId = @CustomerId

--
Message posted via DotNetMonster.com
http://www.dotnetmonster.com/Uwe/For...p-net/200511/1

[Eliyahu Goldin]

Your FROM clause in invalid. Look up T-SQL syntax for joins in any resource
available to you. It is hard to give a more precise advise without knowing
your tables structure and what exactly you want to achieve.

Eliyahu

"martinharvey via DotNetMonster.com" <u14945@uwe> wrote in message
news:5807489da7800@uwe...

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

I want to insert into a Datatable ("Orders") "Name" and "Address" from a
datatable called "customer"
with the parameters customerId = @CustomerId

I also want to insert into the same Datatable ("orders") at the same time
"Name" and "Cost"
from a datatable called "products". The input parameter for this is cartID
=
@cartId

I have tried this but it doesnt seem to work. Can anyone tell me where i
am
going wrong.

CREATE PROCEDURE SP_CreateOrder
(@CustomerID Varchar (50), @CartID Char (36))

AS

INSERT INTO Orders (Name, Address, Name, Cost)

SELECT customer.Name, customer.Address, products.Name, products.Cost

FROM Customer AND Products Join ShoppingCart ON Products.ProductID =
ShoppingCart.ProductID

WHERE ShoppingCart.CartID = @CartID AND customerId = @CustomerId

--
Message posted via DotNetMonster.com
http://www.dotnetmonster.com/Uwe/For...p-net/200511/1

[Venkat_KL]

Dear martinharvey,

(via:DotNetMonster.com)

There is no AND if you are working on two tables, it is only ( , ) comma;
With Comma, It works fine:

CREATE PROCEDURE SP_CreateOrder
(@CustomerID Varchar (50), @CartID Char (36))
AS
INSERT INTO Orders (Name,Address,ProductName,Cost)
SELECT customer.Name, customer.Address, products.ProductName,products.Cost
FROM Customer , Products Join ShoppingCart ON Products.ProductID =
ShoppingCart.ProductID WHERE ShoppingCart.CartID = @CartID AND customerId =
@CustomerId

Bye
Venkat_KL

[martinharvey via DotNetMonster.com]

Eliyahu Goldin wrote:

Your FROM clause in invalid. Look up T-SQL syntax for joins in any resource
available to you. It is hard to give a more precise advise without knowing
your tables structure and what exactly you want to achieve.

Eliyahu

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

[quoted text clipped - 26 lines]

WHERE ShoppingCart.CartID = @CartID AND customerId = @CustomerId

many thanks for your help again Eliyahu
mart

--
Message posted via DotNetMonster.com
http://www.dotnetmonster.com/Uwe/For...p-net/200511/1

[martinharvey via DotNetMonster.com]

Venkat_KL wrote:

Dear martinharvey,

(via:DotNetMonster.com)

There is no AND if you are working on two tables, it is only ( , ) comma;
With Comma, It works fine:

CREATE PROCEDURE SP_CreateOrder
(@CustomerID Varchar (50), @CartID Char (36))
AS
INSERT INTO Orders (Name,Address,ProductName,Cost)
SELECT customer.Name, customer.Address, products.ProductName,products.Cost
FROM Customer , Products Join ShoppingCart ON Products.ProductID =
ShoppingCart.ProductID WHERE ShoppingCart.CartID = @CartID AND customerId =
@CustomerId

Bye
Venkat_KL

This was very helpful I will give it a try

many thanks

martin

--
Message posted via http://www.dotnetmonster.com