Hi Guys, Thanks for your responses... I have generalised the issue to make it more readable ...

The Reservation(actual name Requirement) Table def looks like this

ID [uniqueidentifier],

Kind [nvarchar] 255 Not...