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