Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-05-03 : 16:52:16
|
½G writes "I have data in the form of
COL1 COL2 COL3
100 10 26
14 28 77
7 21 56
66 82 103
I would like a query that would return the data in the form of
The values are the count(Number)
10-30 31-60 61 - 100
2 0 1
2 0 1
2 1 0
0 0 3
I have used a stored procedure to solve this but would like to know if there is a way of getting to the same result using a normal query.
Thanks" |
|
|
|
|
|
Split up some data