Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.
CREATE FUNCTION dbo.TaskStatusPivot Declare @strSQL varchar(max) DECLARE @cols varchar(2000) RETURNS TABLE AS RETURN SELECT @cols = STUFF(( SELECT DISTINCT TOP 100 PERCENT '],[' + task FROM WeekTaskStatus ORDER BY '],[' + task FOR XML PATH('') ), 1, 2, '') + ']' set @strSQL = 'select WeekEnd, ' + @cols + ' from ( select WeekEnd, Task, TaskStatus from WeekTaskStatus) o pivot (Max(TaskStatus) for Task in (' + @cols + ')) p' exec(@strSQL) end
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
17 Experts available now in Live!