select left(客户,charindex('0',客户)-1) as 客户,
sum(销量) as 总销量
from
(
select replace(客户名称,'1','0') as 客户,销量
union all
select replace(客户名称,'2','0') as 客户,销量
union all
select replace(客户名称,'3','0') as 客户,销量
union all
select replace(客户名称,'4','0') as 客户,销量
union all
select replace(客户名称,'5','0') as 客户,销量
union all
select replace(客户名称,'6','0') as 客户,销量
union all
select replace(客户名称,'7','0') as 客户,销量
union all
select replace(客户名称,'8','0') as 客户,销量
union all
select replace(客户名称,'9','0') as 客户,销量
) a
group by left(客户,charindex('0',客户)-1)
1、
create function dbo.clear_num
(@input varchaR(255))
RETURNS varchar(255)
as
begin
declare @output varchar(255)
set @output=''
while @input<>''
begin
if isnumeric(left(@input,1))=0
set @output=@output+left(@input,1)
set @input=right(@input,len(@input)-1)
end
return @output
end
go
group by dbo.clear_num( 客户名称)
2、
group by replace(replace(……),'0',','),'1',''……,'9','')