How to mass add standards into the SBR table from a spreadsheet


1. Prepare the data 

  • Required fields: SD, CN
  • Additional SBR fields can be included but are optional


2. Create a temp table with the data to import

  • Import spreadsheet via wizard or create a new table and paste in the values


3. Insert the records from the temp table into SBR

Example: 

INSERT SBR (SD, CN, RC)
SELECT DISTINCT SD, CN, 1
FROM SBR_IMPORT
WHERE SD NOT IN (SELECT SD FROM SBR WHERE CN = SBR_IMPORT.CN)
SQL

Inserting SD and CN from the temp table, 1 in RC for all records to indicate all standards will be included on report card.