Luis Cazares (7/10/2015)

---

sgmunson (7/10/2015)

---

Luis Cazares (4/22/2015)

---

This can be done with a recursive CTE. You can find many examples on the internet.

It should be something like this:

WITH RCTE AS(

select T1.a1, T1.a2,...

Luis Cazares (4/22/2015)

---

This can be done with a recursive CTE. You can find many examples on the internet.

It should be something like this:

WITH RCTE AS(

select T1.a1, T1.a2, T1.a3,

...