Suoritettu

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

Tietoa työnantajasta:
( 18 arvostelua ) 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: [login to view URL] Lisää

$30 AUD 0 päivässä
(36 Arvostelua)
5.6

27 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% 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ä
(137 arvostelua)
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 Lisää

$30 AUD 1 päivässä
(44 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ä
(37 arvostelua)
5.0
bhaveshghodasara

A proposal has not yet been provided

$30 AUD 2 päivässä
(7 arvostelua)
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 1 päivässä
(6 arvostelua)
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 Lisää

$15 AUD 0 päivässä
(5 arvostelua)
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 Lisää

$14 AUD 0 päivässä
(17 arvostelua)
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 = '' 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
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ä
(2 arvostelua)
2.5
$25 AUD 1 päivässä
(1 arvostelu)
0.4
$55 AUD 1 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
nikhiluk

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

$35 AUD 2 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 [login to view URL] as EmpName, (select cast([login to view URL] as c Lisää

$10 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
jeyarajselvaraj

A proposal has not yet been provided

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

Let me do this work

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