You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
20 lines
692 B
20 lines
692 B
|
|
INSERT INTO [Dict_ReportItem]
|
|
( [RptItemName], [Seq], [FID], [IsAddSummary])
|
|
SELECT FeeItemName AS RptItemName,Seq=1,A.ID AS FID,IsAddSummary=1 FROM vi_FeeItem A
|
|
LEFT JOIN Dict_ReportItem B ON A.ID=B.FID
|
|
WHERE B.ID IS NULL AND A.ItemClass='普通' AND A.IsHide=0
|
|
|
|
|
|
|
|
SELECT * FROM vi_HisFeeItem WHERE ClassName LIKE '%迪安%'
|
|
|
|
SELECT FeeItemName AS RptItemName,Seq=1,A.ID AS FID,IsAddSummary=1 FROM vi_FeeItem A
|
|
LEFT JOIN Dict_ReportItem B ON A.ID=B.FID
|
|
LEFT JOIN vi_HisFeeItem C ON
|
|
WHERE B.ID IS NULL AND A.ItemClass='普通' AND A.IsHide=0
|
|
|
|
|
|
SELECT * FROM Enrollment_FeeItem WHERE EID=80668
|
|
|
|
UPDATE [Enrollment_FeeItem] SET ItemClass='普通' where [ID] = 1043064 |