Ms SQL query need to fix
- or -
Post a project like this3146
$55
- Posted:
- Proposals: 9
- Remote
- #901920
- Awarded
Description
Experience Level: Intermediate
Estimated project duration: 1 day or less
General information for the business: ms SQL query need to fix on the store procedure. strong in sql only plz apply.
Database management system (DBMS): Microsoft SQL Server
Description of requirements/functionality: Please apply very good in SQL n can solve it.
i have 2 query to fix.
one for the weekly off and another for in n out time in an interval within 24 hours.
A)i have a query for day present list, day 1 to 31- present or absent. working fine now. need to add 1 more case for leave.
1.i have a table weekly off. in that what ever weekdays like monday, tues..etc we set it should take it. need to join with my query and set as leave.
2.frequently weeks they will change it. so depend on the date need to take it.
3.this week they set me tues day leave. after 2 weeks they will set monday. so report will come last week weks tues. this week n futures week take recent set one.
query -http://sqlfiddle.com/#!3/84385
b)issues on in n out with in 23 hours.. interval should be 24 hours.. if exceed null should come.. see for below details.
http://www.sqlservercentral.com/Forums/Topic1712715-391-1.aspx
query - http://sqlfiddle.com/#!3/386e2/1
Please who good in sql n exp person only apply. also verify this n make sure u can . then only apply please.
Thanks
Extra notes:
Database management system (DBMS): Microsoft SQL Server
Description of requirements/functionality: Please apply very good in SQL n can solve it.
i have 2 query to fix.
one for the weekly off and another for in n out time in an interval within 24 hours.
A)i have a query for day present list, day 1 to 31- present or absent. working fine now. need to add 1 more case for leave.
1.i have a table weekly off. in that what ever weekdays like monday, tues..etc we set it should take it. need to join with my query and set as leave.
2.frequently weeks they will change it. so depend on the date need to take it.
3.this week they set me tues day leave. after 2 weeks they will set monday. so report will come last week weks tues. this week n futures week take recent set one.
query -http://sqlfiddle.com/#!3/84385
b)issues on in n out with in 23 hours.. interval should be 24 hours.. if exceed null should come.. see for below details.
http://www.sqlservercentral.com/Forums/Topic1712715-391-1.aspx
query - http://sqlfiddle.com/#!3/386e2/1
Please who good in sql n exp person only apply. also verify this n make sure u can . then only apply please.
Thanks
Extra notes:
Dod it S.
100% (31)Projects Completed
43
Freelancers worked with
32
Projects awarded
35%
Last project
1 Apr 2021
India
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies