Just now I had the requirement to create a loop in SSIS, and have that loop the alphabet.
In order to facilitate that, I generated a T-SQL statement, that provides the alphabet including the Danish Æ, Ø and Å. If you don’t need these, you can leave out the latter part of the last where clause (197, 198, 216).
1: SELECT CHAR(number) FROM master..spt_values 2: WHERE 3: Type = 'P' 4: AND 5: ( number between 65 and 90 6: OR 7: number IN (197, 198, 216) 8: )
Link to an ASCII table with possible values ranging from 0 to 255.