สอบถามการ Select ข้อมูล SQL แบบ pivot โดยไม่ทำการฟิกค่าคอลัมน์คะ

	DECLARE @Query AS NVARCHAR (MAX) ,@ColumnName AS NVARCHAR (MAX) 
	SELECT @ColumnName = ISNULL(@ColumnName + ',', '') + QUOTENAME(Code)
	FROM (
		SELECT DISTINCT Code
		FROM dbo.TABLE
		WHERE Status = 1
	) AS Branch
	ORDER BY Code ASC

	SET @Query = N'
	SELECT Code
	, Name
	, ' + @ColumnName + '
	, Total
	FROM (
	-----
	-----
	-----
	) AS j PIVOT(SUM(Qty) FOR Branch IN (' + @ColumnName + ')) AS Branch '

	EXEC sp_executesql @Query