Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Julio Herrera

    Query with recursive subquery does not work

    Hi SkipVought,- Week_of_sale means the week of the year the reservation was sold, covering 2 years in advance. For example, a stay for 2020-11-14 (yyyy-mm-dd) sold on 2019-10-10 will have Week_of_sale = 41. Same stay sold on 2020-05-05 will have Week_of_sale = 70. That is why Week_of_sale...
  2. Julio Herrera

    Query with recursive subquery does not work

    Hello, I am a new member of the Forum, and I would be grateful if someone could help me out. I have a table (Reservation_line) with 3 meaningful columns (for this question): Date_of_stay, Week_of_sale, Number_of_rooms. This table has data of hotel reservations for somes dates of two years and...

Part and Inventory Search

Back
Top