Write a stored procedure in sql

Question

1.00/5 (3 votes)

See more:

Hai....

Write a Stored procedure in SQL Employee working more then 8 howers. Every one hower this
Salary is double than normal howers (Daily working howers is 8 howers)

create three tables: 1.Shifts,2.employee,3.timesheet
Insert into shift values(emp_code int,shift_name varchar(),shift_time time);
Insert into employee values(emp_code int,emp_name varchar(),grade varchar(),dept varchar(), salary int);
Insert into timesheet values(emp_code int,date _in date,time_in time,time_out time,date_out date);

"Using above Three table and write SP"

Example:

Per day normal working howers is :8 howers
per howers salary 100 rupes
Daily salary =8*100=800
Spend extra 1 hower =1*100 (normal salary)+salary double
=1*100+100=200
Spend extra 2 howers=2*100 (normal salary)+salary double
=2*100=200+200(salary double)=400
Plz Send Stored procedure in SQL ((Using above Three Tables))

Thanks and regard's

Venkatesh D

What I have tried:

Sorry I know the basic of sp so i don't try

Posted 16-Feb-16 1:22am

Member 12330797

Add a Solution

Comments

deepankarbhatnagar 16-Feb-16 7:42am

Have u tried. We are not here for spoon feeding. Where do you stuck. please show your code, we will try to resolve it...

F-ES Sitecore 16-Feb-16 7:43am

We're not here to do your homework for you.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2016-02-16T01:43:00

"Sorry I know the basic of sp so i don't try"

Sorry, but we aren't here to do your homework for you, particularly if you can't be bothered to try, or learn anything.
That kind of attitude will not get you very far - or a good job. All you will do is annoy people, and annoyed people don't help much.
So start here: Sql Server - How To Write a Stored Procedure in SQL Server[^] and here: https://msdn.microsoft.com/en-GB/library/ms345415.aspx?f=255&MSPPError=-2147217396[^]
And give it a try.
If you meet a specific problem, then please ask about that and we will do our best to help. But we aren't going to do it all for you!