There is a typo in the refactored code "ALTER PROCEDURE dbo.Get_UserDetails( @userid INT)", the where statement should use @userid