quote:

---

One way to combine the two is this:

DECLARE @Count int

SELECT @Count = COUNT (*) FROM submission WHERE sup_contact_id = (SELECT s.sup_contact_id FROM...