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)>>>