Is it possible to assign at variable a value returned from exec stored procedure?
Something like
DECLARE @count int SET @count = Execute dbo.usp_GetCount @Id=123