Home Forums SQL Server 2008 SQL Server 2008 - General Using CASE Condition for Prefixing a field from a table RE: Using CASE Condition for Prefixing a field from a table

  • September 30, 2013 at 8:34 am

    #1654579

    Another way to do it is to create a RehireCode table with (1,A), (2,B), ... , (27,AA), (28, AB), ... and join to that.

    27 is an awful lot of times for an employee to be hired by the same company!

    John