Cancelado

MSSQL Date Ranges to Date Lists

I need some MS-SQL query or stored procedure that lists the number of workdays given two inputs: 1) Timeperiods (From, To) 2) Misc. Holiday Dates Example Input: Table 1: Vacation: varchar DateFrom: datetime DateTo: datetime sample record: vacation, datefrom, dateto xmas-vacation, 2009-12-21, 2009-12-27 Table 2: HolidayDesc: varchar HolidayDate: datetime sample record: holidaydesc, holidaydate xmas-1, 2009-12-25 xmas-2, 2009-12-26 Expected result should be a table containing all workdays of the period from table 1 (e.g. no sat and sun) and excluding the dates from table 2 that fall into the period. Result Table: Desc: varchar Date: datetime Sample Result Desc, Date x-mas vacation, 2009-12-21 x-mas vacation, 2009-12-22 x-mas vacation, 2009-12-23 x-mas vacation, 2009-12-24

## Deliverables

1) Complete and fully-functional working program(s) in complete source code of all work done.

2) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

MS-SQL 2005

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

Ver mais: vacation work engineering, vacation engineering, sun source, i need to hire sql, hire date, hire a date, date of hire, date for hire, MAS, date, mssql stored, datetime, query mssql, mssql procedure, engineering inputs, mssql php, period dates, program date, stored procedure mssql, mssql example, buyer lists, sql query date, sample program record, php holiday site, mssql site

Acerca do Empregador:
( 1 comentário ) Switzerland

ID do Projeto: #3003335

35 freelancers estão ofertando em média $33 para este trabalho

schandraram

See private message.

$21.25 USD in 2 dias
(149 Comentários)
6.9
sinharavi

See private message.

$12.75 USD in 2 dias
(78 Comentários)
6.0
expertechie

See private message.

$29.75 USD in 2 dias
(85 Comentários)
5.8
Andreena

See private message.

$63.75 USD in 2 dias
(261 Comentários)
5.9
slavisatosic

See private message.

$20.4 USD in 2 dias
(108 Comentários)
5.9
KentScandrett

See private message.

$17 USD in 2 dias
(24 Comentários)
5.4
reinso

See private message.

$21.25 USD in 2 dias
(59 Comentários)
5.6
shahidbabar

See private message.

$25.5 USD in 2 dias
(33 Comentários)
5.1
eastcoastjoevw

See private message.

$51 USD in 2 dias
(25 Comentários)
5.0
VedAlek

See private message.

$17 USD in 2 dias
(53 Comentários)
5.3
Robotapps

See private message.

$72.25 USD in 2 dias
(92 Comentários)
5.4
aadverbsfi

See private message.

$42.5 USD in 2 dias
(42 Comentários)
4.8
csharpsourcescom

See private message.

$17 USD in 2 dias
(32 Comentários)
4.6
wesolvevw

See private message.

$12.75 USD in 2 dias
(54 Comentários)
4.8
scsBiswas

See private message.

$17 USD in 2 dias
(35 Comentários)
4.8
vw7258315vw

See private message.

$51 USD in 2 dias
(48 Comentários)
4.7
showm3urluvvw

See private message.

$71.4 USD in 2 dias
(21 Comentários)
4.1
lwl0606

See private message.

$17 USD in 2 dias
(19 Comentários)
3.8
richardmonahan

See private message.

$85 USD in 2 dias
(5 Comentários)
3.8
bucktracker

See private message.

$50.15 USD in 2 dias
(26 Comentários)
4.2