Stored Proc to assign variable from subquery not working -- ugh

[KathyB]

Hi, I'm trying to run a stored proc:

ALTER PROCEDURE dbo.UpdateXmlWF
(
@varWO varchar(50)
)
AS
DECLARE @varCust VARCHAR(50)

SELECT @varCust=(SELECT Customer FROM tblWorkOrders
WHERE WorkOrder=@varWO)

When I remove the SELECT @varCust= I get the correct return. With it
in, it just appears to run but nothing comes up in the output window.

PLEASE tell me where I'm going wrong. I'm using MSDE, although I don't
think that should matter?

Thanks, Kathy

[Chuck Urwiler]

Kathy,

I think you need this instead:

SELECT @varcust = Customer
FROM tblWorkOrders
WHERE WorkOrder = @varWO

--
-Chuck Urwiler, MCSD, MCDBA
http://www.eps-software.com
"KathyB" <Ka**********@attbi.com> wrote in message
news:75**************************@posting.google.c om...

Hi, I'm trying to run a stored proc:

ALTER PROCEDURE dbo.UpdateXmlWF
(
@varWO varchar(50)
)
AS
DECLARE @varCust VARCHAR(50)

SELECT @varCust=(SELECT Customer FROM tblWorkOrders
WHERE WorkOrder=@varWO)

When I remove the SELECT @varCust= I get the correct return. With it
in, it just appears to run but nothing comes up in the output window.

PLEASE tell me where I'm going wrong. I'm using MSDE, although I don't
think that should matter?

Thanks, Kathy

[DanRB]

Instead of "SELECT @varCust=" use "SET @varCust= "
Ka**********@attbi.com (KathyB) wrote in message news:<75**************************@posting.google. com>...

Hi, I'm trying to run a stored proc:

ALTER PROCEDURE dbo.UpdateXmlWF
(
@varWO varchar(50)
)
AS
DECLARE @varCust VARCHAR(50)

SELECT @varCust=(SELECT Customer FROM tblWorkOrders
WHERE WorkOrder=@varWO)

When I remove the SELECT @varCust= I get the correct return. With it
in, it just appears to run but nothing comes up in the output window.

PLEASE tell me where I'm going wrong. I'm using MSDE, although I don't
think that should matter?

Thanks, Kathy