sql查询员工入职多少天_sql 查询四舍五入_sql怎么四舍五入(11)

User_Group_Name IN('Technician','Engineer') AND UDAR。User_Record_No = TSD。User_Record_No AND UDAR。Division_Record_No IN(1) SELECT DISTINCT A。User_Record_No, B。Staff_No, B。Full_Name,B。Job_Title, SUM(working_hour) AS Working_Hours,SUM(ot) AS OT_HOURS, C。Period_Start_Date,C。Period_End_Date INTO #temp2 FROM Time_Sheet_Details A INNER JOIN User_Master B ON B。User_Record_No= A。User_Record_No INNER JOIN #temp C ON C。Time_Sheet_Dtl_Record_No = A。Time_Sheet_Dtl_Record_No GROUP BY A。User_Record_No, B。Staff_No,B。

Full_Name,B。Job_Title, C。Period_Start_Date,C。Period_End_Date HING COUNT(*) = DATEDIFF(d,C。Period_Start_Date,C。Period_End_Date)+1 Select A。User_Record_No,A。Staff_No,A。Full_Name,A。Job_Title ,A。Working_Hours,A。OT_HOURS,A。Period_Start_Date,A。Period_End_Date ,DM。Division_Code INTO #temp3 FROM #temp2 AS A INNER JOIN User_Data_Access_Right UDAR ON UDAR。User_Record_No = A。User_Record_No INNER JOIN Division_Master DM ON DM。Division_Record_No = UDAR。Division_Record_No SELECT * From #temp3 order by 1,7,8; Select Count(Distinct User_Record_No+Period_Start_Date+Period_End_Date) From #temp3 DROP TABLE #temp ,#temp2,#temp3

:)

Top

收藏，^_^

Top

cpp2017(长安不见使人愁)这么长一句，少见，能否介绍介绍它的功力？^_^

SELECT DISTINCT TSD。Time_Sheet_Dtl_Record_No,TSD。User_Record_No,TP。Period_Start_Date ,TP。Period_End_Date INTO #temp FROM Time_Sheet_Details TSD, Time_Sheet_Period TP ,User_Group_User_Relationship UGUR,User_Group_Master UGM ,User_Data_Access_Right UDAR WHERE TSD。status ='TS_WFMGRA' AND DATEDIFF(dd,TP。period_start_date,TSD。work_Date)>=0 AND DATEDIFF(dd,TP。period_end_date,TSD。work_Date)<=0 AND UGUR。User_Record_No = TSD。User_Record_No AND UGM。User_Group_Record_No=UGUR。User_Group_Record_No AND UGM。

本文来自电脑杂谈，转载请注明本文网址：
https://www.pc-fly.com/a/ruanjian/article-30385-11.html