Tuesday, 13 August 2013

Any way to generate hierarchical values in sql server 2008

Any way to generate hierarchical values in sql server 2008

We need the values in hierarchical data format as below using SQL Server,
1
1.1
1.1.1
1.1.1.1
1.1.1.2
1.1.1.3
1.1.2
1.1.2.1
1.1.2.2
1.1.2.3
1.1.3
1.1.3.1
1.1.3.2
1.1.3.3
1.1.4
1.1.4.1
1.1.4.2
1.1.4.3
1.2
1.2.1
1.2.1.1
1.2.1.2
1.2.1.3
1.2.2
1.2.2.1
1.2.2.2
1.2.2.3
1.2.3
1.2.3.1
1.2.3.2
1.2.3.3
1.2.4
1.2.4.1
1.2.4.2
1.2.4.3
..
..
..
1.100.100.100
Can anyone help?

No comments:

Post a Comment