ate AS DATE) AS startDate,D.districtID
FROM CustomStudent CS
JOIN CampusAttribute CA ON CA.attributeID = CS... OLR.
UPDATE PP
SET endDate = GETDATE()
FROM CustomStudent CS
JOIN CampusAttribute CA ON CA.attributeID = CS... ate AS date) AS startDate,D.districtID
FROM CustomStudent CS
JOIN CampusAttribute CA ON CA.attributeID = CS... OLR.
UPDATE PP
SET endDate = GETDATE()
FROM CustomStudent CS
JOIN CampusAttribute CA ON CA.attributeID = CS