Thread: sort by manufacturer and then by product

I need to sort by manufacturer and then by product when clicking on a browse department item. I know there is aspdnsf_GetProducts that can be changed, but I don't know where or how. Thank you. Jonathan

First off, you need mssql management studio to access your DB and open Programmability -> Store Procedure folder, click the (+) and you'll see aspdnsf_getproducts stored proc. Open/Modify and scroll down to the bottom, from there you'll see:

ORDER BY pf.rownum (above the IF @StatsFirst <> 1)

try changing that to:

ORDER BY m.Name, p.Name

Make sure to make a backup first before doing anything. Thanks

Thanks. Worked Perfectly.