Creation of string like aa,ab....ba,bb....za,zb,... zz in sql server
--------------------------------------------------------------------------------------------------------;
with
cte_tally as
(
select row_number() over (order by (select 1)) as n
from sys.all_columns
)
select
char(n) as alpha, ROW_NUMBER() over (order by char(n)) as SNO into #temp
from
cte_tally
where
(n > 96 and n < 123);
--select * from #temp
Declare @CounterOuter int=1
Declare @CounterInner int=1
Declare @CodeCounter int=100
create table #tempResult (code int ,value varchar(10))
while (@CounterOuter<=26)
begin
while (@CounterInner<=26)
begin
print convert(varchar,@CounterOuter)+'-'+convert(varchar,@CounterInner)
Declare @ValueOuter varchar(10)
Declare @ValueInner varchar(10)
set @ValueOuter=(Select alpha from #temp where SNO=@CounterOuter)
set @ValueInner=(Select alpha from #temp where SNO=@CounterInner)
insert into #tempResult (code,value) select @CodeCounter,@ValueOuter+''+@ValueInner
set @CounterInner=@CounterInner+1
set @CodeCounter=@CodeCounter+1
end
set @CounterOuter=@CounterOuter+1
set @CounterInner=1
end
select code,value from #tempResult
drop table #temp
drop table #tempResult
