根据一列的数字生成字母递增,
如某列为
2
1
3
4
2
5
要查询结果为
A列 B列
2 a,b
1 a
3 a,b,c
4 a,b,c,d
2 a,b
5 a,b,c,d,e
谢谢
数字会超过26吗？....如何
关注！
不会超过26,
SQL code:
--> 测试数据：[tb]
if object_id('[tb]') is not null drop table [tb]
create table [tb]([A] int)
insert [tb]
select 2 union all
select 1 union all
select 3 union all
select 4 union all
select 2 union all
select 5
--函数
create function dbo.getcharacter(@id int)
returns varchar(8000)
as
begin
declare @ret varchar(8000)
select @ret=isnull(@ret+',','')+code
from
(select char(number) as code
from master..spt_values
where type = 'P' and number >= 65 and number <= 65+@id-1
) t
return @ret
end
--查询
select A,dbo.getcharacter(A) as B
from tb
-----------------------
2 A,B
1 A
3 A,B,C
4 A,B,C,D
2 A,B
5 A,B,C,D,E
那你是否有个是1-26,A-Z对应
SQL code:
--要小写就用
select A,lower(dbo.getcharacter(A)) as B
from tb
不会超过26，我
