Read open orders

Gets a list of orders filtered by status. Use the Status parameter in the WITH clause (e.g. 'open', 'closed', 'cancelled', 'any').

SELECT * FROM Orders WITH (Status='open') --also try 'any', 'open', 'closed', 'cancelled'