Temporary table and pivoting

declare @table table
(
    Roll int,
    CT int,
    Marks decimal(8,2)
)
declare @string nvarchar(max)
declare @tblname nvarchar(100)
set @tblname=’CT_Marks’
set @string=’create table #’ + @tblname + ‘ (‘
insert into @table
(
    Roll,
    CT,
    Marks
)
SELECT     dbo.T_Term_Class_Test.StudentId, dbo.T_Term_Class_Test_Defination.ClassTestNumber, dbo.T_Term_Class_Test.ConvertedMarks
FROM         dbo.T_Term_Class_Test INNER JOIN dbo.T_Term_Class_Test_Defination ON dbo.T_Term_Class_Test.CTId = dbo.T_Term_Class_Test_Defination.CTId

                     
SELECT *
FROM @table
PIVOT
(
  SUM(Marks)
  FOR [CT] IN ([1],[2],[3],[4])
)
AS p

Advertisements