Hi,
I have a problem with t-sql query.
Let's assume, that i have a query
selest * from table01
which return a dataset:
| Colum1 | Column2
-------------------------------------
R1| A | B
R2| C | D
R3| E | F
R4| G | H
but I need return few dataset (as many as rows), as shown:
| Colum1 | Column2
-------------------------------------
R1| A | B
| Colum1 | Column2
-------------------------------------
R2| C | D
| Colum1 | Column2
-------------------------------------
R3| E | F
etc....
and I can not use cursors.
Do you have any idea how to solve this? I appreciate any suggestion.
Thank you very much in advance,
Christopher