title: How can I add a serial number for the following query
body: <p>How can I add a serial number for the following query.  I want final result to be displayed with the serial number.</p>
  
  <pre><code>select
    EP.FirstName
  , Ep.LastName
  , [dbo].[GetBookingRoleName](ES.UserId,EP.BookingRole) as RoleName
  from [3rdi_EventParticipants] as EP
  inner join [3rdi_EventSignup] as ES on EP.SignUpId = ES.SignUpId
  where EP.EventId =13
  and userid in (
  select distinct userid from userroles
  where roleid not in(19, 20, 21, 22) and roleid not in(1,2))
  </code></pre>