Em Andamento

MS-SQL - Stored Procs - Scheduling

I need Three MS-SQL StoreProcedures (see Deliverables): 1. cw_Schedule_DailySchedules(JobOrderID, ScheduleID, ContractEndDate) 2. cw_Schedule_WeeklySchedules(JobOrderID, ScheduleID, ContractEndDate) 3. cw_Schedule_MonthlySchedules(JobOrderID, ScheduleID, ContractEndDate) These store procedures will pull existing information from an existing "Schedules" Table and populate another table JobSchedulingStartTimes with actual start times based on the Schedule patterns - no further out (datewise) than the the ContractEndDate. The output of these procedures will put a JobSchedulingStartTime DATETIME and JobOrderID INT into the JobSchedulingStartTimes Table. Example output: StartTime (DateTime), JobOrderID int '2003-11-12 13:11:19.187', 444 '2003-12-02 03:11:19.187', 443 '2003-11-12 13:11:19.187', 443 '2003-12-02 03:11:19.187', 441

## Deliverables

Deliverables: Complete ownership and distribution copyrights to all work purchased. I need Three MS-SQLStoreProcedures: 1. cw_Schedule_DailySchedules(JobOrderID, ScheduleID, ContractEndDate) 2. cw_Schedule_WeeklySchedules(JobOrderID, ScheduleID, ContractEndDate) 3. cw_Schedule_MonthlySchedules(JobOrderID, ScheduleID, ContractEndDate) The outputted Data will put into a new SQL Table and contain the following fields: StartTime (DateTime), JobOrderID int '2003-11-12 13:11:19.187', 444 '2003-12-02 03:11:19.187', 443 '2003-11-12 13:11:19.187', 443 '2003-12-02 03:11:19.187', 441 In addition the attached zip has SQLscripts for the Tables, "Schedule [url removed, login to view]" for explaining the test cases and field relevancy, and a Schedule Example Excel sheet with 4 worksheets that corespond to the 4 test cases/rowsets for the input table.

## Platform

Platform: Windows 2000 Server Microsoft SQL Server 2000

Habilidades: Engenharia, MySQL, PHP, Arquitetura de software, Teste de Software, SQL

Ver mais: microsoft excel test, test sql server, stored, stored procedures, sql microsoft, MS SQL, MICROSOFT SQL SERVER, excel with sql server, excel to sql, php sql 2000, datetime, output tables php, SQL Server Stored Procedures, php schedule output, scheduling excel, SQL stored, php sql txt, data excel sheet test, txt table php, pull data sql, input data engineering, excel bid scheduling, sql txt, sql 2000, sql procedures

Acerca do Empregador:
( 1 comentário ) United States

ID do Projeto: #3009698

Premiar a:

ananyavb

See private message.

$76.5 USD em 4 dias
(5 Avaliações)
2.3

7 freelancers estão ofertando em média $50 para este trabalho

quipusoft

See private message.

$42.5 USD in 4 dias
(6 Comentários)
3.7
visualtechvw

See private message.

$63.75 USD in 4 dias
(4 Comentários)
3.1
dspott

See private message.

$24.65 USD in 4 dias
(1 Comentário)
2.6
ashahawy

See private message.

$25.5 USD in 4 dias
(3 Comentários)
0.0
dominikvw

See private message.

$76.5 USD in 4 dias
(0 Comentários)
0.0
sevenbyteson

See private message.

$42.5 USD in 4 dias
(0 Comentários)
0.0