34,837
社区成员




1. select
2. d.DeclareID,
3. InfoSN,
4. b.ItmeName,
5. e.ItemNameEN as ApplicationType,
6. ContractStartTime as ItemStartTime,
7. RemitType,
8. Remiter as Type1Remiter,
9. Degree as Type1Degree,
9. BargainCharge as Type1BargainCharge,
9. RemitCharge as Type1RemitCharge,
9. RemitTime as Type1RemitTime,
9. Credence as Type1Credence
9. INTO #T1
9. from
9. Notes_DeclareItemInfo a,
9. Notes_DeclareSub_Project b,
9. Notes_ProjectAccountInfor c,
9. Notes_Item_RemitInfo d,
9. TB_Dictionary e
9. where
9. a.InfoSN=b.ReviewSN and
9. c.ProjectID=d.DeclareID and
9. b.ProjectID=c.ParentID and
9. e.DictInfoID=a.ApplicationType
9. order by d.DeclareID,RemitType,Degree
1. select
2. d.DeclareID,
3. InfoSN,
4. b.ItmeName,
5. e.ItemNameEN as ApplicationType,
6. ContractStartTime as ItemStartTime,
7. RemitType,
8. Remiter as Type1Remiter,
9. Degree as Type1Degree,
9. BargainCharge as Type1BargainCharge,
9. RemitCharge as Type1RemitCharge,
9. RemitTime as Type1RemitTime,
9. Credence as Type1Credence
9. INTO #T1
9. from
9. Notes_DeclareItemInfo a,
9. Notes_DeclareSub_Project b,
9. Notes_ProjectAccountInfor c,
9. Notes_Item_RemitInfo d,
9. TB_Dictionary e
9. where
9. a.InfoSN=b.ReviewSN and
9. c.ProjectID=d.DeclareID and
9. b.ProjectID=c.ParentID and
9. e.DictInfoID=a.ApplicationType
9. order by d.DeclareID,RemitType,Degree