衣服尺码自定义排序sql

衣服尺码自定义排序sql

2018年10月15日 13:51:11 42雨林集团军 阅读数 341

转载请注明出处 

1. select SizeCup as Size ,OrderQty from

2.  

3. VW_CM1_SizeBreakdowm where So_NO =@So_No and so_item=@Item_No

4.  

5. order by

6.  

7. (case when SizeCup='XXXL' then '0'

8. when SizeCup ='XXS' then '1'

9. when SizeCup ='XS' then '2'

10. when SizeCup='S' then '3'

11. when SizeCup='M' then '4'

12. when SizeCup='L' then '5'

13. when SizeCup='XL' then '6'

14. when SizeCup='XXL' then '7'

15. when SizeCup='XXXL' then '8'

16. --else COMPARE_FLAG

17. end) ASC