Rows split to columns
Hi
I have a table that has 2 cols From and To
The values are say from=1 and to=9 and in the second row from=10 and to=20
I need SQL to turn that into 1 column listing 1,2,3,4,5,6,7,8,910,11,12,
Thanks
I have a table that has 2 cols From and To
The values are say from=1 and to=9 and in the second row from=10 and to=20
I need SQL to turn that into 1 column listing 1,2,3,4,5,6,7,8,910,11,12,
Thanks
Last Comment
ASKER CERTIFIED SOLUTION
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks
declare @t table ( [from] int, [to] int)
insert into @t values ( 1, 9 )
insert into @t values ( 10, 20 )
;with data as (
select [from], [to] from @t
union all
select [from] + 1, [to] from data
where [from] < [to]
)
, ordered as ( select top 99.999999 percent [from] from data order by [from] )
SELECT * FROM ordered
Was enough, I just want the data going down in one column. Thanks for help
declare @t table ( [from] int, [to] int)
insert into @t values ( 1, 9 )
insert into @t values ( 10, 20 )
;with data as (
select [from], [to] from @t
union all
select [from] + 1, [to] from data
where [from] < [to]
)
, ordered as ( select top 99.999999 percent [from] from data order by [from] )
SELECT * FROM ordered
Was enough, I just want the data going down in one column. Thanks for help
Microsoft SQL Server 2005
Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.
72K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
are [from] and [to] fields integers?
are there other fields in the table to "group by"?
and, would there ever be gaps in the output number sequence (if so when)?
e.g.
category-A| 1,2,3,4,5,6
category-B| 20,21,23,24,25,26
category-C| 1,2,3,4,5,6,20,21,23,24,25