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