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

1. Create view AttendViewRecords
   
2. AS
   
3. 
   
4. 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,
   
5. DATENAME(WEEKDAY, B.sign_time) AS 'Week',day(sign_time) as day,
   
6. convert(char(10),sign_time,111) as date,convert(char(10),sign_time,108) as time
   
7. ,B.clock_id
   
8. 
   
9. FROM Employee A
   
10. left join TimeRecords B on A.emp_id = B.emp_id
    
11. left join Departs C on C.depart_id=A.depart_id