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 freelance font une offre moyenne de $28 pour ce travail
Hello there, i'm expert on TSQL, let me help you with this. Pls share me your table with data, actually this one is similar to calculate the shift time i've done before to calculate the total number of hours. Waiting f Plus
Hi I am a database expert with 12 years experience in handling MS SQL databases. I have worked as DBA for large ERP databases and use to write and do performance tuning for SQL queries, procedures and triggers. F Plus
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.
Hi, I have gone through your project details and would like to take an opportunity to work on it. Being experienced in working on SQL queries extensively and working on it professionally, I can help you with the qui Plus
hi I can help you writing the sql server query you need, only need the table structure and 10 records. best regards
Hi, I am a professional SQL expert with over 3 years of experience. I have read your request and interested to work for you as I am expert of SQL and can create this script for you very professionally. I have written m Plus
SELECT EMPLOYEENAME, GETDATE() DATE0, DATEADD(DD, 1, GETDATE()) DATE1, DATEADD(DD, 2, GETDATE()) DATE2, DATEADD(DD, 3, GETDATE()) DATE3, DATEADD(DD, 4, GETDATE()) DATE4, DATEADD(DD, 5, GETDATE()) DATE5, DATEADD(DD, 6 Plus
Hi, It's a complex query and u must do it with unions. Something like that Select EmployName, SelectedDate = cast(StartTime as varchar(20)) + '-' + cast(EndTime as varchar(20)), PlusOneDay = '' Plus
Hi, I am a .NET developer and I can complete your project. As I understand, you need this script implemented in excel so you only enter location, and based on location you get report in excel? Please contact me Plus
I see that you have sql [login to view URL] why not SSRS report? This is very easy to setup ssrs report and 7 days report page can easily create and associate with your existing site. We can also setup multiple reports if you Plus
Hello You can use next but only change sysdate on Your date var and 'Zet%apart%' on Your Joblocation var and continie select for next days, welcome... Select [login to view URL] as EmpName, (select cast([login to view URL] as c Plus
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.