[步骤]
(@OrderSourceID_1 int,@CardNo_1 nvarchar(100),@OrderSourceID_2 int,@CardNo_2 nvarchar(100),@OrderSourceID_3 int,@CardNo_3 nvarchar(100),@OrderSourceID_4 int,@CardNo_4 nvarchar(100),@OrderSourceID_5 int,@CardNo_5 nvarchar(100),@OrderSourceID_6 int,@CardNo_6 nvarchar(100),@OrderSourceID_7 int,@CardNo_7 nvarchar(100),@OrderSourceID_8 int,@CardNo_8 nvarchar(100),@OrderSourceID_9 int,@CardNo_9 nvarchar(100),@OrderSourceID_10 int,@CardNo_10 nvarchar(100),@OrderSourceID_11 int,@CardNo_11 nvarchar(100),@OrderSourceID_12 int,@CardNo_12 nvarchar(100),@OrderSourceID_13 int,@CardNo_13 nvarchar(100),@OrderSourceID_14 int,@CardNo_14 nvarchar(100),@OrderSourceID_15 int,@CardNo_15 nvarchar(100),@OrderSourceID_16 int,@CardNo_16 nvarchar(100),@OrderSourceID_17 int,@CardNo_17 nvarchar(100),@OrderSourceID_18 int,@CardNo_18 nvarchar(100),@OrderSourceID_19 int,@CardNo_19 nvarchar(100),@OrderSourceID_20 int,@CardNo_20 nvarchar(100),@OrderSourceID_21 int,@CardNo_21 nvarchar(100),@OrderSourceID_22 int,@CardNo_22 nvarchar(100),@OrderSourceID_23 int,@CardNo_23 nvarchar(100),@OrderSourceID_24 int,@CardNo_24 nvarchar(100),@OrderSourceID_25 int,@CardNo_25 nvarchar(100),@OrderSourceID_26 int,@CardNo_26 nvarchar(100),@OrderSourceID_27 int,@CardNo_27 nvarchar(100),@OrderSourceID_28 int,@CardNo_28 nvarchar(100),@OrderSourceID_29 int,@CardNo_29 nvarchar(100),@OrderSourceID_30 int,@CardNo_30 nvarchar(100),@OrderSourceID_31 int,@CardNo_31 nvarchar(100),@OrderSourceID_32 int,@CardNo_32 nvarchar(100),@OrderSourceID_33 int,@CardNo_33 nvarchar(100),@OrderSourceID_34 int,@CardNo_34 nvarchar(100),@OrderSourceID_35 int,@CardNo_35 nvarchar(100),@OrderSourceID_36 int,@CardNo_36 nvarchar(100),@OrderSourceID_37 int,@CardNo_37 nvarchar(100),@OrderSourceID_38 int,@CardNo_38 nvarchar(100),@OrderSourceID_39 int,@CardNo_39 nvarchar(100),@OrderSourceID_40 int,@CardNo_40 nvarchar(100),@OrderSourceID_41 int,@CardNo_41 nvarchar(100),@OrderSourceID_42 int,@CardNo_42 nvarchar(100),@OrderSourceID_43 int,@CardNo_43 nvarchar(100),@OrderSourceID_44 int,@CardNo_44 nvarchar(100),@OrderSourceID_45 int,@CardNo_45 nvarchar(100),@OrderSourceID_46 int,@CardNo_46 nvarchar(100),@OrderSourceID_47 int,@CardNo_47 nvarchar(100),@OrderSourceID_48 int,@CardNo_48 nvarchar(100),@OrderSourceID_49 int,@CardNo_49 nvarchar(100),@OrderSourceID_50 int,@CardNo_50 nvarchar(100),@OrderSourceID_51 int,@CardNo_51 nvarchar(100),@OrderSourceID_52 int,@CardNo_52 nvarchar(100),@OrderSourceID_53 int,@CardNo_53 nvarchar(100),@OrderSourceID_54 int,@CardNo_54 nvarchar(100),@OrderSourceID_55 int,@CardNo_55 nvarchar(100),@OrderSourceID_56 int,@CardNo_56 nvarchar(100),@OrderSourceID_57 int,@CardNo_57 nvarchar(100),@OrderSourceID_58 int,@CardNo_58 nvarchar(100),@OrderSourceID_59 int,@CardNo_59 nvarchar(100),@OrderSourceID_60 int,@CardNo_60 nvarchar(100),@OrderSourceID_61 int,@CardNo_61 nvarchar(100),@OrderSourceID_62 int,@CardNo_62 nvarchar(100),@OrderSourceID_63 int,@CardNo_63 nvarchar(100),@OrderSourceID_64 int,@CardNo_64 nvarchar(100),@OrderSourceID_65 int,@CardNo_65 nvarchar(100),@OrderSourceID_66 int,@CardNo_66 nvarchar(100),@OrderSourceID_67 int,@CardNo_67 nvarchar(100),@OrderSourceID_68 int,@CardNo_68 nvarchar(100),@OrderSourceID_69 int,@CardNo_69 nvarchar(100),@OrderSourceID_70 int,@CardNo_70 nvarchar(100),@OrderSourceID_71 int,@CardNo_71 nvarchar(100),@OrderSourceID_72 int,@CardNo_72 nvarchar(100),@OrderSourceID_73 int,@CardNo_73 nvarchar(100),@OrderSourceID_74 int,@CardNo_74 nvarchar(100),@OrderSourceID_75 int,@CardNo_75 nvarchar(100),@OrderSourceID_76 int,@CardNo_76 nvarchar(100),@OrderSourceID_77 int,@CardNo_77 nvarchar(100),@OrderSourceID_78 int,@CardNo_78 nvarchar(100),@OrderSourceID_79 int,@CardNo_79 nvarchar(100),@OrderSourceID_80 int,@CardNo_80 nvarchar(100),@OrderSourceID_81 int,@CardNo_81 nvarchar(100),@OrderSourceID_82 int,@CardNo_82 nvarchar(100),@OrderSourceID_83 int,@CardNo_83 nvarchar(100),@OrderSourceID_84 int,@CardNo_84 nvarchar(100),@OrderSourceID_85 int,@CardNo_85 nvarchar(100),@OrderSourceID_86 int,@CardNo_86 nvarchar(100),@OrderSourceID_87 int,@CardNo_87 nvarchar(100),@OrderSourceID_88 int,@CardNo_88 nvarchar(100),@OrderSourceID_89 int,@CardNo_89 nvarchar(100),@OrderSourceID_90 int,@CardNo_90 nvarchar(100),@OrderSourceID_91 int,@CardNo_91 nvarchar(100),@OrderSourceID_92 int,@CardNo_92 nvarchar(100),@OrderSourceID_93 int,@CardNo_93 nvarchar(100),@OrderSourceID_94 int,@CardNo_94 nvarchar(100),@OrderSourceID_95 int,@CardNo_95 nvarchar(100),@OrderSourceID_96 int,@CardNo_96 nvarchar(100),@OrderSourceID_97 int,@CardNo_97 nvarchar(100),@OrderSourceID_98 int,@CardNo_98 nvarchar(100),@OrderSourceID_99 int,@CardNo_99 nvarchar(100),@OrderSourceID_100 int,@CardNo_100 nvarchar(100),@OrderSourceID_101 int,@CardNo_101 nvarchar(100),@OrderSourceID_102 int,@CardNo_102 nvarchar(100),@OrderSourceID_103 int,@CardNo_103 nvarchar(100),@OrderSourceID_104 int,@CardNo_104 nvarchar(100),@OrderSourceID_105 int,@CardNo_105 nvarchar(100),@OrderSourceID_106 int,@CardNo_106 nvarchar(100),@OrderSourceID_107 int,@CardNo_107 nvarchar(100),@OrderSourceID_108 int,@CardNo_108 nvarchar(100),@OrderSourceID_109 int,@CardNo_109 nvarchar(100),@OrderSourceID_110 int,@CardNo_110 nvarchar(100),@OrderSourceID_111 int,@CardNo_111 nvarchar(100),@OrderSourceID_112 int,@CardNo_112 nvarchar(100),@OrderSourceID_113 int,@CardNo_113 nvarchar(100),@OrderSourceID_114 int,@CardNo_114 nvarchar(100),@OrderSourceID_115 int,@CardNo_115 nvarchar(100),@OrderSourceID_116 int,@CardNo_116 nvarchar(100),@OrderSourceID_117 int,@CardNo_117 nvarchar(100),@OrderSourceID_118 int,@CardNo_118 nvarchar(100),@OrderSourceID_119 int,@CardNo_119 nvarchar(100),@OrderSourceID_120 int,@CardNo_120 nvarchar(100),@OrderSourceID_121 int,@CardNo_121 nvarchar(100),@OrderSourceID_122 int,@CardNo_122 nvarchar(100),@OrderSourceID_123 int,@CardNo_123 nvarchar(100),@OrderSourceID_124 int,@CardNo_124 nvarchar(100),@OrderSourceID_125 int,@CardNo_125 nvarchar(100),@OrderSourceID_126 int,@CardNo_126 nvarchar(100),@OrderSourceID_127 int,@CardNo_127 nvarchar(100),@OrderSourceID_128 int,@CardNo_128 nvarchar(100),@OrderSourceID_129 int,@CardNo_129 nvarchar(100),@OrderSourceID_130 int,@CardNo_130 nvarchar(100),@OrderSourceID_131 int,@CardNo_131 nvarchar(100),@OrderSourceID_132 int,@CardNo_132 nvarchar(100),@OrderSourceID_133 int,@CardNo_133 nvarchar(100),@OrderSourceID_134 int,@CardNo_134 nvarchar(100),@OrderSourceID_135 int,@CardNo_135 nvarchar(100),@OrderSourceID_136 int,@CardNo_136 nvarchar(100),@OrderSourceID_137 int,@CardNo_137 nvarchar(100),@OrderSourceID_138 int,@CardNo_138 nvarchar(100),@OrderSourceID_139 int,@CardNo_139 nvarchar(100),@OrderSourceID_140 int,@CardNo_140 nvarchar(100),@OrderSourceID_141 int,@CardNo_141 nvarchar(100),@OrderSourceID_142 int,@CardNo_142 nvarchar(100),@OrderSourceID_143 int,@CardNo_143 nvarchar(100),@OrderSourceID_144 int,@CardNo_144 nvarchar(100),@OrderSourceID_145 int,@CardNo_145 nvarchar(100),@OrderSourceID_146 int,@CardNo_146 nvarchar(100),@OrderSourceID_147 int,@CardNo_147 nvarchar(100),@OrderSourceID_148 int,@CardNo_148 nvarchar(100),@OrderSourceID_149 int,@CardNo_149 nvarchar(100),@OrderSourceID_150 int,@CardNo_150 nvarchar(100),@OrderSourceID_151 int,@CardNo_151 nvarchar(100),@OrderSourceID_152 int,@CardNo_152 nvarchar(100),@OrderSourceID_153 int,@CardNo_153 nvarchar(100),@OrderSourceID_154 int,@CardNo_154 nvarchar(100),@OrderSourceID_155 int,@CardNo_155 nvarchar(100),@OrderSourceID_156 int,@CardNo_156 nvarchar(100),@OrderSourceID_157 int,@CardNo_157 nvarchar(100),@OrderSourceID_158 int,@CardNo_158 nvarchar(100),@OrderSourceID_159 int,@CardNo_159 nvarchar(100),@OrderSourceID_160 int,@CardNo_160 nvarchar(100),@OrderSourceID_161 int,@CardNo_161 nvarchar(100),@OrderSourceID_162 int,@CardNo_162 nvarchar(100),@OrderSourceID_163 int,@CardNo_163 nvarchar(100),@OrderSourceID_164 int,@CardNo_164 nvarchar(100),@OrderSourceID_165 int,@CardNo_165 nvarchar(100),@OrderSourceID_166 int,@CardNo_166 nvarchar(100),@OrderSourceID_167 int,@CardNo_167 nvarchar(100),@OrderSourceID_168 int,@CardNo_168 nvarchar(100),@OrderSourceID_169 int,@CardNo_169 nvarchar(100),@OrderSourceID_170 int,@CardNo_170 nvarchar(100),@OrderSourceID_171 int,@CardNo_171 nvarchar(100),@OrderSourceID_172 int,@CardNo_172 nvarchar(100),@OrderSourceID_173 int,@CardNo_173 nvarchar(100),@OrderSourceID_174 int,@CardNo_174 nvarchar(100),@OrderSourceID_175 int,@CardNo_175 nvarchar(100),@OrderSourceID_176 int,@CardNo_176 nvarchar(100),@OrderSourceID_177 int,@CardNo_177 nvarchar(100),@OrderSourceID_178 int,@CardNo_178 nvarchar(100),@OrderSourceID_179 int,@CardNo_179 nvarchar(100),@OrderSourceID_180 int,@CardNo_180 nvarchar(100),@OrderSourceID_181 int,@CardNo_181 nvarchar(100),@OrderSourceID_182 int,@CardNo_182 nvarchar(100),@OrderSourceID_183 int,@CardNo_183 nvarchar(100),@OrderSourceID_184 int,@CardNo_184 nvarchar(100),@OrderSourceID_185 int,@CardNo_185 nvarchar(100),@OrderSourceID_186 int,@CardNo_186 nvarchar(100),@OrderSourceID_187 int,@CardNo_187 nvarchar(100),@OrderSourceID_188 int,@CardNo_188 nvarchar(100),@OrderSourceID_189 int,@CardNo_189 nvarchar(100),@OrderSourceID_190 int,@CardNo_190 nvarchar(100),@OrderSourceID_191 int,@CardNo_191 nvarchar(100),@OrderSourceID_192 int,@CardNo_192 nvarchar(100),@OrderSourceID_193 int,@CardNo_193 nvarchar(100),@OrderSourceID_194 int,@CardNo_194 nvarchar(100),@OrderSourceID_195 int,@CardNo_195 nvarchar(100))update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_1 where OrderSourceID=@OrderSourceID_1 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_2 where OrderSourceID=@OrderSourceID_2 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_3 where OrderSourceID=@OrderSourceID_3 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_4 where OrderSourceID=@OrderSourceID_4 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_5 where OrderSourceID=@OrderSourceID_5 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_6 where OrderSourceID=@OrderSourceID_6 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_7 where OrderSourceID=@OrderSourceID_7 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_8 where OrderSourceID=@OrderSourceID_8 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_9 where OrderSourceID=@OrderSourceID_9 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_10 where OrderSourceID=@OrderSourceID_10 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_11 where OrderSourceID=@OrderSourceID_11 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_12 where OrderSourceID=@OrderSourceID_12 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_13 where OrderSourceID=@OrderSourceID_13 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_14 where OrderSourceID=@OrderSourceID_14 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_15 where OrderSourceID=@OrderSourceID_15 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_16 where OrderSourceID=@OrderSourceID_16 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_17 where OrderSourceID=@OrderSourceID_17 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_18 where OrderSourceID=@OrderSourceID_18 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_19 where OrderSourceID=@OrderSourceID_19 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_20 where OrderSourceID=@OrderSourceID_20 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_21 where OrderSourceID=@OrderSourceID_21 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_22 where OrderSourceID=@OrderSourceID_22 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_23 where OrderSourceID=@OrderSourceID_23 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_24 where OrderSourceID=@OrderSourceID_24 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_25 where OrderSourceID=@OrderSourceID_25 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_26 where OrderSourceID=@OrderSourceID_26 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_27 where OrderSourceID=@OrderSourceID_27 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_28 where OrderSourceID=@OrderSourceID_28 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_29 where OrderSourceID=@OrderSourceID_29 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_30 where OrderSourceID=@OrderSourceID_30 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_31 where OrderSourceID=@OrderSourceID_31 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_32 where OrderSourceID=@OrderSourceID_32 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_33 where OrderSourceID=@OrderSourceID_33 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_34 where OrderSourceID=@OrderSourceID_34 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_35 where OrderSourceID=@OrderSourceID_35 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_36 where OrderSourceID=@OrderSourceID_36 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_37 where OrderSourceID=@OrderSourceID_37 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_38 where OrderSourceID=@OrderSourceID_38 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_39 where OrderSourceID=@OrderSourceID_39 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_40 where OrderSourceID=@OrderSourceID_40 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_41 where OrderSourceID=@OrderSourceID_41 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_42 where OrderSourceID=@OrderSourceID_42 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_43 where OrderSourceID=@OrderSourceID_43 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_44 where OrderSourceID=@OrderSourceID_44 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_45 where OrderSourceID=@OrderSourceID_45 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_46 where OrderSourceID=@OrderSourceID_46 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_47 where OrderSourceID=@OrderSourceID_47 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_48 where OrderSourceID=@OrderSourceID_48 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_49 where OrderSourceID=@OrderSourceID_49 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_50 where OrderSourceID=@OrderSourceID_50 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_51 where OrderSourceID=@OrderSourceID_51 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_52 where OrderSourceID=@OrderSourceID_52 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_53 where OrderSourceID=@OrderSourceID_53 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_54 where OrderSourceID=@OrderSourceID_54 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_55 where OrderSourceID=@OrderSourceID_55 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_56 where OrderSourceID=@OrderSourceID_56 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_57 where OrderSourceID=@OrderSourceID_57 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_58 where OrderSourceID=@OrderSourceID_58 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_59 where OrderSourceID=@OrderSourceID_59 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_60 where OrderSourceID=@OrderSourceID_60 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_61 where OrderSourceID=@OrderSourceID_61 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_62 where OrderSourceID=@OrderSourceID_62 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_63 where OrderSourceID=@OrderSourceID_63 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_64 where OrderSourceID=@OrderSourceID_64 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_65 where OrderSourceID=@OrderSourceID_65 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_66 where OrderSourceID=@OrderSourceID_66 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_67 where OrderSourceID=@OrderSourceID_67 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_68 where OrderSourceID=@OrderSourceID_68 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_69 where OrderSourceID=@OrderSourceID_69 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_70 where OrderSourceID=@OrderSourceID_70 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_71 where OrderSourceID=@OrderSourceID_71 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_72 where OrderSourceID=@OrderSourceID_72 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_73 where OrderSourceID=@OrderSourceID_73 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_74 where OrderSourceID=@OrderSourceID_74 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_75 where OrderSourceID=@OrderSourceID_75 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_76 where OrderSourceID=@OrderSourceID_76 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_77 where OrderSourceID=@OrderSourceID_77 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_78 where OrderSourceID=@OrderSourceID_78 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_79 where OrderSourceID=@OrderSourceID_79 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_80 where OrderSourceID=@OrderSourceID_80 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_81 where OrderSourceID=@OrderSourceID_81 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_82 where OrderSourceID=@OrderSourceID_82 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_83 where OrderSourceID=@OrderSourceID_83 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_84 where OrderSourceID=@OrderSourceID_84 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_85 where OrderSourceID=@OrderSourceID_85 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_86 where OrderSourceID=@OrderSourceID_86 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_87 where OrderSourceID=@OrderSourceID_87 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_88 where OrderSourceID=@OrderSourceID_88 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_89 where OrderSourceID=@OrderSourceID_89 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_90 where OrderSourceID=@OrderSourceID_90 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_91 where OrderSourceID=@OrderSourceID_91 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_92 where OrderSourceID=@OrderSourceID_92 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_93 where OrderSourceID=@OrderSourceID_93 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_94 where OrderSourceID=@OrderSourceID_94 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_95 where OrderSourceID=@OrderSourceID_95 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_96 where OrderSourceID=@OrderSourceID_96 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_97 where OrderSourceID=@OrderSourceID_97 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_98 where OrderSourceID=@OrderSourceID_98 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_99 where OrderSourceID=@OrderSourceID_99 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_100 where OrderSourceID=@OrderSourceID_100 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_101 where OrderSourceID=@OrderSourceID_101 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_102 where OrderSourceID=@OrderSourceID_102 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_103 where OrderSourceID=@OrderSourceID_103 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_104 where OrderSourceID=@OrderSourceID_104 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_105 where OrderSourceID=@OrderSourceID_105 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_106 where OrderSourceID=@OrderSourceID_106 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_107 where OrderSourceID=@OrderSourceID_107 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_108 where OrderSourceID=@OrderSourceID_108 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_109 where OrderSourceID=@OrderSourceID_109 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_110 where OrderSourceID=@OrderSourceID_110 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_111 where OrderSourceID=@OrderSourceID_111 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_112 where OrderSourceID=@OrderSourceID_112 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_113 where OrderSourceID=@OrderSourceID_113 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_114 where OrderSourceID=@OrderSourceID_114 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_115 where OrderSourceID=@OrderSourceID_115 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_116 where OrderSourceID=@OrderSourceID_116 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_117 where OrderSourceID=@OrderSourceID_117 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_118 where OrderSourceID=@OrderSourceID_118 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_119 where OrderSourceID=@OrderSourceID_119 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_120 where OrderSourceID=@OrderSourceID_120 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_121 where OrderSourceID=@OrderSourceID_121 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_122 where OrderSourceID=@OrderSourceID_122 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_123 where OrderSourceID=@OrderSourceID_123 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_124 where OrderSourceID=@OrderSourceID_124 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_125 where OrderSourceID=@OrderSourceID_125 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_126 where OrderSourceID=@OrderSourceID_126 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_127 where OrderSourceID=@OrderSourceID_127 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_128 where OrderSourceID=@OrderSourceID_128 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_129 where OrderSourceID=@OrderSourceID_129 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_130 where OrderSourceID=@OrderSourceID_130 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_131 where OrderSourceID=@OrderSourceID_131 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_132 where OrderSourceID=@OrderSourceID_132 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_133 where OrderSourceID=@OrderSourceID_133 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_134 where OrderSourceID=@OrderSourceID_134 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_135 where OrderSourceID=@OrderSourceID_135 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_136 where OrderSourceID=@OrderSourceID_136 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_137 where OrderSourceID=@OrderSourceID_137 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_138 where OrderSourceID=@OrderSourceID_138 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_139 where OrderSourceID=@OrderSourceID_139 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_140 where OrderSourceID=@OrderSourceID_140 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_141 where OrderSourceID=@OrderSourceID_141 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_142 where OrderSourceID=@OrderSourceID_142 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_143 where OrderSourceID=@OrderSourceID_143 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_144 where OrderSourceID=@OrderSourceID_144 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_145 where OrderSourceID=@OrderSourceID_145 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_146 where OrderSourceID=@OrderSourceID_146 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_147 where OrderSourceID=@OrderSourceID_147 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_148 where OrderSourceID=@OrderSourceID_148 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_149 where OrderSourceID=@OrderSourceID_149 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_150 where OrderSourceID=@OrderSourceID_150 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_151 where OrderSourceID=@OrderSourceID_151 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_152 where OrderSourceID=@OrderSourceID_152 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_153 where OrderSourceID=@OrderSourceID_153 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_154 where OrderSourceID=@OrderSourceID_154 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_155 where OrderSourceID=@OrderSourceID_155 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_156 where OrderSourceID=@OrderSourceID_156 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_157 where OrderSourceID=@OrderSourceID_157 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_158 where OrderSourceID=@OrderSourceID_158 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_159 where OrderSourceID=@OrderSourceID_159 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_160 where OrderSourceID=@OrderSourceID_160 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_161 where OrderSourceID=@OrderSourceID_161 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_162 where OrderSourceID=@OrderSourceID_162 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_163 where OrderSourceID=@OrderSourceID_163 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_164 where OrderSourceID=@OrderSourceID_164 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_165 where OrderSourceID=@OrderSourceID_165 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_166 where OrderSourceID=@OrderSourceID_166 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_167 where OrderSourceID=@OrderSourceID_167 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_168 where OrderSourceID=@OrderSourceID_168 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_169 where OrderSourceID=@OrderSourceID_169 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_170 where OrderSourceID=@OrderSourceID_170 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_171 where OrderSourceID=@OrderSourceID_171 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_172 where OrderSourceID=@OrderSourceID_172 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_173 where OrderSourceID=@OrderSourceID_173 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_174 where OrderSourceID=@OrderSourceID_174 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_175 where OrderSourceID=@OrderSourceID_175 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_176 where OrderSourceID=@OrderSourceID_176 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_177 where OrderSourceID=@OrderSourceID_177 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_178 where OrderSourceID=@OrderSourceID_178 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_179 where OrderSourceID=@OrderSourceID_179 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_180 where OrderSourceID=@OrderSourceID_180 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_181 where OrderSourceID=@OrderSourceID_181 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_182 where OrderSourceID=@OrderSourceID_182 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_183 where OrderSourceID=@OrderSourceID_183 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_184 where OrderSourceID=@OrderSourceID_184 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_185 where OrderSourceID=@OrderSourceID_185 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_186 where OrderSourceID=@OrderSourceID_186 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_187 where OrderSourceID=@OrderSourceID_187 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_188 where OrderSourceID=@OrderSourceID_188 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_189 where OrderSourceID=@OrderSourceID_189 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_190 where OrderSourceID=@OrderSourceID_190 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_191 where OrderSourceID=@OrderSourceID_191 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_192 where OrderSourceID=@OrderSourceID_192 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_193 where OrderSourceID=@OrderSourceID_193 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_194 where OrderSourceID=@OrderSourceID_194 ;update [RB_Amazon_ListFinancialEventGroups] set [CardNo] = @CardNo_195 where OrderSourceID=@OrderSourceID_195 ;[结果]
[期望]
加上 and CustomerID 条件