0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

USE master
DECLARE @ varchar(max)='T-SQL';

WITH C as
(
  SELECT DISTINCT substring(@,number+1,1)x
  FROM spt_values
  WHERE'P'=type and len(@)>number
),D as
(
  SELECT x y
  FROM c UNION ALL
  SELECT y+x
  FROM C JOIN D
  ON len(y)<len(@)
)SELECT top 1*FROM D
GROUP BY y
ORDER BY newid()

fork query

edited apr 6 19

created apr 6 19 anonymous