Special Sort Order T'sql

Question

Clive Wightman 121

I Have been asked to pull data from a table in like the screen shot.

Any ideas how I can get the zones to appear like the above

instead of like the current way, below.![140916-image.png][2]

Clive Wightman 121 Reputation points

2021-10-15T15:14:45.697+00:00

attached correctly
Viorel 126.4K Reputation points

2021-10-15T15:20:08.1+00:00

How did you manage to get the zones to appear like this?
Clive Wightman 121 Reputation points

2021-10-15T16:17:17.377+00:00

The green highlighted in output from SSRS from the SQL Code, Other output is an order Sales have provided on how they want the report displayed. Posted in here as think SQL code would be better.
Erland Sommarskog 132.4K Reputation points MVP Volunteer Moderator

2021-10-15T21:31:09.75+00:00

I can't say that this is very clear. In T-SQL, you can sort rows, but it seems that you want to sort columns?

If they are rows at some point, the solution would be to set up a mapping table where you say that "Zone 751" maps to 1, "Zone 752" maps to 2 etc.

1 answer

Clive Wightman 121 Reputation points

2021-10-15T15:14:45.697+00:00

attached correctly
Viorel 126.4K Reputation points

2021-10-15T15:20:08.1+00:00

How did you manage to get the zones to appear like this?
Clive Wightman 121 Reputation points

2021-10-15T16:17:17.377+00:00

The green highlighted in output from SSRS from the SQL Code, Other output is an order Sales have provided on how they want the report displayed. Posted in here as think SQL code would be better.
Erland Sommarskog 132.4K Reputation points MVP Volunteer Moderator

2021-10-15T21:31:09.75+00:00

I can't say that this is very clear. In T-SQL, you can sort rows, but it seems that you want to sort columns?

If they are rows at some point, the solution would be to set up a mapping table where you say that "Zone 751" maps to 1, "Zone 752" maps to 2 etc.

Answer 1

Welcome to the microsoft TSQL Q&A forum!

If you just want to get the output in the first screenshot, please refer to:

 SELECT Zone752,Zone753,Zone754,Zone755,Zone791,Zone792,  
 Zone5,Zone6,Zone7,Zone8,Zone9,Zone10,Zone11  
 FROM yourtable

The order of the columns will be returned in the order you listed in the SELECT statement.

If you have any question, please feel free to let me know.

Regards
Echo

If the answer is helpful, please click "Accept Answer" and upvote it.