It would also appear to be pretty good in the area of performance as well as the shortest. Here's some test data for folks to play with.
WITH cteBaseData([Column]) AS
SELECT 'TD3-T1' UNION ALL
SELECT 'TC3-T2' UNION ALL
SELECT 'TC4-T2' UNION ALL
SELECT 'TT' UNION ALL
SELECT 'TC' UNION ALL
SELECT TOP 100000
SomeID = IDENTITY(INT,1,1),
FROM cteBaseData data
CROSS JOIN master.sys.all_columns ac1
CROSS JOIN master.sys.all_columns ac2
--Jeff ModenRBAR is pronounced "ree-bar" and is a "Modenism" for "Row By Agonizing Row".
First step towards the paradigm shift of writing Set Based code: "Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."
When writing schedules, keep the following in mind: "If you want it real bad, that's the way you'll likely get it."