Create a stored procedure named spPayIncreaseListing that returns the following columns: 

 

FirstName

LastName

HireDate (use a CONVERT function so HireDate appears as 05/22/12)

PayRate

 PayRateStartDate (use a CONVERT function so StartDate appears as 05/22/12)

PayRateEndDate (use a CONVERT function so EndDate appears as 05/22/12)

PayComment (use a conditional function so if COLA is yes the phrase "Cost of living increase appears, if HireDate = StartDate then "Initial Payrate" appears, otherwise "Pay raise" should appear)

TermDate (use a conditional function so if TermDate is null, "Still Employed" should appear, otherwise the value in TermDate should go here- hint to make this work you will have to use CONVERT)

 

Sort the records by LastName and by WorkID

 

Execute the procedure to verify that 95 rows are returned (do not include this statement with the query).