title: How do I pass a list as a parameter in a stored procedure?
body: <p>Looking to pass a list of User IDs to return a list names. I have a plan to handle the outputed names (with a COALESCE something or other) but trying to find the best way to pass in the list of user IDs.
  The guts of my sproc will look something like this:</p>
  
  <pre><code>create procedure [dbo].[get_user_names]
  @user_id_list, --which would equal a list of incoming ID numbers like (5,44,72,81,126)
  @username varchar (30) output
  as
  select last_name+', '+first_name 
  from user_mstr
  where user_id in @user_id_list
  </code></pre>
  
  <p>Passing the values for @user_id_list is my main concern here.</p>