Question
How do I alter this stored procedure to show all people in the stored procedure, even if they don't have a role? ALTER PROCEDURE [dbo].[personSelectAll]
How do I alter this stored procedure to show all people in the stored procedure, even if they don't have a role?
ALTER PROCEDURE [dbo].[personSelectAll] -- Add the parameters for the stored procedure here AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON;
-- Insert statements for procedure here SELECT Person.personID, Person.firstName, Person.lastName, Person.email, Person.phone, ValidRole.roleDesc FROM Person INNER JOIN PersonRole ON Person.personID =PersonRole.personID INNER JOIN ValidRole ON PersonRole.roleID = ValidRole.roleID order by lastname, firstname END
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started