Can you clarify what the result of the query means? 
I just need to know if there are enough items to assign to the bookings. I dont't see immediately how...

okay, in my sample there are only 8 rows (or bookings) but of course in real life this will be much more. If you want to make it more clear...

I could also assign item 2 on row 6, item 3 on row 7, and item 4 on row 8. But that gives the same result, 4 booked items, so...

The goal is to determine is a user can make a reservation for equipment for a certain period, based on the availability of items.
Some bookings (rows in the...

Correction: the sample setup is here

create table items (item_id int identity(1,1) primary key
, item_name varchar(50))

--table with part-set (child-parent) relations, with date for...

So to be clear: I need the parts of set A on any given date, and parts of those parts, etc... with a full path name, delimited with backslash like...

Can I make it a bit more complex now?
In my sample I made two table, one with the sets and one with the parts. In my real live application...

This is exactly what I needed... I tested it and it works as it should, thanks!

Small question, I notice that you write the date as 20170101 where as...

Found a very simple solution to my problem...

create procedure stp_test (@only_this_record int)

as

begin

select * from test where (field1=1) and ...etc...

and (id=@only_this_record or @only_this_record=0)

end

Thanks for this advice...

Learning every day!

After a while, execution from dotnet worked fast as well.

I haven't experienced this before...

Sorry to bother you all, my issue is solved (don't know the reason though)...

This is the code that runs the SP.

parameter glbSQL_connection is the SQL connection

and SQL is the SP = 'EXEC stp_InventoryItemTypes_UpdatePathNamesOfChildren 1'

Dim oSQLcommand As SqlCommand = New SqlCommand(SQL, glbSQL_connection)

Try

...

okay, I will, but if okay with you I will use my live db table and field names (sorry for the cryptic names).

If you prefer the earlier sample names, I...

On the sample data their were no indexes indeed, but on the db I tested the solutions, there are indexes on the currency id and on the date...

The indexes are okay. In any case the db is the same in both tests...