Create a new table with pivoted data from the original table

DeclareNewPivotFromTable.sql

declare
    @cols nvarchar(max),
       @sele nvarchar(max),
    @stmt nvarchar(max)

select @cols = isnull(@cols + ', ', '') + '[' + T.ReleasedVersion + ']' from (select distinct ReleasedVersion from DriversAndLibraries Where ReleasedVersion <> '') as T
select @sele = isnull(@sele + ', ', '') + 'max([' + T.ReleasedVersion + ']) AS ' + '[' + T.ReleasedVersion + ']'  from (select distinct ReleasedVersion from DriversAndLibraries Where ReleasedVersion <> '') as T
PRINT @sele

select @stmt = '
  WITH Pivoted AS
  (
  select *  from DriversAndLibraries a
  pivot (
         max(FileVersion) for ReleasedVersion in (' + @cols + ')
    ) as max
  )
  SELECT FileName, ' + @sele + '  into SummaryDriversTable from Pivoted
  group by FileName
  Order by Pivoted.FileName
'

PRINT @stmt
exec sp_executesql @stmt