Subquery returned more than 1 value.

Subquery returned more than 1 value.

I have a problem creating a query that displays results for more than one
branch. PLease see my code below. SELECT (SELECT
COUNT(FilteredAppointment.activitytypecodename) AS Expr1 FROM
FilteredBusinessUnit INNER JOIN FilteredSystemUser ON
FilteredBusinessUnit.businessunitid = FilteredSystemUser.businessunitid
INNER JOIN FilteredAppointment ON FilteredSystemUser.systemuserid =
FilteredAppointment.createdby WHERE (FilteredBusinessUnit.name IN
(@Branch))) AS Appointment, (SELECT COUNT(FilteredLead.leadid) AS Expr1
FROM FilteredBusinessUnit AS FilteredBusinessUnit_7 INNER JOIN
FilteredSystemUser AS FilteredSystemUser_7 ON
FilteredBusinessUnit_7.businessunitid =
FilteredSystemUser_7.businessunitid INNER JOIN FilteredLead ON
FilteredSystemUser_7.systemuserid = FilteredLead.createdby WHERE
(FilteredBusinessUnit_7.name IN (@Branch)) AND
(FilteredLead.new_referraltypename = 'Bank Staff')) AS
Bank_Staff_Referral, (SELECT COUNT(FilteredLead_3.leadid) AS Expr1 FROM
FilteredBusinessUnit AS FilteredBusinessUnit_6 INNER JOIN
FilteredSystemUser AS FilteredSystemUser_6 ON
FilteredBusinessUnit_6.businessunitid =
FilteredSystemUser_6.businessunitid INNER JOIN FilteredLead AS
FilteredLead_3 ON FilteredSystemUser_6.systemuserid =
FilteredLead_3.createdby WHERE (FilteredBusinessUnit_6.name IN (@Branch))
AND (FilteredLead_3.new_referraltypename = 'Existing Customer')) AS
Customer_Referral, (SELECT
COUNT(Filterednew_discoveryinterview.activityid) AS Expr1 FROM
FilteredBusinessUnit AS FilteredBusinessUnit_5 INNER JOIN
FilteredSystemUser AS FilteredSystemUser_5 ON
FilteredBusinessUnit_5.businessunitid =
FilteredSystemUser_5.businessunitid INNER JOIN
Filterednew_discoveryinterview ON FilteredSystemUser_5.systemuserid =
Filterednew_discoveryinterview.createdby WHERE
(FilteredBusinessUnit_5.name IN (@Branch))) AS Discovery_Interview,
(SELECT COUNT(FilteredLead_2.leadid) AS Expr1 FROM FilteredBusinessUnit AS
FilteredBusinessUnit_4 INNER JOIN FilteredSystemUser AS
FilteredSystemUser_4 ON FilteredBusinessUnit_4.businessunitid =
FilteredSystemUser_4.businessunitid INNER JOIN FilteredLead AS
FilteredLead_2 ON FilteredSystemUser_4.systemuserid =
FilteredLead_2.createdby WHERE (FilteredBusinessUnit_4.name IN (@Branch)))
AS Generated_Leads, (SELECT COUNT(FilteredPhoneCall.createdon) AS Expr1
FROM FilteredBusinessUnit AS FilteredBusinessUnit_3 INNER JOIN
FilteredSystemUser AS FilteredSystemUser_3 ON
FilteredBusinessUnit_3.businessunitid =
FilteredSystemUser_3.businessunitid INNER JOIN FilteredPhoneCall ON
FilteredSystemUser_3.systemuserid = FilteredPhoneCall.createdby WHERE
(FilteredBusinessUnit_3.name IN (@Branch))) AS Phonecall_Activity, (SELECT
COUNT(Filterednew_presentation.activityid) AS Expr1 FROM
FilteredBusinessUnit AS FilteredBusinessUnit_2 INNER JOIN
FilteredSystemUser AS FilteredSystemUser_2 ON
FilteredBusinessUnit_2.businessunitid =
FilteredSystemUser_2.businessunitid INNER JOIN Filterednew_presentation ON
FilteredSystemUser_2.systemuserid = Filterednew_presentation.createdby
WHERE (FilteredBusinessUnit_2.name IN (@Branch))) AS Presentations,
(SELECT COUNT(FilteredLead_1.leadid) AS Expr1 FROM FilteredBusinessUnit AS
FilteredBusinessUnit_1 INNER JOIN FilteredSystemUser AS
FilteredSystemUser_1 ON FilteredBusinessUnit_1.businessunitid =
FilteredSystemUser_1.businessunitid INNER JOIN FilteredLead AS
FilteredLead_1 ON FilteredSystemUser_1.systemuserid =
FilteredLead_1.createdby WHERE (FilteredBusinessUnit_1.name IN (@Branch))
AND (FilteredLead_1.new_referraltypename = 'Self')) AS Self_Referral,
(SELECT name FROM FilteredBusinessUnit WHERE (FilteredBusinessUnit.name IN
(@Branch ))) AS BRANCH
The code returns results for query run against a single branch but throws
error message" Subquery returned more than 1 value. This is not permitted
when the subquery follows =, !=, <, <= , >, >= or when the subquery is
used as an expression. " When I select more than one branch. My guess is
that the error occurs when the last block of select statement is run.
Please help me