--choose a vendor
SELECT TOP 10 * FROM tbVendor where VendorName LIKE '%martin%'

--Choose a store
SELECT TOP 100 * FROM tbEntity

DECLARE @EntityID AS BIGINT = 269
DECLARE @VendorID AS BIGINT = 152

SELECT VendorCode, VendorDescription, MinOrderQty, MaxOrderQty 
FROM tbVendorEntityItem 
WHERE EntityID=@EntityID AND VendorID=@VendorID
