You can write the more simple algorithms in TSQL, although some iteration ... our Bubble Sort algorithm works. (The example in this article applies to SQL Server 2000 and later.) ...