SQL Server 存储过程 SP_Get_EOL：获取产品 EOL 信息

{ "title": "CREATE PROCEDURE [dbo].SP_Get_EOL\n @yyzx NVARCHAR(20), --营运中心\n @pinhao NVARCHAR(128) --品号\nAS \nEXEC SP_PLM_COLPIVOT\n@TABLENAME = N'select t3.KEYED_NAME as part_number,t1.SHKBD_ALREADY_TO_ERP,t1.SHKBD_EOL_NUM,t2.FIELD_NAME,t2.FIELD_VALUE,\nnull as shkbd_customer_nr,null as shkbd_product,null as shkbd_product_hw_nr,null as shkbd_customer_product_nr,\nnull as shkbd_software_ver,null as shkbd_supplier_nr,null as shkbd_hardware_ver,null as shkbd_inner_product_nr,\nnull as shkbd_em_ver,null as shkbd_bom_ver,null as shkbd_label_address,null as shkbd_label_group_address,\nnull as shkbd_customer_sw_num,null as shkbd_customer_hw_num,null as shkbd_zgs_paper_num,null as shkbd_color_code,\nnull as shkbd_install_position,null as shkbd_deng_code,null as zsb_num,null as led_bin_location,null as color_diff_ver,\nnull as product_name,null as shkbd_customer_nr2,null as shkbd_ab_bom,null as shkbd_engineerquality_version,\nnull as shkbd_manufacturing_location,null as shkbd_t1num,null as tooling_generation,null as shkbd_fullversion,\nnull as eu_mark,null as shkbd_lrtag,null as shkbd_special_id,null as shkbd_cpu_manufactory,\nnull as me,null as emc,null as shkbd_software_version,null as shkbd_ecu_product_plant_number,null as shkbd_part_number,\nnull as shkbd_ecu_manufacturing_date,null as shkbd_hardware_part_number,null as shkbd_ecu_product_test_sys_num,\nnull as shkbd_hardware_version,null as shkbd_consecutive_supplier_num,null as shkbd_nodeadress,null as shkbd_groupadress,\nnull as shkbd_brightnesscoefficient,null as shkbd_bom,null as shkbd_bootloader,null as shkbd_bootloaderkey,null as shkbd_r,\nnull as shkbd_g,null as shkbd_b,null as shkbd_acutive_diag_info,null as shkbd_software_part_number,null as shkbd_mb_hw_version,\nnull as shkbd_mb_sw_version,null as shkbd_hw_supplier_identification,null as shkbd_supplier_identification,null as shkbd_supplier_hw_version,\nnull as shkbd_supplier_sw_version,null as cpu_type,null as core_part_num,null as dataset,null as shkbd_customer_app_sw_version,null as supplier_code,\nnull as shkbd_customer_ecu_sw_version,null as mcu_version,null as dsp_version,null as adas_version,null as boot_version,null as shkbd_assembly_number,\nnull as shkbd_bgr_no,null as shkbd_asw_ver,null as shkbd_algorithmfactor,null as shkbd_bsw_ver,null as red_diff_x,null as red_diff_y,null as red_diff_l,\nnull as green_diff_x,null as green_diff_y,null as green_diff_l,null as blue_diff_x,null as blue_diff_y,null as blue_diff_l,null as platform,null as function_id,\nnull as change_id,null as led_supplier_id,null as supplier_id,null as close_low_voltage,null as open_low_voltage,null as close_high_voltage,\nnull as open_high_voltage,null as light_level,null as lc0_short_voltage,null as lc0_open_voltage,null as lc1_short_voltage,null as lc1_open_voltage,\nnull as lc2_short_voltage,null as lc2_open_voltage,null as lc_current_setting,null as led_time_share_setting,null as capacitance_type,null as mcu_hot_param,\nnull as lc0_hot_param,null as lc1_hot_param,null as lc2_hot_param,null as high_voltage_hot_param,null as low_voltage_hot_param,null as lc0_capacitance_compensation,\nnull as lc1_capacitance_compensation,null as lc2_capacitance_compensation,\nfrom Aras_PLM.innovator.bom_label_and_eol_info_to_erp t1\nleft join Aras_PLM.innovator.EOL_INFO t2 on t2.SOURCE_ID = t1.id \nleft join Aras_PLM.innovator.part t3 on t3.id in (select related_id from Aras_PLM.innovator.EOL_PART ep where source_id = t1.id )\nwhere 1 = 1\nand t1.state in(''released'', ''in change'')\nand t1.old_or_new_signs = ''2''',\n@GROUPCOLUMN = N'part_number',\n@JSTYPE = N'MAX',\n@ROW2COLUMN = N'FIELD_NAME',\n@ROW2COLUMNVALUE = N'FIELD_VALUE',\n@SQL_WHERE = N'where 1 = 1' ;\n执行报错可能是因为以下原因之一：\n1. 存储过程中的参数没有正确传递或传递的类型不匹配。\n2. 存储过程中的表名、列名等对象名称错误或不存在。\n3. 存储过程中的查询语句语法错误。\n4. 存储过程中的条件语句逻辑错误。\n5. 存储过程中的权限不足以执行所需的操作。\n\n请检查以上可能的原因，并修正相关问题。如果问题仍然存在，请提供错误信息或详细的报错内容以便进一步分析。