2018-04-24

by 沧海之树 In 工作

--/****** Script for SelectTopNRows command from SSMS ******/
--SELECT TOP 1000 [ID]
-- ,[Original]
-- ,[Now]
-- FROM [bh20180420].[dbo].[EmployeeID]

-- update Employee set PositionID='12',WorkStatus='在职' where ID in(select Now from EmployeeID where Original in ('2031','2069','2070','2802','2805','2806','2808','2809','2810','8819'))

-- update Employee set PositionID='10',WorkStatus='在职' where ID in(select Now from EmployeeID where Original in ('1220','1283','3001','3002','3007','3102','3203','3218','3219','3220','3223','3225','3568','3997','3999'))

-- update Employee set PositionID='61',WorkStatus='在职' where ID in(select Now from EmployeeID where Original in ('1100','1155','1156','1157','1158','1159'))

-- update Employee set PositionID='22',WorkStatus='在职' where ID in(select Now from EmployeeID where Original in ('2022','2901'))

-- update Employee set PositionID='47',WorkStatus='在职' where ID in(select Now from EmployeeID where Original in ('1007','1013','1016','1020','1030','1266','1268','1271','1279','1308','1621','1830','1831','1835'))

-- update Employee set PositionID='04',WorkStatus='在职' where ID in(select Now from EmployeeID where Original in ('1001','1015','1101','1826','1836','1845','1850','1851','9001'))

-- update Employee set PositionID='23',WorkStatus='在职' where ID in(select Now from EmployeeID where Original in ('1106','1116','1117','1118','1123','1132','1133','1134','1135','1605'))

-- update Employee set PositionID='06',WorkStatus='在职' where ID in(select Now from EmployeeID where Original in ('1601','1602','1609','1613','1620','1623','1624','1625','1626','1628'))

-- update Employee set PositionID='01',WorkStatus='在职' where ID in(select Now from EmployeeID where Original in ('1284','1285','1286','1287'))

-- update Employee set PositionID='07',WorkStatus='在职' where ID in(select Now from EmployeeID where Original in ('8003','8010'))

-- update Employee set PositionID='60',WorkStatus='在职' where ID in(select Now from EmployeeID where Original in ('1503','1619','1622','6603','6604','6606','6607','6608','6609','6610','6611','6612'))

-- update Employee set PositionID='39',WorkStatus='在职' where ID in(select Now from EmployeeID where Original in ('1265','88001','88002','88005','88010','88011','88015','88019','88021','88023','88028','88029','88030','88032','88033','88037','88040','88068','88069','88070','88071','88072','88073','88074'))

-- select * from Employee

-- select * from PositionInfo

-- --update PositionInfo set ScontoPower=1

-- select * from Department

-- select * from H_Employee where sDept='001004' and sStau='正常'

-- select * from H_Employee where sName='金楠楠L'

-- select * from H_Employee where sDept='001005' and sStau='正常'

-- select * from H_Employee where sDept='001007' and sStau='正常'

-- select * from H_Employee where sDept='001014' and sStau='正常'

-- select * from H_Employee where sDept='001015' and sStau='正常'

-- select * from H_Employee where sDept='001015001' and sStau='正常'

-- select * from H_Employee where sDept='001015002' and sStau='正常'

-- select * from H_Employee where sDept='001015004' and sStau='正常'

-- select * from H_Employee where sDept='001015005' and sStau='正常'

-- select * from H_Employee where sDept='001018003' and sStau='正常'

-- select * from H_Employee where sDept='001020' and sStau='正常'

-- select * from H_Employee where sDept='001021' and sStau='正常'

select * from GoodsInfo
FactoryID

select * from GoodsInfoID

select * from GoodsFactoryInfo ID

select * from GoodsFactoryInfo
select * from GoodsInfo

select * from GoodsFactoryInfo

select * from GoodsFactoryInfo
select * from GoodsInfo

select * from GoodsFactoryInfo

select * from MedicineFactoryInfo

--update GoodsFactoryInfo set ID=replace(ID,'f','0')

select dDT from H_FrontSK_Project where dDT>'2018-04-20 00:00:00.000'

select count(*) from CustomerConsumptionDetails;
select count(*) from CustomerConsumptionDetailsID;

select max(Original) from CustomerConsumptionDetailsID;

select * from H_FrontSK_Paylst;

select * from CustomerConsumptionDetails

160531181551158902

select * from YUN_HIS20180420.dbo.H_FrontSK where dDT>'2016-05-31 00:00:00.000' and dDT<'2016-06-01 00:00:00.000';

select Original from bh20180420.dbo.CustomerConsumptionDetailsID where Original like '160531%';

select Keyid from YUN_HIS20180420.dbo.H_FrontSK_Project where Keyid like '160531%';

select * from YUN_HIS20180420.dbo.H_FrontSK_Project where Keyid ='160531094942498271'

select Original from bh20180420.dbo.MorHKeepAccountsDetailsID where Original like '160531%';

select * from YUN_HIS20180420.dbo.H_FrontSK_Project where Keyid like '160531%' and Keyid not in (select Original from bh20180420.dbo.CustomerConsumptionDetailsID where Original like '160531%' union select Original from bh20180420.dbo.MorHKeepAccountsDetailsID where Original like '160531%')

select count(*) from bh20180420.dbo.CustomerConsumptionDetailsID where Original like '160531%';

select count(*) from bh20180420.dbo.CustomerConsumptionInfoID where Original like '160531%';

select * from CustomerConsumptionDetails

select * from CustomerConsumptionInfoID

select * from CustomerConsumptionDetailsID