GETDATE() AS [date],
T.transportationID
FROM Person P
JOIN Enrollment E ON E.PersonID = P.PersonID AN... cords exist
IF EXISTS (SELECT 1
FROM Person P
JOIN Enrollment E ON E.PersonID = P.Per... ode sql>
--Update StudentNumber to PersonID where person has an active enrollment record and has a NULL student number.
UPDATE Person
SET studentNumber = P.personID
FROM Person P
JOIN