Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.
ALTER PROCEDURE dbo.TaskStatusPivot as Declare @strSQL varchar(max) DECLARE @cols varchar(2000) SELECT @cols = STUFF(( SELECT DISTINCT TOP 100 PERCENT '],[' + task FROM WeekTaskStatus ORDER BY '],[' + task FOR XML PATH('') ), 1, 2, '') + ']' set @strSQL = 'select CONVERT(varchar,WeekEnd,101) as WeekEnding, ' + @cols + ' from ( select WeekEnd, Task, TaskStatus from WeekTaskStatus) o pivot (Max(TaskStatus) for Task in (' + @cols + ')) p' exec(@strSQL)
|SQL Server 2008 R2 - Execution Plan||3||30|
|why do we need to add dollar sign on asp datasource tag <% $ ConnectionStirngs : Con %>||1||43|
|Calling stored proc in EDMX||11||19|
|Pivot not using aggregate yield error||3||20|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
20 Experts available now in Live!