Project Detail

SQL 2000 simple stored procedure  

SQL 2000 simple stored procedure is project number 365798
posted at Freelancer.com. Click here to post your own project.

 

| More Free Trial For New Buyers
 

Status:

Selected Providers: tamrakar

Budget: $30-250

Created: 01/05/2009 at 12:19 EST

Bid Count: 19

Average Bid:
$ 63

01/06/2009 at 12:19 EST

Project Creator: kaostech
Employer Rating: 10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10 (3 reviews)

Bid On This Project
 

Description

I need an optimum SQL that use the following table data (SQL Server 2000):

Hotel reservations table:

Reservations_tbl:
(field : type: size)
- datestart: datetime : 8
- dateend: datetime : 8

datestart = reservation first day
dateend = reservation last day
each record is ONE room occupied.

I need a stored procedure that receive two parameters:

DateFrom : String: (mm/dd/yyyy)
DaysExeptiom: Numeric, int

And return:
the lowest number of rooms used from ((DateFrom)) and ((DaysExeptiom)) days BACK
for example:
the lowest number of rooms used from January 31 and 60 days BACK (Jan 31, 2009 & December 3rd 2008)
it means:
search the day when are occupied less rooms, and return the number of rooms.

Messages Posted:0 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

 

75

0 days

01-05-2009 13:32 EST

get it done... Thanks

help

 

39

0 days

01-05-2009 15:04 EST

See private message

help

 

30

0 days

01-05-2009 12:43 EST

Expert in SQL Script development.. Please have a look at my reviews... Regards C.Rajesh B.E

help

 

30

0 days

01-05-2009 12:53 EST

Hi... i have expert knowledge in SQL stored procedures.. Please check PM...

help

 

250

2 days

01-05-2009 13:03 EST

Can help... check my reviews...

help

 

50

1 day

01-05-2009 14:40 EST

Hi, Expert Computer Engineer in Database Designing and sp, function, Can Start Work on Immediately effect. Thanx

help

 

50

2 days

01-05-2009 14:04 EST

Hello Sir Please check PMB...

help

 

30

0 days

01-05-2009 13:58 EST

I help you fast. Let's accept this bid and you will receive SP. Thank you. All the best in NEW YEAR. :-)

help

 

30

1 day

01-05-2009 14:24 EST

sir,i can do it

help

 

100

15 days

01-05-2009 12:42 EST

(No Feedback Yet)

Hi I worked as Performance Consultant for DB2 in a top MNC.I have IBM DB2 and Brain bench DB2 certification. I have used advanced SQL queries and concepts in many projects. Waiting for your reply.

help

 

100

3 days

01-05-2009 14:47 EST

(No Feedback Yet)

Write the stored procedure and provide the code. When executed, the procedure returns a number

help

 

30

1 day

01-05-2009 13:13 EST

(No Feedback Yet)

Simple job. Please check the PM

help

 

30

1 day

01-05-2009 13:20 EST

(No Feedback Yet)

Simple you, send me pm. Senior Software Developer here.

help

 

75

10 days

01-05-2009 13:33 EST

(No Feedback Yet)

Hi Can write this SQL for you. Just give me some data for testing.

help

 

100

1 day

01-05-2009 13:35 EST

(No Feedback Yet)

Hello; I can do this job, i have already did it, and i can also provide you assistance if needed on the futur. I can start when you want and i'll deliver a clean work in one day exactly. Thanks. Anas

help

 

30

0 days

01-05-2009 14:21 EST

(No Feedback Yet)

Hi , It is ready . Please check PMB . Thanks Raj

help

 

30

2 days

01-05-2009 15:29 EST

(No Feedback Yet)

We have looked into your requirement and started analysing it.However we need some more info on the same. Have expertise in sql 2000 and 2005.While writing the procedure, We not only concentrate on the query but also on the performance.

help

 

50

1 day

01-05-2009 15:38 EST

(No Feedback Yet)

I can do it. I'm database administrator/developer with 9 years.

help

 

60

2 days

01-05-2009 16:13 EST

(No Feedback Yet)

Hi, I give you 2 days, because it will take approximately one day with its tests but before I have to prepare the db environment and test data. If you provide the data structure and test data it will take max. about one day. Regards

help


    Bid on this Project