ALTER PROCEDURE [dbo].[PoliciesGetSuspenseAmount] >( > @PolicyHeaderPK uniqueidentifier, > @SuspenseAmount decimal(18,2) OUTPUT >) >AS > SET NOCOUNT ON; > SELECT > @SuspenseAmount = COALESCE(SUM(AmountReceived), 0.00) > FROM [dbo].[ReceiptDetails] > inner join [dbo].[Receipts] on ReceiptFK = ReceiptPK > WHERE > ([PolicyHeaderFK] = @PolicyHeaderPK > AND ReceiptTypeFK = 4)>