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.
53 lines
1.3 KiB
53 lines
1.3 KiB
SELECT TOP (1000) [ID]
|
|
,[FeeItemCode]
|
|
,[FeeItemName]
|
|
,[SpellCode]
|
|
,[Price]
|
|
,[DeptCode]
|
|
,[DeptName]
|
|
,[UnitName]
|
|
,[ItemClass]
|
|
,[Unit]
|
|
,[KeyNo]
|
|
,[IsReserve]
|
|
FROM [peisdb].[dbo].[Dict_PeisFeeItem]
|
|
|
|
|
|
SELECT * FROM
|
|
select * from PEIS.DBO.FEEITEM WHERE HISCheckCode IS NULL
|
|
|
|
select * from vi_HisFeeItem where FeeItemCode in (
|
|
SELECT HISCheckCode FROM PEIS.DBO.ExamPack A
|
|
LEFT JOIN PEIS.DBO.ExamPackFeeItem B ON A.ID=B.ExamPackId
|
|
LEFT JOIN PEIS.dbo.FeeItem C ON B.FeeItemId=C.ID
|
|
WHERE A.NAME='AĚײͣ¨ÄĐŁŠ' and HISCheckCode<>'') and
|
|
DeptCode in (
|
|
'3204',
|
|
'3203',
|
|
'3202',
|
|
'3201',
|
|
'3101',
|
|
'3001',
|
|
'2601',
|
|
'2101',
|
|
'1102',
|
|
'0501',
|
|
'0307')
|
|
|
|
|
|
SELECT * FROM [dbo].[Dict_PackToFeeItem]
|
|
SELECT * FROM PEIS. [dbo].[ExamPackFeeItem]
|
|
|
|
|
|
TRUNCATE TABLE Dict_PackToFeeItem
|
|
SET IDENTITY_INSERT [dbo].[Dict_PackToFeeItem] OFF
|
|
|
|
INSERT INTO [Dict_PackToFeeItem]
|
|
([ID], [PID], [FID], [Seq], [CreateTime], [CreatorCode], [Creator])
|
|
SELECT[Id], [ExamPackId] AS PID, [FeeItemId] AS FID, [SortNo] AS SEQ,CreateTime= '2024-05-24', CreatorCode='0513',Creator= 'ŐÔ´äťŘ'
|
|
FROM PEIS. [dbo].[ExamPackFeeItem] WHERE STOPDATE IS NULL
|
|
|
|
SELECT * FROM PEIS. [dbo].[ExamPackFeeItem] WHERE ExamPackId=1
|
|
|
|
|
|
select * from dict_feeitem
|
|
|