Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!
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)
|Replace < with <||14||54|
|Pagebreak issue while printing the aspx page||3||11|
|create insert script based on records in a table||4||11|
|How to have a gridview column with multiple items in a column row.||2||7|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
10 Experts available now in Live!