... JOIN
[EQUIPMENT] eq
ON
eq.EquipId=re.EquipId
WHERE
re.RoomId=@GivenRoom
AND
re.SetId=@setId
This seems to have problems because when there are no matching rows (so zero results), BIDS ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.