SQL View creation
- or -
Post a project like this$$
- Posted:
- Proposals: 25
- Remote
- #2048143
- Expired
Full stack Web Developer laravel|PHP| Wordpress|Graphics Design|Database| AJAX|REST API|C++ Programming ,
Chevy Chase
140459418756612288537228635422823942282113227516422728072272405211571420735652058333
Description
Experience Level: Intermediate
i have a SQL table with all dates in for a 10 year period and a column specifying whether it is a working day or not. i need a view that shows each date down the side and columns with the 1st, 2nd, 3rd, 4th and 5th working days immediately before and after it. the fields in the table are Calendar_Date (date field) and Working_Day (bit where 0 = false and 1 = true)
Charlie S.
100% (1)Projects Completed
3
Freelancers worked with
3
Projects awarded
50%
Last project
16 Feb 2021
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Charlie, Can you please describe the job in more details, also can you share column names of your tables?
-
Can you please describe in detail because it's not clear what you want. I understood the table structure. But I don't understand your requirement clearly. A lso, please specify that whether it is on SQL server.
661250661117
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