本文介绍了SQL Schedule日历的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
是否可以在SQL上创建用于计划IT日历的查询? 我有此表:
It's possible to create on SQL, a query to schedule my IT Calendar? I have this table:
IT Technician | Date John | 21-09-2014 Mark | 20-09-2014要控制我的IT计划,我需要一份我的IT人员的计划清单。
To control my IT Schedule I want a list of the schedule of my IT Guys.
19-09-2014 20-09-2014 21-09-2014 John Free Free Occupied Mark Free Occupied Free Manuel Free Free Free Ricardo Free Free Free可以在SQL查询上使用吗?
It's possible on a SQL Query?
预先感谢您, TiagoJanuário
Thank you in advance, Tiago Januário
推荐答案您需要使用PIVOT进行动态SQL
you need to dynamic SQL using PIVOT
DECLARE @cols nvarchar(max) DECLARE @query nvarchar(max) set @cols = ( STUFF( ( select ',[' + Date + ']' from Table1 for xml path ('')),1,1,'')) set @query = 'select '+ @cols +' FROM (select * from Table1 )T pivot ( max([IT Technician]) for Date in ( ' + @cols + ') )p' exec sp_executesql @query更多推荐
SQL Schedule日历
发布评论