I need to alter the following stored procedure so that the UserID is an optional parameter. I have, as yet, been unsuccessful. Basically, if the user doesn't supply a User ID, I want to return all of the users that match the other criteria.
This seems like it should be a simple thing.......
ALTER PROCEDURE [QMS].[GetQueries]
[UserID] = @UserID