Check For Positive Value

I need to be able to check & display people who have a positive value in the bills.
i.e > 1p.
On the billingtotal table i need to sum > 1p.



CREATE PROCEDURE rpt_PositiveAccountBalances

(@cmb1 as varchar(100)) WITH ENCRYPTION

AS

BEGIN

SELECT DISTINCT




Site.siteName,

Child.surname + ', ' + Child.forename AS ChildsName,

billPayer.surname + ', ' + billPayer.forename AS BillPayerName,

BillingTotal.total

FROM

Site

INNER JOIN


Child

ON


Site.siteID = Child.siteID

INNER JOIN


BillingTotal

ON


Site.siteID = BillingTotal.siteID

CROSS JOIN


billPayer

WHERE


site.sitename=@cmb1

END