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!

Recent content by Julio Herrera

  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