How to find table and index size in SQL Server?

show additional rows based on field value (Oracle SQL)

Rodriguez

I have a query which shows the result as follows

NAME   RATIO
====   =====
S        3
M        2

I want to make Ratio Groups (A,B,C .....) based on Names For Example, there are 3 ratios for Name S so A,B,C Group will be made for S and D,E will be made for M. The result I want to be displayed will be like this

NAME      GROUP
====      =====
S           A
S           B
S           C
M           D
M           E

To pass Letter dynamically, I tried using the the ANSI Characater CHR(65) for A and so on.. but couldn't find a way to write the query.

How can I achieve this using SQL Query?

Regards