SET @Sql = ' select OPTION_VALUE from SALES.CFG_ID_COLOR_LIST_VW where PRODUCT_NAME = '''+@EBSlevel0+''' and SERIES_NAME = '''+@SERIES_NAME+''''
SET @Sql = ' insert into ProductColors (productid,option_value,userid) SELECT '+@Productid+', OPTION_VALUE ,'+@userid +' FROM OPENQUERY([ETEAMQC1], ''' + REPLACE(@Sql, '''', '''''') + ''')'
EXEC(@Sql)