Lengkap

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

Kemahiran: Pelayan Microsoft SQL, SQL

Lihat lagi: 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, sql, microsoft sql server, 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

Tentang Majikan:
( 18 ulasan ) Sydney, Australia

ID Projek: #13091254

Dianugerahkan kepada:

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] Lagi

$30 AUD dalam 0 hari
(36 Ulasan)
5.6

27 pekerja bebas membida secara purata $28 untuk pekerjaan ini

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 Lagi

$70 AUD dalam sehari
(137 Ulasan)
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 Lagi

$30 AUD dalam sehari
(44 Ulasan)
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 dalam sehari
(13 Ulasan)
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 Lagi

$25 AUD dalam 0 hari
(37 Ulasan)
5.0
bhaveshghodasara

A proposal has not yet been provided

$30 AUD dalam 2 hari
(7 Ulasan)
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 dalam sehari
(6 Ulasan)
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 Lagi

$15 AUD dalam 0 hari
(5 Ulasan)
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 Lagi

$14 AUD dalam 0 hari
(17 Ulasan)
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 = '' Lagi

$30 AUD dalam sehari
(2 Ulasan)
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 Lagi

$31 AUD dalam sehari
(2 Ulasan)
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 Lagi

$35 AUD dalam sehari
(2 Ulasan)
2.5
$25 AUD dalam sehari
(1 Ulasan)
0.4
$55 AUD dalam sehari
(0 Ulasan)
0.0
betinrx

A proposal has not yet been provided

$35 AUD dalam 2 hari
(0 Ulasan)
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 Lagi

$35 AUD dalam 2 hari
(0 Ulasan)
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 Lagi

$10 AUD dalam sehari
(0 Ulasan)
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 dalam sehari
(0 Ulasan)
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 dalam sehari
(0 Ulasan)
0.0
jeyarajselvaraj

A proposal has not yet been provided

$20 AUD dalam sehari
(0 Ulasan)
0.0
rsekar5787

Let me do this work

$20 AUD dalam sehari
(0 Ulasan)
0.0