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