quote:

---

Originally posted by cbjroms

I have created a stored procedure as follows:


CREATE PROCEDURE copy_build_options_from_to_product_id

@from_product_id char(30),

@to_product_id char(30)

AS

BEGIN

-- stage one - update the main cm nodes table

UPDATE

CM_products

SET

product_build_options_hdg1 = (SELECT TOP 1 p.product_build_options_hdg1 FROM CM_products p WHERE p.product_id = @from_product_id),

product_build_options_hdg2 = (SELECT TOP 1 p.product_build_options_hdg2 FROM CM_products p WHERE p.product_id = @from_product_id),

product_build_options_hdg3 = (SELECT TOP 1 p.product_build_options_hdg3 FROM CM_products p WHERE p.product_id = @from_product_id),

product_build_options_hdg4 = (SELECT TOP 1 p.product_build_options_hdg4 FROM CM_products p WHERE p.product_id = @from_product_id),

product_build_options_hdg5 = (SELECT TOP 1 p.product_build_options_hdg5 FROM CM_products p WHERE p.product_id = @from_product_id)

WHERE

product_id = @to_product_id

;

-- stage two - delete any old build options which were already there for the target

DELETE FROM

CM_product_build_options

WHERE

product_id = @to_product_id

;

-- stage three - copy them in from the source record

INSERT INTO CM_product_build_options

SELECT NEWID() AS 'product_build_option_id',

pbo.product_build_option_item_hdg AS 'product_build_option_hdg',

pbo.product_build_option_desc AS 'product_build_option_desc',

@to_product_id AS 'product_id'

FROM CM_product_build_options AS pbo

WHERE pbo.product_id = @from_product_id

;

END



RETURN

When I run the procedure using:

EXEC copy_build_options_from_to_product_id ‘110125’,’110110’

I get an error The query could not run because: Incorrect syntax near "'

Can anyone out there see where I have got the syntax wrong?

Thanks in anticipation.

Chris

---