Parsing variables from a select SP to an update SP

[holly]

Hi

I need to pass pass variables from my select SP to an update SP...
Has anyone got any ideas?

my select SP is as follows

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO
 
 
 
ALTER  PROCEDURE [update_TBL_SCALE_EVENT_2]
@ProductID char(20),
@Scale_Event_ID numeric output 
 
as
 
DECLARE @ErrorSave INT
SET @ErrorSave = 0
 
SELECT     LABEL_SPECIFICATION.PRODUCT_CODE, LABEL_SPECIFICATION.PRODUCT_LINE, LABEL_SPECIFICATION.PACKAGE_SPECIFICATION_NUMBER, 
                      LABEL_SPECIFICATION.PRODUCT_DESCRIPTION, LABEL_SPECIFICATION.TWIST_1, 
                      LABEL_SPECIFICATION.AFTER_TREATMENT, LABEL_SPECIFICATION.ENDS, LABEL_SPECIFICATION.SURFACE_DENSITY, 
                      LABEL_SPECIFICATION.METRIC_DESCRIPTION, LABEL_SPECIFICATION.AVERAGE_UNIT, 
                      LABEL_SPECIFICATION.SPECIAL_DESCRIPTION, LABEL_SPECIFICATION.TIE_ON_TAILS, LABEL_SPECIFICATION.OVERSPRAY, 
                      PACKAGING_SPECIFICATION.PACKAGE_SPECIFICATION_REVISION,  
                    PACKAGING_SPECIFICATION.CARTONS_PER_PALLET, 
                      PACKAGING_SPECIFICATION.INDIVIDUAL_PACKAGE_WEIGHT,PACKAGING_SPECIFICATION.PALLET_LENGTH,PACKAGING_SPECIFICATION.TARE_WEIGHT_OF_PACKAGING
FROM         LABEL_SPECIFICATION INNER JOIN
                      PACKAGING_SPECIFICATION ON 
                      LABEL_SPECIFICATION.PACKAGE_SPECIFICATION_NUMBER = PACKAGING_SPECIFICATION.PACKAGE_SPECIFICATION_NUMBER
where Label_Specification.Product_Code = @ProductID
 
 
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

the returned RS needs to be passed to be update SP

Thanks