--Creating table

Create Table Ex
(ID	int,
 SN int )


--Inserting Sample Data
 
Insert into Ex
Select 178,	718218
union ALL
Select 178,	718221	
union ALL
Select 178,	718217	
union ALL
Select 178,	718220	
union ALL
Select 178,	718223	
union ALL
Select 178,	718224	
union ALL
Select 178,	718226	
union ALL
Select 178,	718225	
union ALL
Select 178,	718219	
union ALL
Select 178,	718228
union ALL	
Select 178,	718227	
union ALL
Select 178,	718229


--Dynamic Pivot

Declare @cols varchar(max), @sql Varchar(max)
Select @cols = Coalesce(@cols + ', ', '') +QUOTENAME(rn) From
	(Select *, 'SN' + Cast(ROW_NUMBER() Over (Order By (Select NULL) ) AS Varchar(30) ) As rn From Ex) As a
Set @sql = 'Select Id, '+@cols+' From 
				(Select *, ''SN'' + Cast(ROW_NUMBER() Over (Order By (Select NULL) ) AS Varchar(30) ) As rn From Ex) As a
			Pivot
			(Max(SN) For rn IN ('+@cols+')) As pvt'
Execute (@sql)