Question: 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

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).

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

To create the spPayIncreaseListing stored procedure you can use the following SQL ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Create a stored procedure named prc_new_detail to insert new rows in the DETAILRENTAL table. The procedure should satisfy the following requirements. a. The video number will be provided as a...

Create a stored procedure named prc_new_rental to insert new rows in the RENTAL table. The procedure should satisfy the following conditions. a. The membership number will be provided as a parameter....

Create a stored procedure named prc_return_video enter data about the return of videos that had been rented. The procedure should satisfy the following requirements. a. The video number will be...

The owner of Colonial Adventure Tours knows the importance of the SQL language in database management. He realizes that he can use SQL to perform the same functions that you performed with queries in...

Create a stored procedure named sp Balance Range that accepts three optional parameters. The procedure should return a result set consisting of Vendor Name, Invoice Number, and Balance for each...

Create a Web page named magic.html that simulates the functionality of a Magic 8 Ball. Your page should look similar to the one in Figure 9.10, with a text box for entering a yes-or-no question, and...

Add the SeqSearch function to the arrays.js library file, then create a Web page named seq.html that utilizes the SeqSearch function to perform sequential searches on user input. The page should...

Design and create a Web page named states.html that quizzes the user on state capitals. The layout of the page is entirely up to you. However, the page should contain a text box in which the user can...

Draw a network diagram that represents the following IS development task list. Use both the activity-in-the-box and the activity-on-the-arrow formats. Activity Immediate Predecessor 1. Problem...

Create a library file named weather.js that contains the definitions of your dew point and wind chill functions. Then, create a Web page named indexes.html that has text boxes where the user can...

A marketing program must connect an organization with its customers. In this exercise, we will investigate marketing programs, the marketing mix, and the important concept of customer value....

A schedule is the conversion of a project action plan into an operating timetable. As such, it serves as the basis for monitoring and controlling project activity and taken together with the plan and...

Part A - Planning for resources You must develop resource plans for three different resources identified using the template provided in the Appendix L. For all three resource plans, you need to plan...

pts.) Find 4 4 matrices X and Y such that 0 1 1 1 1 0 1 1 1 1 0 1 1 1 1 XY-YX = 0.

1. Connie was born in 1968. she is an engineering consultant and earns more than $90,000 per year. She saves very little money because she prefers to spend It on a luxurious apartment, clothes,...

Which of the following statements is/are correct? I. The fragmentation is applicable for data in the datagram but not for header. II. Reassembly of the fragments must be performed at the destination...

Which of the following are grammars is/are ambiguous? 3 xS| Sx S (I II) S XX, X aX, X - b a) I only b) II only c) Both I and II d) Neither I nor II

Match the following and select the correct option. 1 BFS algorithm spanning tree a Kruskal's algorithm Shortest paths Strongly Connected Components DFS algorithm 4 Bellman-Ford d Greedy approach...

Question 201 ptsThe Open Championship of golf, is usually rotated between what two countries?keland and ScotlandScotland and Northern trelandEngland and WalesFingland and Scotiand

How do you use an AND criterion to combine criteria in an Access query? How do you use an OR criterion to combine criteria?

Describe the purpose of the PROJECT command in relational algebra.

Write the SQL commands to grant the following privileges: a. User Stetson must be able to retrieve data from the Customer table. b. Users Webster and Bremer must be able to add new orders and order...

A USA Today editorial addressed the growth of compensation for corporate CEOs. As an example, quoting a study made by BusinessWeek , USA Today indicated that the pay packages for CEOs have increased...

Maynards, a regional home improvement store chain located in the Intermountain West, is considering upgrading to a new series of scanning systems for its automatic checkout lanes. Although scanners...

Given the following sample data a. Based on the computations for the within- and between-sample variation, develop the ANOVA table and test the appropriate null hypothesis using = 0.05. Use the p...