SELECT @titleqty = (SELECT SUM(qty) FROM sales WHERE title_id = @titleid)
This post gave me the syntax I was looking for.
Software Process Management – DB/Service/API/App/Web Development – Cloud Development and Management
SELECT @titleqty = (SELECT SUM(qty) FROM sales WHERE title_id = @titleid)
This post gave me the syntax I was looking for.