Sorting by Columns
I have checked the view and there is no ORDER BY clause, see below:
SELECT dbo.pendingsalesdetail.id, dbo.pendingsalesdetail.orderid, dbo.pendingsalesdetail.itemnumber, dbo.pendingsalesdetail.description,
dbo.pendingsalesdetail.packquantity, dbo.pendingsalesdetail.quantity, dbo.pendingsalesdetail.cost, dbo.pendingsalesdetail.price, dbo.pendingsalesdetail.weight,
dbo.pendingsalesdetail.totalprice, dbo.pendingsalesdetail.volumediscount, dbo.pendingsalesdetail.status, dbo.pendingsalesdetail.userdetails_id,
dbo.pendingsalesdetail.date, dbo.pendingsalesdetail.packingorder, dbo.pendingsalesdetail.supplier, dbo.pendingsalesdetail.purchaseorderstatus,
dbo.userdetails.firstname, dbo.userdetails.surname, dbo.pendingsalesdetail.small_count, dbo.items.stock
FROM dbo.pendingsalesdetail INNER JOIN
dbo.userdetails ON dbo.pendingsalesdetail.userdetails_id = dbo.userdetails.id INNER JOIN
dbo.items ON dbo.pendingsalesdetail.itemnumber = dbo.items.itemnumber
WHERE (dbo.pendingsalesdetail.status = 'pending')