创建Attendviewrecords视图，为C#RDLC报表矩阵报表做准备

最新推荐文章于 2021-01-07 19:34:44 发布

漫步技术小栈

最新推荐文章于 2021-01-07 19:34:44 发布

阅读量156

点赞数

分类专栏： C#

本文链接：https://blog.csdn.net/wintershang/article/details/89205217

版权

C# 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

Create view AttendViewRecords
AS

SELECT top 100 Id=ROW_NUMBER() over(order by emp_id),A.emp_id,A.card_id,A.emp_fname,B.sign_time,C.depart_name,
DATENAME(WEEKDAY, B.sign_time) AS 'Week',day(sign_time) as day,
convert(char(10),sign_time,111) as date,convert(char(10),sign_time,108) as time
,B.clock_id

FROM Employee A
left join TimeRecords B on A.emp_id = B.emp_id
left join Departs C on C.depart_id=A.depart_id