I have a view in my SQL Express database that looks like this
"SELECT Stock_Code, Pallet_No, Weight, daterep, Trans, PONo
WHERE (daterep >= CONVERT(DATETIME, '22/10/2007', 103))"
This works fine but is there a way of creating the same view but making it pick up a single/disitnct pallet_no . There can be multiple pallets but i only want to pick up the first instance
Many thanks in advance