Pivot query in SQL Server

Here maybe help you. Dynamic sql query

 CREATE TABLE TrackingTbl ( TrackingNo int, SKUID int, SKUName varchar(50), TotalSKUID int, IsAvaiable int ) INSERT INTO TrackingTbl VALUES (1234,1,'Red',2,2) INSERT INTO TrackingTbl VALUES (1234,2,'White',2,1) INSERT INTO TrackingTbl VALUES (1234,3,'Blue',2,0) INSERT INTO TrackingTbl VALUES (1234,4,'Yellow',2,2) INSERT INTO TrackingTbl VALUES (3456,1,'Red',3,3) INSERT INTO TrackingTbl VALUES (3456,2,'White',3,2) INSERT INTO TrackingTbl VALUES (3456,3,'Blue',3,1) INSERT INTO TrackingTbl VALUES (3456,4,'Yellow',3,0) DECLARE @Columns varchar(200) SET @Columns = Stuff((SELECT concat(', [',td.SKUName,']') FROM (select DISTINCT tt.SKUName FROM TrackingTbl tt ) td FOR XML PATH ('')) ,1,1,'') DECLARE @Query nvarchar(max) = CONCAT( 'SELECT TrackingNo,TotalSKUID,',@Columns, ' FROM ( SELECT tt.IsAvaiable, tt.SKUName ,tt.TrackingNo, tt.TotalSKUID FROM TrackingTbl tt ) sc PIVOT ( sum(IsAvaiable) FOR SKuName IN (',@Columns,' ) ) pvt') exec sp_executesql @Query DROP TABLE dbo.TrackingTbl 

Try this using MAX ()

 ;with cte as ( SELECT P.Trackingno,PA.SKUId,SC.SKUName,count(PA.SKUId) as TotalSKUId ,sum(case when PA.IsAvailable = 1 then 1 else 0 end) AS IsAvailable FROM ADMIN.posavailability PA LEFT OUTER JOIN Admin.SKUCreation SC ON SC.TCID=PA.Skuid LEFT OUTER JOIN Admin.POSVisitDetails PD on PD.VisitId=PA.VisitID LEFT OUTER JOIN Admin.POS P ON P.TrackingNo=PD.TrackingNo WHERE PA.VisitId in (SELECT visitid FROM Admin.POSVisitDetails PD WHERE PD.month=2 and PD.year=2017) and PA.IsActive=1 GROUP BY P.Trackingno,PA.SKUId,SC.SKUName,PD.Month,PD.year ORDER BY P.Trackingno ) select trackingno,totalskuid,max(case when skuname='Red' then isavailable else '' end) Red, max(case when skuname='White' then isavailable else '' end) White, max(case when skuname='Blue' then isavailable else '' end) Blue, max(case when skuname='Yellow' then isavailable else '' end) Yellow from cte group by trackingno,totalskuid