SELECT @titleqty = (SELECT SUM(qty) FROM sales WHERE title_id = @titleid)
This post gave me the syntax I was looking for.
September 30, 2011 by Geir Sigurður
SELECT @titleqty = (SELECT SUM(qty) FROM sales WHERE title_id = @titleid)
This post gave me the syntax I was looking for.