Jeff Moden (12/21/2009)
...
SELECT REPLACE((SELECT CHAR(SUBSTRING('.'+p2.Cypher,N+1,CHARINDEX('.',p2.Cypher+'.',N)-N)+64)
FROM dbo.Tally t
...
Msg 208, Level 16, State 1, Line 13
Invalid object name 'dbo.Tally'. 😉
I guess there are natural numbers in this table. This would work:
...
SELECT REPLACE((SELECT CHAR(SUBSTRING('.'+p2.Cypher,N+1,CHARINDEX('.',p2.Cypher+'.',N)-N)+64)
FROM (SELECT number AS N FROM master.dbo.spt_values WHERE type = 'P') t
...