#20 auto class rosters update

[Mark Inmon]

Originator MAHC Administrator

Issue – auto class rosters update

Description – the education dept. at MAHC requested
that the class manager update the roster with the
personnel required taking the class. This will save a lot
of time for them by not having to update the roster one
person at a time.

Example – This query is for a class that all officers are
required to take. You can modify it to suit your needs.
Huge thanks go out to IACH administrator for his help on
this turning my on the right path.

INSERT INTO mepsdata.dbo.events (ssn, class, instrpot,
status, credtype, changedby, approved)

SELECT
vatz, 164, 0, 'enrolled', 19, '3001', 1

FROM personnel INNER JOIN rank on personnel.rank =
rank.rankid WHERE officer=1 AND departed=0