SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[usp_PIVOT_Seats] AS BEGIN SET NOCOUNT ON; DECLARE @cols NVARCHAR(MAX), @stmt NVARCHAR(MAX) SELECT @cols = ISNULL(@cols + ', ', '') + '[' + T.showdateformat + ']' FROM (SELECT DISTINCT showdateformat FROM vw_Pivot_Seat_ALL) AS T SELECT @stmt = ' SELECT * FROM vw_Pivot_Seat_ALL AS T pivot (SUM(T.Qty) FOR T.showdateformat IN (' + @cols + ')) AS P' END EXEC sp_executesql @STMT=@STMT
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)