Click here to Skip to main content
15,885,869 members
Please Sign up or sign in to vote.
2.78/5 (3 votes)
See more:
this is my current output
RowNo	ColumnNo	LevelNo	SerialNo
r1	c1	l1	10-100
r1	c1	l2	10-101
r2	c1	l2	10-102
r2	c2	l1	10-103
r2	c2	l2	10-104
r1	c2	l2	10-105
r1	c2	l1	10-106
r2	c1	l1	10-108


i can made this much..
rowno     LevelNo    c1      c2
    r1     l1      10-100   10-106
    r1     l2      10-101   10-105
    r2     l2      10-102   10-104
    r2     l1      10-108   10-103


but i want the output as..
     c1        c2

r1   10-100     10-106
     10-101     10-105

r2    l1       l1
      l2       l2

// instead of l1 and l2 i want their approprite values for serial no..
Posted
Comments
Shweta N Mishra 3-Nov-14 3:39am    
Are you using a multidimensional database and do you need this to be done only in SQL
syed shanu 3-Nov-14 3:45am    
check my Answer Hope that will help you.Similar question was been asked today hour before.
http://www.codeproject.com/Answers/837382/How-Can-I-Get-Formated-Result-In-Sql-Server#answer2
Herman<T>.Instance 4-Nov-14 7:26am    
Set is as solution!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900