ETDATE(),101)
SELECT DISTINCT
@date AS mydate,
p.studentnumber AS StudentDistrictID,
i.ssn AS StudentSSN,
p.stateID AS StudentStateID,
CASE WHEN e.enddate < GETDATE() THEN 0 ELSE 1 END StudentEnrollmentStatus
====== Wagner Portrait Group ======
===== Students =====
<code sql>
WITH S AS (
SELECT P.personID,P.studentNumber AS studentNumber,I.firstName,I.lastName,E.grade
FROM Person P
JOIN Enrollment E ON P.personID = E.pe... S NULL AND guardian = 'true'
),
HR AS (
SELECT SH.studentPersonID, SH.teacherDisplay
FROM v_StudentHomeroom
ID
FROM cust.transportation_comments tc
LEFT JOIN StudentNumberHistory snh ON snh.active = 1 AND tc.id = snh.studentNumber
CROSS JOIN
(
SELECT attributeID
FRO