Käynnissä

SQL Script to present 7 day view of my jobs

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

Taidot: Microsoft SQL Server, SQL

Näytä lisää: day counter script, protect script sql injections, deal day tracking script, script sql 2005 backup, vb6 login script sql, birthday script sql, tip day php script, random script sql, deal day website script, view myspace email script, day deal script, write script sql

About the Employer:
( 18 reviews ) Sydney, Australia

Projektin tunnus: #13091254

Myönnetty käyttäjälle:

mahmoudgamal008

What you are trying to do is called "Pivot", I have write a lot of SQL Server pivot queries, you can browse sample of them here in this link: http://stackoverflow.com/search?q=user%3A722783+%5Bsql-server%5D%5Bpivot%5D Lisää

30 $ AUD 0 päivässä
(30 arvostelua)
5.4

28 freelanceria on tarjonnut keskimäärin 28 $ tähän työhön

truongnguyen86

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 Lisää

70 $ AUD 1 päivässä
(129 arvostelua)
6.3
codetod

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 Lisää

30 $ AUD 1 päivässä
(40 arvostelua)
5.7
realsoftwareltd

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.

25 $ AUD 1 päivässä
(13 arvostelua)
5.1
mail2vimalarora

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 Lisää

25 $ AUD 0 päivässä
(30 arvostelua)
4.9
bhaveshghodasara

A proposal has not yet been provided

30 $ AUD 2 päivässä
(7 arvostelua)
3.5
vw7590795vw

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 Lisää

14 $ AUD 0 päivässä
(10 arvostelua)
3.3
marko04

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 = '' Lisää

30 $ AUD 1 päivässä
(2 arvostelua)
3.4
mladenmp

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 Lisää

31 $ AUD 1 päivässä
(2 arvostelua)
2.5
farrukhcheema23

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 Lisää

15 $ AUD 0 päivässä
(1 arvostelu)
2.3
abhishekmodgi

I have 5 years of experaince as a web application developer developing web application using C# asp.net Sql.I have worked on html5 css3,javascript related libraries,angular js and jquery for past 2 years and have a goo Lisää

35 $ AUD 1 päivässä
(1 arvostelu)
1.0
solucionesnet

hi I can help you writing the sql server query you need, only need the table structure and 10 records. best regards

25 $ AUD 1 päivässä
(1 arvostelu)
0.8
25 $ AUD 1 päivässä
(1 arvostelu)
0.4
teresa123456

Hi!! I am learning sql and I would like to help you with this issue in order to practice. I am not sure if I will be able to do it but I would like to try.

25 $ AUD 1 päivässä
(0 arvostelua)
0.0
lodiii

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 t2.EmpName as EmpName, (select cast(t3.starttime as c Lisää

10 $ AUD 1 päivässä
(0 arvostelua)
0.0
nikhiluk

I see that you have sql server.Then 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 Lisää

35 $ AUD 2 päivässä
(0 arvostelua)
0.0
betinrx

A proposal has not yet been provided

35 $ AUD 2 päivässä
(0 arvostelua)
0.0
ecarrillo01

A proposal has not yet been provided

35 $ AUD 1 päivässä
(0 arvostelua)
0.0
55 $ AUD 1 päivässä
(0 arvostelua)
0.0
vksdwivedi9

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

27 $ AUD 1 päivässä
(0 arvostelua)
0.0
Hemant1963

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.

35 $ AUD 1 päivässä
(0 arvostelua)
0.0