CREATE TABLE [dbo].[MY_ARTICLES](
[ART_ID] [int] IDENTITY(1,1) NOT NULL,
[ART_ARTICLE_NR] [nvarchar](66) NULL,
[SUP_BRAND] [varchar](250) NULL,
[FULL_NAME] [varchar](1000) NULL,
[ART_PACK_SELFSERVICE] [smallint] NULL,
[ART_MATERIAL_MARK] [smallint] NULL,
[ART_REPLACEMENT] [smallint] NULL,
[ART_ACCESSORY] [smallint] NULL,
[ART_BATCH_SIZE1] [int] NULL,
[ART_BATCH_SIZE2] [int] NULL,
[ART_ARTICLE_NR_CLEAR] [nvarchar](66) NULL,
[useTO] [bit] NULL,
[comment] [varchar](500) NULL,
[useOIL] [bit] NULL,
[useDisk] [bit] NULL,
[useShine] [bit] NULL,
CONSTRAINT [PK_MY_ARTICLES_new_1] PRIMARY KEY CLUSTERED
(
[ART_ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

SELECT TOP 1000
t.SUP_BRAND ,t.ART_ARTICLE_NR_CLEAR, COUNT(t.ART_ARTICLE_NR_CLEAR)  
FROM [avtoshop_backup_proger].[dbo].[MY_ARTICLES] t
group by t.SUP_BRAND ,t.ART_ARTICLE_NR_CLEAR

SUP_BRAND ART_ARTICLE_NR_CLEAR (Отсутствует имя столбца)
</Style>  1
</Styles>  1
<?mso-application progid="Excel.Sheet"?>  1
<Alignment ss:Vertical="Bottom"/>  1
<Cell ss:Index="5"><Data ss:Type="Number">12.93</Data></Cell>  1
<Cell ss:Index="5"><Data ss:Type="Number">1359.07</Data></Cell>  1
<Cell ss:Index="5"><Data ss:Type="Number">137.13</Data></Cell>  1
<Cell ss:Index="5"><Data ss:Type="Number">139.09</Data></Cell>  1
<Cell ss:Index="5"><Data ss:Type="Number">283.72000000000003</Data></Cell>  1
<Cell ss:Index="5"><Data ss:Type="Number">37.61</Data></Cell>  1
<Cell ss:Index="5"><Data ss:Type="Number">429.67</Data></Cell>  1
<Cell ss:Index="5"><Data ss:Type="Number">4684.57</Data></Cell>  1
<Cell ss:Index="5"><Data ss:Type="Number">539.77</Data></Cell>  1