select 1 > from ClaimItems inner join Claims on cit_clmfk = clm_pk > where dbo.claimitemstatus(clm_forwarded > ,cit_received > ,(select com_overduedays > from companies > inner join Clients on cli_comfk = com_pk > inner join Claims subclaims on clm_clifk = cli_pk > where subclaims.clm_pk = claims.clm_pk)) = 3Change this to:
select 1 from ClaimItems inner join Claims on cit_clmfk = clm_pk where dbo.claimitemstatus(clm_forwarded ,cit_received ,(select SUM(com_overduedays) from companies inner join Clients on cli_comfk = com_pk inner join Claims subclaims on clm_clifk = cli_pk where subclaims.clm_pk = claims.clm_pk)) = 3This will help avoiding subquery returned more than 1 record error in a future.