It's like this:
Expand|Select|Wrap|Line Numbers
- id (numeric, primary, not null, identity)
- number (varchar, Null)
- starttime (datetime, Null)
- endtime (datetime, Null)
- description (varchar, Null)
- subcategory (varchar, Null)
- category (varchar, Null)
- priority (varchar, Null) - Field is either Priority or Non-priority
Display any records that conflict with only Non-priority conflict based on: priority based on the time of day and subcategory
Example: 234567 would conflict with 123456:
Expand|Select|Wrap|Line Numbers
- Display any records that conflict only Non-priority conflict based on: priority based on the time of day
- Example: 234567 would conflict with 123456:
- Number Starttime Endtime Priority Category Subcategory
- 123456 00:00:00 05:00:00 YES ABC 15
- 234567 02:00:00 04:00:00 NO ABC ABC
- 245368 06:00:00 08:00:00 NO ABC 12
- I'd like to output it like this:
- Number Starttime Endtime Priority Category Subcategory Conflicts_with
- 234567 02:00:00 04:00:00 NO ABC ABC 123456