Hello - I would like a script that will create a 7 day view of all jobs I have by location.
At the moment, my jobs are shown as transactions in my database (1 for each day). In my software, the user can pick a location and start date, and I want the script to present a 7 day view for a specific location listed by employee.
See images of what I need.
The user will select a specific location and a start date.
Using these inputs, the view will show:
Column 1 - (Employee Name) - list of all employees rostered at that location
Column 2 - Selected Date + 0
Column 3 - Selected date + 1
Column 3 - Selected date + 2
Column 3 - Selected date + 3
Column 3 - Selected date + 4
Column 3 - Selected date + 5
Column 3 - Selected date + 6
If employee is not rostered on a particular day then just leave the value as blank
27 freelanceria on tarjonnut keskimäärin 28 $ tähän työhön
Hi, I am SQL expert. It could be done via stored procedure or single SQL statement. Recommended first case. Second will utilize a lot of CPU resources. To start I need export of your data.
I have 7+ years of experience in database/datawarehouse design and development. My Key skill are: Data modeling Database development performance tuning PL/SQL, SQL server SSIS Shell scripting
I deal with Pivot tables on a daily basis this one is a breeze. Less then a days work. the only question is do you want it as a report (SSRS) which would allow you to added filters and drill through functionality.