2018-05-07

2018 年 5 月 7 日2018 年 5 月 7 日 by 沧海之树 In 工作

insert into UpdateManage
select * from bh.dbo.UpdateManage

导完成后执行

with t
as
(
select a.ID, a.Date,a.RegisterDate, b.ItemID,b.ItemTypeID,
a.HandleBy,c.TopCategoryID,c.CategoryID,d.CustomerID,
a.DoctorID,a.FirstAssistantID,a.TwoAssistantID,a.AnesthetistID,a.UseDeviceID,
a.KindofSicknessID,a.Excutetimes,a.ExcuteQuantity,b.Amount as AmountA,b.Amount as AmountB,
0 as PrepaymentAmount,0 as YearCardAmount,b.Amount as AmountC,e.SceneEmployee
from ExcuteInfo a
inner join CustomerConsumptionDetails b on a.CertainProjectID=b.ID
inner join ItemInfo c on c.ID=b.ItemID
inner join CustomerConsumptionInfo d on d.ExcutionNumber=b.ExcutionNumber
inner join CustomerBaseInfo e on d.CustomerID=e.ID
)
insert into ExcuteRecordTotal(ExcuteInfoID,Date,RegisterDate,ItemID,ItemTypeID,
Registerby,TopCategoryID,CategoryID,CustomerID,
DoctorID,FirstAssistantID,SecondAssistantID,AnesthetistID,UseDeviceID,
KindofSicknessID,Excutetimes,ExcuteQuantity,TotalPR,CashAmount,
PrepaymentAmount,YearCardAmount,TotalRealMoney,SceneEmployee,
Status,YearCardPercent,YearCardRealAmount,ArrearsAmount,MoneyCardCashAmount,
MoneyCardHandselAmount,MoneyCardTotalAmount,MoneyCardPercent,MoneyCardRealAmount,IntegrationAmount,
InsteadMoneyAmount,TotalOther
) select ID,Date,RegisterDate,ItemID,ItemTypeID,
HandleBy,TopCategoryID,CategoryID,CustomerID,
DoctorID,FirstAssistantID,TwoAssistantID,AnesthetistID,UseDeviceID,
KindofSicknessID,Excutetimes,ExcuteQuantity,AmountA,AmountB,
PrepaymentAmount,0,AmountC,SceneEmployee,
0,0,0,0,0,
0,0,0,0,0,
0,0 from t