I would like to do this :
DECLARE @Id INT;
SET SomeField = 'some value'
OUTPUT @Id = Id
WHERE EmailAddress = @EmailAddress -- this is a parameter of the sproc
Is this even possible? I know I can declare a local table variable and direct the output there but I would prefer to skip it if possible