pending mat must be display into last row 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;

11  58166   BHARAT 1565	21 Apr 2012  10000.00  DEMAND DRAFT    067935              	
	           1566	21 Apr 2012  49000.00  DEMAND DRAFT    067936              	0.00
                   1970	26 Jun 2012  49000.00  DEMAND DRAFT    900671              	
	           1971	26 Jun 2012  21000.0   DEMAND DRAFT    900672              	
	           2088	23 Jul 2012  30000.00  DEMAND DRAFT    902109          
    	
12 58050   KORLA   1512	13 Apr 2012  10000.00			
	           1775	18 Jun 2012  49000.00	 0.00		                                                         
	           1983	28 Jun 2012  100000.00	

From the above output i want the output as follows;

11  58166   BHARAT 1565	21 Apr 2012  10000.00  DEMAND DRAFT    067935              	
	           1566	21 Apr 2012  49000.00  DEMAND DRAFT    067936              	
                   1970	26 Jun 2012  49000.00  DEMAND DRAFT    900671              	
	           1971	26 Jun 2012  21000.0   DEMAND DRAFT    900672              	
	           2088	23 Jul 2012  30000.00  DEMAND DRAFT    902109           0.00   
    	
12 58050   KORLA   1512	13 Apr 2012  10000.00			
	           1775	18 Jun 2012  49000.00	 	                                                         
	           1983	28 Jun 2012  100000.00	                   0.00	

From my above code what changes i made to get the pending amt is to be displayed in the last row for every record.

how can i do?

Please help me


Regards,
Rao.