Comparing queries for flagging conflicts

[Alpay Eno]

Hello all... I'm stuck, I cannot figure out how I should go about flagging
conflicts on a sheduling app. I currently have 8 columns (school grades)
that have class over the course of 9 periods. I am populating the asp page
fine, and making changes to the database with forms lists. I need to compare
all the results of one period (thats 8 results) so that i may find a
classroom conflict. Is there any solution in SQL?

This is my query:
sql = "SELECT * FROM schedule WHERE period ='"&num&"'"
I step through this 9 times in a for/next loop

Thanks in advance!
Alpay Eno

[Erland Sommarskog]

Alpay Eno (en*@spamsux.com) writes:

Hello all... I'm stuck, I cannot figure out how I should go about
flagging conflicts on a sheduling app. I currently have 8 columns
(school grades) that have class over the course of 9 periods. I am
populating the asp page fine, and making changes to the database with
forms lists. I need to compare all the results of one period (thats 8
results) so that i may find a classroom conflict. Is there any solution
in SQL?

Dunno. If you post:
o CREATE TABLE statement(s) for the involved table(s)
o INSERT statements with sample data
o The desired output from that sample data

there are odds that you will get a more precise answer.

--
Erland Sommarskog, SQL Server MVP, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp