Свертывание и суммирование

select A, sum(c) from somethit
group by A

SELECT --DISTINCT  
 
[articleCode] as [Код связки],
--day(g.ondate) as [число],
--g.Demand as [Продажи],
--forecast1 as [Прогноз1],
 
sum(TEST_SLIM4.dbo.For_condition4(@TODAY, @ALLDAYS, g.ondate, g.Demand, forecast1) )
 
 
FROM [Slim4].[slim4].dbo.Article  
full join Axon.Slim4.dbo.DayDemand_Current    g on articleCode = g.articulCode 
WHERE Code between 900000 and 999999 and articleCode = '20665-900001' 
 
group by [articleCode]
--ORDER BY articleCode

SELECT A, SUM(CAST(CASE WHEN ISNUMERIC(C) THEN CAST(C AS INT) ELSE 0 END))
    FROM myTable
    GROUP BY A

SELECT DISTINCT  
 
[articleCode], --sum(g.Demand),
 
--g.Demand
 
 
SUM(CAST(CASE WHEN ISNUMERIC(TEST_SLIM4.dbo.For_condition4(@TODAY, @ALLDAYS, g.ondate, g.Demand, forecast1)) 
        THEN CAST(TEST_SLIM4.dbo.For_condition4(@TODAY, @ALLDAYS, g.ondate, g.Demand, forecast1) AS INT) ELSE 0 END))
 
 
 
FROM [Slim4].[slim4].dbo.Article  
full join Axon.Slim4.dbo.DayDemand_Current    g on articleCode = g.articulCode 
WHERE Code between 900000 and 999999 and warehouse = '20665-' and [articleCode] = '20665-901182'
 
 
--ORDER BY [Код связки]
GROUP BY [articleCode]

SELECT A, SUM(CAST(CASE WHEN ISNUMERIC(C) = 1 THEN CAST(C AS INT) ELSE 0 END))
    FROM myTable
    GROUP BY A

SELECT A, SUM(CAST(CASE WHEN ISNUMERIC(C) = 1 THEN CAST(C AS INT) ELSE 0 END  AS INT))
    FROM myTable
    GROUP BY A

SELECT ISNUMERIC(',')

SELECT A, SUM(CASE WHEN ISNUMERIC(C) = 1 THEN CAST(C AS INT) ELSE 0 END)
    FROM myTable
    GROUP BY A

SELECT DISTINCT  
 
[articleCode] as [Код связки], 
 
isnull(sum(g.Demand), 0) as [Текущие продажи не включая посл. день],
 
SUM(CASE WHEN ISNUMERIC(TEST_SLIM4.dbo.For_condition4(@TODAY, @ALLDAYS, g.ondate, g.Demand, forecast1)) = 1 
        THEN CAST(TEST_SLIM4.dbo.For_condition4(@TODAY, @ALLDAYS, g.ondate, g.Demand, forecast1) AS INT) ELSE 0 END) 
 
FROM [Slim4].[slim4].dbo.Article  
full join Axon.Slim4.dbo.DayDemand_Current    g on articleCode = g.articulCode 
WHERE Code between 900000 and 999999 and warehouse = '20665-' --and [articleCode] = '20665-901182'
 
GROUP BY [articleCode]
ORDER BY [articleCode]

SELECT [Список полей]
    FROM [Таблица, возможно, с кучей Join-ов]
        [Какой то, который вам нужен] JOIN [Подзапрос] AS [Альяс подзапроса]
            ON [Альяс подзапроса].[Код связки] = [Таблица, к которой join-ится подзапрос].[поле, к которому join-ится подзапрос]
    GROUP BY [Список полей], [Альяс подзапроса].[Поле для группировки]

select
A as [код связски],
B as [что-то еще],
С as [еще что-то еще],
...
from ... where ...
group by A, B, C ...
order by [код связски], [что-то еще], [еще что-то еще],  ...

SELECT DISTINCT  
[articleCode], --sum(g.Demand),
--g.Demand
SUM(CASE WHEN ISNUMERIC(myFinctionRez)=1 THEN CAST(myFinctionRez AS INT) ELSE 0 END)
FROM [Slim4].[slim4].dbo.Article  
full join Axon.Slim4.dbo.DayDemand_Current    g on articleCode = g.articulCode 
CROSS APPLY(SELECT myFinctionRez=TEST_SLIM4.dbo.For_condition4(
   @TODAY, @ALLDAYS, g.ondate, g.Demand, forecast1)
   )crsapp
WHERE Code between 900000 and 999999 and warehouse = '20665-' 
   and [articleCode] = '20665-901182'
--ORDER BY [Код связки]
GROUP BY [articleCode]

select
[код связски],
[что-то еще],
[еще что-то еще],
...
from ... 
cross apply(select A as [код связски])crsapp1
cross apply(select B as [что-то еще])crsapp2
cross apply(select С as [еще что-то еще])crsapp3
where ...
group by [код связски], [что-то еще], [еще что-то еще],  ...
order by [код связски], [что-то еще], [еще что-то еще],  ...