mssql syntax for selecting local variables in stored procedures September 30, 2011September 30, 2011 by Geir Sigurður, posted in Uncategorized SELECT @titleqty = (SELECT SUM(qty) FROM sales WHERE title_id = @titleid) This post gave me the syntax I was looking for. Share this:TwitterFacebookLike this:Like Loading... Related