pivot dynamic column

Question

This is table im using

my task is to get course id values as fields dynamically that means,i dont need to mention courseid values but i should get values as fields with registerno and take as max markes for each register no and courseid values

 

 

 

 

 

 

 

 

 

 

 

 

 

CREATE TABLE [dbo].[tblResultMarkDetails](

[RId] [int] IDENTITY(1,1) NOT NULL,

[RegisterNo] [char](12) NOT NULL,

[DummyNo] [varchar](20) NULL,

[CourseID] [char](9) NOT NULL,

[Marks] [numeric](5, 2) NULL,

[GradeCode] [char](3) NULL,

[AppStatus] [char](1) NULL,

[Remark] [varchar](150) NULL,

[ASessionCode] [char](2) NOT NULL,

[ExamScheduleID] [char](6) NOT NULL,

[BatchId] [char](12) NOT NULL,

[ResultStatus] [char](4) NULL,

[InternalID] [char](3) NOT NULL,

[ExamType] [char](2) NOT NULL,

[Attempt] [bigint] NULL,

[YearPassed] [char](10) NULL,

[AttStatus] [char](1) NULL,

[PublishedOn] [datetime] NULL,

[PublishFlag] [char](1) NULL,

[PRCStatus] [char](1) NULL,

[CreatedDate] [datetime] NOT NULL,

[CreatedBy] [varchar](30) NULL,

[ModifiedDate] [datetime] NULL,

[ModifiedBy] [varchar](30) NULL,

[Mode] [varchar](15) NULL,

[CreditPoint] [numeric](5, 2) NULL,

[UFM] [char](1) NULL,

[PrivilegeCode] [varchar](9) NULL,

CONSTRAINT [PK_tblResultMarkDetails1] PRIMARY KEY CLUSTERED

(

[RId] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]

) ON [PRIMARY]