8 Aug 2018 by Santosh kumar Pithani
CREATE TABLE #temp ( CANDIDATEID int, SUB varchar(500), UBID INT,MARK INT,TOTAL_QUESTIONS int) INSERT INTO #TEMP values (41,'IT',1,6,14), (41,'MATH',2,3,10), (41,'ENGLISH READING',3,4,10), (41,'ENGLISH GRAMMER',4,3,15), (42,'INFORMATION TECHNOLOGY',1,3,14), ...