Concluído

SQL Server Stored Proc Date Parameters

We need a date range capability added to a SQL Server 2000 Stored Procedure (sp_IntelReport) from the attached database. It needs to do the following: Restrict selection from tblBookings on Booking_Start field if any of the following are true: 1. if Quarter_ID not equal to Zero then: Look up the record in tblQuarters. Take the Quarter_Number (1 - 4) and Year values. It should use these values to set the date range. iStart_Month (1-12) tells it which month the year starts on. So for example, if iStartMonth is 4 (April) and Quarter_Number is 1 and Year is 2003 then the date range would be: >= April 1st 2003 and < July 1st 2003 2. Otherwise, if iYear_ID other zero then it again needs to look at iStartMonth. If Year is 2003, and iStartMonth is 4 then the range would be >=April 1st 2003 and

## Deliverables

1) Complete and fully-functional stored procedure 2) Complete ownership and distribution copyrights to all work purchased.

## Platform

SQL Server 2000

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

Veja mais: stored, SQL Server, sql server c, ProC, engineering selection, date, c sql server, php sql 2000, engineering year, SQL stored, stored proc sql, zero distribution, sql 2000, sql server stored proc, work sql server, php sql record, date selection php, sql procedure, sql server 2000, sql server database

Acerca do Empregador:
( 165 comentários ) Tampa, United States

ID do Projeto: #2943114

Concedido a:

krymar

See private message.

$25.5 USD em 14 dias
(13 Comentários)
3.7

2 freelancers estão ofertando em média $32 para esse trabalho

vw813539vw

See private message.

$38.25 USD in 14 dias
(13 Comentários)
4.2