Although not very performant, Bubble Sort, Selection Sort, and Insertion Sort are all simple algorithms for sorting a one-dimensional array. Each works well enough for shorter arrays.

You can write the more simple algorithms in TSQL, although some iteration is required. In this example, I will implement a variation of the Bubble Sort sorting algorithm, ...