Try this - DECLARE @Table AS TABLE ( PERSON varchar(50), FUN varchar(50), JOBNAME varchar(50), QUESTION varchar(50), MINUTES INT )INSERT INTO @Table SELECT 'admin','C','test','Q13a','0'UNION ALLSELECT 'admin','C','test','Q13a','1'UNION ALLSELECT 'admin','C','test','Q13a','15'UNION ALLSELECT 'admin','C','test','Q13b','2'UNION ALLSELECT 'admin','C','test','Q13b','3'UNION ALLSELECT 'admin','C','test','Q4b','1'UNION ALLSELECT 'admin','C','test','Qs7','2'UNION ALLSELECT 'admin','C','test','Qs7','0'UNION ALLSELECT 'super','C','test123','Q13','3'UNION ALLSELECT 'super','V','test','Qs7','1'SELECT PERSON, FUN, JOBNAME, QUESTION, MINUTES, CASE WHEN RowNo = 1 THEN [TOTAL MINUTES] ELSE '' END [TOTAL MINUTES] FROM ( SELECT A.PERSON, A.FUN, A.JOBNAME, A.QUESTION, A.MINUTES, CONVERT( VARCHAR(20), B.[TOTAL MINUTES]) [TOTAL MINUTES], ROW_NUMBER() OVER( PARTITION BY A.PERSON, A.FUN, A.QUESTION ORDER BY MINUTES DESC ) RowNo FROM @Table A INNER JOIN ( SELECT PERSON, FUN, QUESTION, SUM(MINUTES) [TOTAL MINUTES] FROM @Table GROUP BY PERSON, FUN, QUESTION ) B ON A.PERSON = B.PERSON AND A.FUN = B.FUN AND A.QUESTION = B.QUESTION ) AORDER BY PERSON, FUN, JOBNAME, QUESTION, MINUTES
Vaibhav TIf I cant go back, I want to go fast...