SQL Schedule日历

本文介绍了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