more of a SQL question then a ADO question

Bill N

Delphi Developer

Fri, 11 Mar 2005 07:37:44 GMT

more of a SQL question then a ADO question

I have a table that holds appointments. I have the fields
StartFrom,EndPeriod (TDateTime) and RmID (foreign field to the table
tblResources). Does anyone know the SQL or procedure if I have two
TDateTime values (start and end periods) for a ResourceID and I want to
check and see if there's a conflicting time?

Brian Bushay Team

Delphi Developer

Fri, 11 Mar 2005 11:00:35 GMT

Re:more of a SQL question then a ADO question

Quote

>I have a table that holds appointments. I have the fields
>StartFrom,EndPeriod (TDateTime) and RmID (foreign field to the table
>tblResources). Does anyone know the SQL or procedure if I have two
>TDateTime values (start and end periods) for a ResourceID and I want to
>check and see if there's a conflicting time?

Try something like this.

Select D.rmId from Tbl D
Join Tbl D2 on (D.Startfrom Between D2.Startfrom and D2.EndPeriod)
or (D.EndFrom Between D2.Startfrom and D2.EndPeriod)
where D.Rmid <> D2.Rmid
--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Other Threads

1. QUESTION ABOUT ADO STORED PROCEDURES AND SQL SERVER 2000

2. SQL question with ADO

3. DELPHI ADO & MS SQL 2000 Requery question

4. Question for advance user : ADO and prepared properties with SQL 7

5. ADO/SQL Server question

6. QUESTION ABOUT ADO STORED PROCEDURES AND SQL SERVER 2000

7. Question for advanced users : ADO and prepared properties with SQL 7

8. D2/BDE-SQL UPPER() question, and Union query question

9. Newbie ADO question - Oracle & ADO

10. Questions, questions, and more questions...