SQL Query - expand column value to rows
Hi,
We have three columns in a table as follows.
CheckType StartNumber EndNumber
DXBOU1 101 110
AUHOU1 201 210
Looking for a Query to return the following output.
DXBOU1 101
DXBOU1 102
DXBOU1 103
DXBOU1 104
DXBOU1 105
DXBOU1 106
DXBOU1 107
DXBOU1 108
DXBOU1 109
DXBOU1 110
AUHOU1 201
AUHOU1 202
AUHOU1 203
AUHOU1 204
AUHOU1 205
AUHOU1 206
AUHOU1 207
AUHOU1 208
AUHOU1 209
AUHOU1 210
Regards/Narva