New feature! Upgrade and increase expert visibility of your issues with Priority Questions.
select vUser_Info.UserID, First_Name, Last_Name, EMail, vUser_Roles.Role_Name, Status, Corporate_Name from dbo.vUser_Info, dbo.vCorporates, dbo.vUser_Roles where vUser_Info.Corporate = vCorporates.CorporateID and vUser_Info.RoleID = vUser_Roles.RoleID and vCorporates.CorporateID = 3 and vUser_Info.RoleID = case when @RoleID = 0 then vUser_Info.RoleID > 0 when @RoleID <> 0 then vUser_Info.RoleID = vUser_Info.RoleID end order by vUser_Info.UserID
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.