troubleshooting Question

SQL pivot query 2

Avatar of mcrmg
mcrmg asked on
Microsoft SQL Server 2008SQL
6 Comments1 Solution323 ViewsLast Modified:
Hi,

EE helped me with this question
https://www.experts-exchange.com/Database/MS-SQL-Server/SQL_Server_2008/Q_28434814.html#a40068498

I was wondering if there is a way to display the result based on the pre-defined range (sorted)

state Row_Count   Amount      pct
----- ----------- ----------- ---------
0-0.03     1           10          0.03
0.1-0.4    4           100         0.34
0.4-0.5    3           130         0.45

thx
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros