Thank this author by sharing:
By Rafal Skotak,
I have to put the script here, in the description field, since the editor above, does not work properly neither in IE nor Firefox.
Anyway this script is an example how You can generate permutations with T-SQL:
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.