Devam Ediyor

sql DATE query should be simple

I just can't get my head around this ...

Customers can book apartments online these are stored in a table [tblNoBooking] the second table tells us how many apartments there are of each type [tblRoomTypes] for example there maybe 6 2 bedroom apartments.

What I NEED is an SQL and/or asp code which looks up and tells me how many apartments are left based on a simple form which is

startDate and endDate of period

The query needs to show all 4 apartments and the number of apartments left

The form posts is request("from") request("to")

Beceriler: ASP

Daha fazlasını görün: sql get date, n query, online sql, on sql, date online, sql code, sql c, sql based, simple query, query table, how should, bedroom, sql maybe, sql stored, type date, online query, date show, simple based, form simple, code simple, simple sql, simple type, need sql query, asp table, type book

İşveren Hakkında:
( 3 değerlendirme ) Worthing, United Kingdom

Proje NO: #206707

Seçilen:

exitsol

Lets get started

0 gün içinde 30$ USD
(4 Değerlendirme)
2.7

2 freelancer bu iş için ortalamada 45$ teklif veriyor

animeshtyagi

I have more than 5+ years and developed more than 50 E-Commerce sites. Quality is a way of life - we ensure that there is quality work at every step. I shall continuously strive to exceed the expectations of our cu Daha fazlası

1 gün içinde 60$ USD
(3 Değerlendirme)
3.1