Sedang Disiapkan

SQL 2000 simple stored procedure

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.

Kemahiran: Pemasukan Data, Pemprosesan Data, Visual Basic

Lihat lebih lanjut: int size, stored procedure reservation sql, sql 2000 stored producre, stored, sql c, reservations, numeric, mm, int, simple reservation, simple reservation means, last days sql, datetime, amp sql, simple use, simple hotel, server sql, stored amp sql, hotel table data, simple hotel reservation, sql stored, string processing, lowest days, reservation table, january

Tentang Majikan:
( 5 ulasan ) Cochabamba, Bolivia

ID Projek: #365798

Dianugerahkan kepada:

tamrakar

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

$30 USD dalam 0 hari
(0 Ulasan)
0.0

19 pekerja bebas membida secara purata $63 untuk pekerjaan ini

lightcresent

get it done... Thanks

$75 USD dalam 0 hari
(27 Ulasan)
6.2
lavr

See private message

$39 USD dalam 0 hari
(17 Ulasan)
5.1
crajeshbe

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

$30 USD dalam 0 hari
(14 Ulasan)
4.4
YashpalSingh123

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

$50 USD dalam sehari
(2 Ulasan)
4.0
visu14

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

$30 USD dalam 0 hari
(6 Ulasan)
3.4
ranganathp

Can help... check my reviews...

$250 USD dalam 2 hari
(1 Ulasan)
3.0
ProExpert

Hello Sir Please check PMB...

$50 USD dalam 2 hari
(2 Ulasan)
1.9
pitaji

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.

$100 USD dalam 15 hari
(0 Ulasan)
0.0
insis2004

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

$50 USD dalam sehari
(0 Ulasan)
0.0
WebProducts

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

$30 USD dalam 2 hari
(0 Ulasan)
0.0
Sindesigns

sir,i can do it

$30 USD dalam sehari
(0 Ulasan)
0.0
TheCodeMan

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

$75 USD dalam 10 hari
(0 Ulasan)
0.0
jzevakin

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

$30 USD dalam 0 hari
(0 Ulasan)
0.0
anasdev

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

$100 USD dalam sehari
(0 Ulasan)
0.0
smylavarapu

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

$100 USD dalam 3 hari
(0 Ulasan)
0.0
eduardo74

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

$30 USD dalam sehari
(0 Ulasan)
0.0
alextp

Simple job. Please check the PM

$30 USD dalam sehari
(0 Ulasan)
0.0
fnuran

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

$60 USD dalam 2 hari
(0 Ulasan)
0.0