set @query = 'SELECT * from
(select student_name,roll_no,standard,section,subjects,cast(mark as int)as mark from mark_entry
WHERE StudentName = ''StudentName'') x
pivot
(sum(mark) for subjects in (' + @cols + '))p
Where student_name =''StudentName'''