Please help to UNION the second set of code to the first set of code as one stored procedure code

See more:

SQL-Server

SQL-Server-2008

I want to get the final sum totals of of debit and credit of this trialbalance. When I execute this in sql the totals always show in a different gird but i want them as one stored procedure.

Thanks in advance

CREATE PROCEDURE [dbo].[TrialBalance]

AS

SELECT COA.Account_Code AS [Account Code],COA.Account_Name 
AS [Account Name],CAST(SUM(debit-credit) AS varchar) 
AS [$ Debit],'' AS [$ Credit] FROM COA JOIN CashBook 
ON COA.Account_Name = CashBook.Account_Name 
WHERE COA.Account_Name_Cate IN ('Assets') 
GROUP BY COA.Account_Code, COA.Account_Name

UNION ALL

SELECT COA.Account_Code AS [Account Code],COA.Account_Name 
AS [Account Name],CAST(SUM(debit-credit) AS varchar) 
AS [$ Debit],'' AS [$ Credit] FROM COA JOIN AccountReceivable_LDG 
ON COA.Account_Name = AccountReceivable_LDG.Account_Name 
WHERE COA.Account_Name_Cate IN ('Assets') 
GROUP BY COA.Account_Code, COA.Account_Name

UNION ALL 

SELECT COA.Account_Code 
AS [Account Code],COA.Account_Name 
AS [Account Name],'',CAST(SUM(debit-credit) AS varchar)
FROM COA JOIN AccountPayable_LDG ON COA.Account_Name = AccountPayable_LDG.Account_Name 
WHERE COA.Account_Name_Cate IN ('Liabilities') 
GROUP BY COA.Account_Code, COA.Account_Name



SELECT 'Totals :' AS [-],':' AS [-],CAST(SUM(Debit-Credit) AS varchar) 
AS [-] FROM ( SELECT  Debit, Credit  
FROM   COA JOIN CashBook ON COA.Account_Name = CashBook.Account_Name 
WHERE   COA.Account_Name_Cate IN ('Assets') 

UNION ALL

SELECT  Debit, Credit  
FROM   COA JOIN AccountReceivable_LDG ON COA.Account_Name = AccountReceivable_LDG.Account_Name 
WHERE   COA.Account_Name_Cate IN ('Assets'))s


SELECT 'Totals :' AS [-],':' AS [-],CAST(SUM(Debit-Credit) AS varchar) AS [-] 
FROM ( SELECT  Debit, Credit FROM   COA JOIN AccountPayable_LDG 
ON COA.Account_Name = AccountPayable_LDG.Account_Name 
WHERE   COA.Account_Name_Cate IN ('Liabilities'))s

[edit]Code block added[/edit]