R
та я тут greenman так что все ок
Declare @StartDate DATE, @EndDate DATE
set @StartDate=cast('20190101' as date)
set @EndDate ='20200101'
CREATE TABLE #UrgentAccount
(
OfficeID INT,
AccountNo NVARCHAR(20),
Counts INT,
CustomerID INT,
Name varchar(100),
OpenDate DATE,
CloseDate DATE,
CurrencyID INT,
BranchID INT,
Summa INT
PRIMARY KEY (AccountNo, CurrencyID)
)
INSERT INTO #UrgentAccount
SELECT
a.OfficeID,
a.AccountNo,
COUNT(*)'Количество',
a.CustomerID,
b.ShortName'Имя Филиалов',
a.OpenDate,
a.CloseDate,
a.CurrencyID,
o.BranchID,
Sum(bend.SumN)
FROM dbo.Accounts a
INNER JOIN dbo.Offices o ON o.ID= a.OfficeID
INNER JOIN dbo.Branches b on (b.id=o.BranchID)
INNER JOIN Deposits.DepositAccounts d on d.MainAccountNo = a.AccountNo
INNER JOIN dbo.GetAccountsBalances(@EndDate) bend on bend.AccountNo = a.AccountNo
WHERE
(a.CloseDate IS NULL OR a.CloseDate >= @StartDate) AND
(a.OpenDate <= @EndDate)
and a.BalanceGroup in ('20220','20222','20230','20232')
AND a.OpenDate BETWEEN @StartDate and @EndDate
GROUP BY
a.OfficeID,
a.AccountNo,
a.CustomerID,
a.CurrencyID,
o.BranchID,
a.OpenDate,
a.CloseDate,
b.ShortName
select
Name 'Имя Филиалов',
Counts 'Количество',
Summa 'Сумма'
FROM #UrgentAccount
WHERE BranchID !=27
ORDER BY Name
временная таблица есть, и из него нужно выводить количество счетов филилала
