Did you read the part about posting DDL on SQL forums? Your useless picrure is not RDBMS, but the usual beginner's version of a dimensional schema. One of the basic...

I would take a completely different approach to this problem. Please Google articles on "nested sets model" or get a copy of my book on Trees and Hierarchies in SQL....

>> I need help with the query based on the following tables: <<

The table that Stores all the Tools we have to rent including some records [sic: rows are not...

Did you know that a table must have a key. by definition? What you posted can never have a key goes all the columns can be NULL! Furthermore, an identifier...

Instead of inventing your own personal date formats, why don't you use the ISO 8601 format instead? This is very popular in Scandinavian countries.

yyyyW[05][0-9]-[1-7]. It begins with the year is...

Your datatypes are completely wrong and your tables are simply disconnected badly done files with no relation to an RDBMS at all. You have no keys! Have you ever had...

>> I am old enough to remember when many large corporations implemented chargebacks. Essentially, each internal department was charged for their usage of IT systems, similar to how we are...

You're doing the wrong thing badly. You don't seem to know the table must have a primary key by definition; this is not an option! A row is not a...

>> So much for my dreams of the epic saga of the SELECT as told by the heroic defender of the faith... <<

I can write 1000-2000 words on the SELECT...

I do not use assembly language style bit flags at all. See; https://www.red-gate.com/simple-talk/sql/t-sql-programming/bit-of-a-problem/

>> As for #1 maybe go DM Joe Celko and ask what they considered it during his time working on ANSI standards. He'll probably have a lot of background if...

Is there any chance you could take the time to read a book on basic SQL and RDBMS? By definition, a table must have a key; this is not an...

The real answer, which you don't want to hear, is it any time you do any kind of rounding, you are going to get some error. You just have to...

Let's go back to square one. If you have a truly large, large database, then you might want to look at products that were designed to handle such creatures. Teradata...

Play with the idea of having a calendar table and then doing a set-oriented EXCEPT operator to find the missing dates and insert a row with the dummy values you...