declare cur_Brith cursor scroll for select substring(curcode,2,2)%4 as Team,'' as MO_Code, '' as HK_MO_Code,a.FDate as TFDate, a.Style_NO as Style_NO , a.Color AS Color,a.Customer as Customer,a.Group_NO as Group_No,CurCode as CurCode,LongNameUp as LongNameUp,PageNo as PageNo,Re as Re --这一行 ,RS as RS,isQj AS isQj,G_kgts as G_kgts,isKG AS isKG,isCW as isCW,isZG AS isZG , RS_T AS RS_T,isQj_T AS isQj_T, G_kgts_T AS G_kgts_T,isKG_T AS isKG_T, isCW_T AS isCW_T, isZG_T AS isZG_T , RS_A AS RS_A, isQj_A AS isQj_A, G_kgts_A AS G_kgts_A,isKG_A as isKG_A,isCW_A as isCW_A,isZG_A AS isZG_A from T_SectionMO a和 FETCH NEXT from cur_Brith into @Team,@MO_Code,@HK_MO_Code,@TFDate,@Style_NO, @Color,@Customer,@Group_No,@LongNameUp,@PageNo,@Re, --这一行 @RS,@isQj,@G_kgts,@isKG,@isCW,@isZG,@RS_T,@isQj_T,@G_kgts_T,@isKG_T,@isCW_T,@isZG_T,@RS_A,@isQj_A,@G_kgts_A,@isKG_A,@isCW_A,@isZG_A 里面的字段不对应
declare cur_Brith cursor scroll for
select substring(curcode,2,2)%4 as Team,'' as MO_Code, '' as HK_MO_Code,a.FDate as TFDate, a.Style_NO as Style_NO ,
a.Color AS Color,a.Customer as Customer,a.Group_NO as Group_No,CurCode as CurCode,LongNameUp as LongNameUp,PageNo as PageNo,Re as Re --这一行
,RS as RS,isQj AS isQj,G_kgts as G_kgts,isKG AS isKG,isCW as isCW,isZG AS isZG
, RS_T AS RS_T,isQj_T AS isQj_T, G_kgts_T AS G_kgts_T,isKG_T AS isKG_T, isCW_T AS isCW_T, isZG_T AS isZG_T
, RS_A AS RS_A, isQj_A AS isQj_A, G_kgts_A AS G_kgts_A,isKG_A as isKG_A,isCW_A as isCW_A,isZG_A AS isZG_A from T_SectionMO a和
FETCH NEXT from cur_Brith into @Team,@MO_Code,@HK_MO_Code,@TFDate,@Style_NO,
@Color,@Customer,@Group_No,@LongNameUp,@PageNo,@Re, --这一行
@RS,@isQj,@G_kgts,@isKG,@isCW,@isZG,@RS_T,@isQj_T,@G_kgts_T,@isKG_T,@isCW_T,@isZG_T,@RS_A,@isQj_A,@G_kgts_A,@isKG_A,@isCW_A,@isZG_A 里面的字段不对应