--Declare necessary variables
DECLARE   @SQLQuery AS NVARCHAR(MAX)
DECLARE   @PivotColumns AS NVARCHAR(MAX)
 
--Get unique values of pivot column  
SELECT   @PivotColumns= COALESCE(@PivotColumns + ',','') + QUOTENAME(TARIH)
FROM (SELECT DISTINCT TARIH FROM [dbo].BM_201_IK_SHAREKETLER) AS PivotExample
 
SELECT   @PivotColumns
 
--Create the dynamic query with all the values for 
--pivot column at runtime
SET   @SQLQuery = 
    N'SELECT ADSOYAD,PROJE, ' +   @PivotColumns + '
    FROM [dbo].[BM_201_IK_SHAREKETLER] 
    PIVOT( COUNT(SAAT) 
          FOR TARIH IN (' + @PivotColumns + ')) AS P'
 
SELECT   @SQLQuery
--Execute dynamic query
EXEC sp_executesql @SQLQuery