A site may not have a school or it may be a non-District school. The sitecode in the LocationTable must be compared to the sitecode in the Schools table to...

But I need the School table to tell me if the site at which a student is located is a valid school site or not. Remember, the location of the...

declare @StudentLocation (StudID int, SiteCode int, InDate datetime, OutDate datetime)

insert @StudentLocation

               select 12345,1, '01/03/06','02/14/06'

               union all select 12345,2,'02/15/06','03/14/06'

               union all select 12345,5,'03/15/06', '05/21/06'

declare @DistrictSchool (SchoolID, SchoolName,SiteCode)

insert @DistrictSchool

                select 111, 'School...

Say, for example, Student A was enrolled in a District school on Jan. 3. He attended that school until 2/18, at which time he was sent to Site B (a...

A student may be at a site and not in school. He may also be at a site and in school, but not a District school.

Haven't tried anything yet -...