PIVOT :Transform data from rows to column

if OBJECT_ID('tempdb..##TBL_TEMP') IS NOT NULL
DROP TABLE ##TBL_TEMP


declare @sqlquery as nvarchar(max)

declare @pivotcolums as nvarchar(max)

select  @pivotcolums = coalesce(@pivotcolums +',','') + QUOTENAME(Itemcode)
from
(
select distinct itemcode from OrderSales
) as result


SELECT @pivotcolums

set @sqlquery = N'SELECT ' + @pivotcolums +'
into ##TBL_TEMP
FROM [dbo].[OrderSales]
PIVOT (SUM(amount)
FOR ITEMCODE IN ('+ @pivotcolums+')) as Q'


--SELECT @sqlquery

exec sp_executesql @sqlquery

select * from ##TBL_TEMP