En cours

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

Compétences : Serveur SQL Microsoft, SQL

Voir plus : need a flyer designed for a conference to be held in august i will provide images that i want part of the design and all the det, sql server 2000 script sql server agent jobs, day counter script, protect script sql injections, database country state city script sql, online banking system database script sql server, deal day tracking script, script sql 2005 backup, vb6 login script sql, pay per view video chat script, birthday script sql, tip day php script, random script sql, deal day website script, view myspace email script, java script scroll banner images, php script streaming webcam images, day deal script, increase view video count fake script, write script sql

Concernant l'employeur :
( 18 commentaires ) Sydney, Australia

N° du projet : #13091254

Décerné à :

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: [url removed, login to view] Plus

30 $ AUD en 0 jours
(36 Commentaires)
5.6

27 freelance ont fait une offre moyenne de 28 $ pour ce travail

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 Plus

70 $ AUD en 1 jour
(137 Commentaires)
6.4
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 Plus

30 $ AUD en 1 jour
(44 Commentaires)
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 en 1 jour
(13 Commentaires)
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 Plus

25 $ AUD en 0 jours
(37 Commentaires)
5.0
bhaveshghodasara

A proposal has not yet been provided

30 $ AUD en 2 jours
(7 Commentaires)
4.6
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 en 1 jour
(6 Commentaires)
4.0
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 Plus

15 $ AUD en 0 jours
(5 Commentaires)
3.9
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 Plus

14 $ AUD en 0 jours
(17 Commentaires)
3.7
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 = '' Plus

30 $ AUD en 1 jour
(2 Commentaires)
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 Plus

31 $ AUD en 1 jour
(2 Commentaires)
2.5
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 Plus

35 $ AUD en 1 jour
(2 Commentaires)
2.5
25 $ AUD en 1 jour
(1 Commentaire)
0.4
55 $ AUD en 1 jour
(0 Commentaires)
0.0
betinrx

A proposal has not yet been provided

35 $ AUD en 2 jours
(0 Commentaires)
0.0
nikhiluk

I see that you have sql [url removed, login to view] 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

35 $ AUD en 2 jours
(0 Commentaires)
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 [url removed, login to view] as EmpName, (select cast([url removed, login to view] as c Plus

10 $ AUD en 1 jour
(0 Commentaires)
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 en 1 jour
(0 Commentaires)
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 en 1 jour
(0 Commentaires)
0.0
jeyarajselvaraj

A proposal has not yet been provided

20 $ AUD en 1 jour
(0 Commentaires)
0.0
rsekar5787

Let me do this work

20 $ AUD en 1 jour
(0 Commentaires)
0.0