Generate Roman Numerals

• ece.viky

  Right there with Babe

  Points: 727

  More actions

  November 20, 2014 at 2:25 pm

  #301315

  Comments posted to this topic are about the item Generate Roman Numerals

• Bill Talada

  SSChampion

  Points: 11954

  More actions

  November 24, 2014 at 1:20 pm

  #1760605

  Maybe some programmers will appreciate my attempt at a simpler version.

  DECLARE @i int, @C varchar(10);

  SET @i = 133;

  SET @C = RIGHT('0000000000'+CAST(@i AS varchar(10)),10);

  SELECT @C,

  REPLICATE('M',CAST(LEFT(@c,7) AS int))

  +CASE substring(@c,8,1) WHEN '1' THEN 'C' WHEN '2' THEN 'CC' WHEN '3' THEN 'CCC' WHEN '4' THEN 'CD' WHEN '5' THEN 'D' WHEN '6' THEN 'DC' WHEN '7' THEN 'DCC' WHEN '8' THEN 'DCCC' WHEN '9' THEN 'CM' ELSE '' END

  +CASE substring(@c,9,1) WHEN '1' THEN 'X' WHEN '2' THEN 'XX' WHEN '3' THEN 'XXX' WHEN '4' THEN 'XL' WHEN '5' THEN 'L' WHEN '6' THEN 'LX' WHEN '7' THEN 'LXX' WHEN '8' THEN 'LXXX' WHEN '9' THEN 'XC' ELSE '' END

  +CASE substring(@c,10,1) WHEN '1' THEN 'I' WHEN '2' THEN 'II' WHEN '3' THEN 'III' WHEN '4' THEN 'IV' WHEN '5' THEN 'V' WHEN '6' THEN 'VI' WHEN '7' THEN 'VII' WHEN '8' THEN 'VIII' WHEN '9' THEN 'IX' ELSE '' END

  ;

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  May 11, 2015 at 1:18 pm

  #1797076

  CELKO (12/9/2014)

  ---

  Why not use a look-up table? What you posted is a FORTRAN or BASIC program written in T-SQL procedural code.

  I agree.