General information
Forum:
Microsoft SQL Server
Title:
SQL Statement How To
Environment versions
SQL Server:
SQL Server 2005
We are working on a teacher certification project and need to be able to track each students level through the program. We have written SQL statements that can determine what students have achieved each level. Is there a way I can check each subquery in sequence to determine the current level for each student. For example if the student is found in the level five query I know they are level five and I can end my search. Otherwise I need to check for their existence in each of the other level queries (Level 3, Level 2, and Level 2). I would like to have one SQL statement in the end that simply returns the students id and current level. Is this possible?
Thanks In Advance
Jeff Hibbs
The Blencowe Group
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only