The pending amt should be displayed into the last row in the store procedure output for every record

See more:

C#

Code as follows;

 SELECT CASE WHEN RowNo =1 THEN CONVERT(VARCHAR(10), sno) ELSE '' END AS Sno, CASE WHEN RowNo =1 THEN CONVERT(VARCHAR(10), stud_id) ELSE '' END AS Stu_id,
       CASE WHEN RowNo =1 THEN [stud_name] ELSE '' END AS [Stud_name],[Rcptno] as Rcpt_no, [Rcptdt] as Rcpt_dt, [RcptAmt] as Rcpt_amt, [Chqtype] as P_type, [chqnum] as Number,CASE WHEN RowNo =2 THEN CONVERT(VARCHAR(10), pendamt) ELSE '' END AS Pend_amt
FROM (
    SELECT *, ROW_NUMBER() OVER(PARTITION BY sno ORDER BY sno) AS RowNo
    FROM #TempTable   
) AS T

Output as follows;

10 58685  AROCKIA JEEVAN 1752	15 Jun 2012 	10000.00	DD        	471243              	
			 1762	16 Jun 2012 	149000.00	DD        	471291  0.00
            	
11 58166  BHARATH 	1565	21 Apr 2012 	10000.00	DD      	067935              	
			1566	21 Apr 2012 	49000.00	DD       	067936  0.00             	
			1970	26 Jun 2012 	49000.00	DD        	900671              	
			1971	26 Jun 2012 	21000.00	DD        	900672              	
			2088	23 Jul 2012 	30000.00	DD        	902109   
           	
12 58050  KORLAYYA 	1512	13 Apr 2012 	10000.00			
			1775	18 Jun 2012 	49000.00			        0.00
			1983	28 Jun 2012 	100000.00

From my above output, i want the output as follows;

The pending amt should be displayed into the last row in the output for every record

10 58685  AROCKIA JEEVAN 1752	15 Jun 2012 	10000.00	DD        	471243              	
			 1762	16 Jun 2012 	149000.00	DD        	471291  0.00
            	
11 58166  BHARATH 	1565	21 Apr 2012 	10000.00	DD      	067935              	
			1566	21 Apr 2012 	49000.00	DD       	067936              	
			1970	26 Jun 2012 	49000.00	DD        	900671              	
			1971	26 Jun 2012 	21000.00	DD        	900672              	
			2088	23 Jul 2012 	30000.00	DD        	902109  0.00   
           	
12 58050  KORLAYYA 	1512	13 Apr 2012 	10000.00			
			1775	18 Jun 2012 	49000.00			        
			1983	28 Jun 2012 	100000.00                               0.00

how can i get the above output using my above code.

My above code as follows;

 SELECT CASE WHEN RowNo =1 THEN CONVERT(VARCHAR(10), sno) ELSE '' END AS Sno, CASE WHEN RowNo =1 THEN CONVERT(VARCHAR(10), stud_id) ELSE '' END AS Stu_id,
       CASE WHEN RowNo =1 THEN [stud_name] ELSE '' END AS [Stud_name],[Rcptno] as Rcpt_no, [Rcptdt] as Rcpt_dt, [RcptAmt] as Rcpt_amt, [Chqtype] as P_type, [chqnum] as Number,CASE WHEN RowNo =2 THEN CONVERT(VARCHAR(10), pendamt) ELSE '' END AS Pend_amt
FROM (
    SELECT *, ROW_NUMBER() OVER(PARTITION BY sno ORDER BY sno) AS RowNo
    FROM #TempTable   
) AS T

how can i do?

Regards,
Narasiman P.