Insert values into the table
TABLE [dbo].[TRAINING] int IDENTITY(1,1) NOT NULL,varchar(50) NULL,text NULL,char(1) NULL,varchar(8) NULL CONSTRAINT [DF_TRAINING_DISPLAY_STATUS] DEFAULT ('ACTIVE'),CONSTRAINT [PK_TRAINING] PRIMARY KEY([TRAINING_ID]) TABLE [dbo].[PARENT_GUARDIAN] int IDENTITY(150,1) NOT NULL,nvarchar(25) NOT NULL,nvarchar(25) NOT NULL,CONSTRAINT [PK_PARENT_GUARDIAN] PRIMARY KEY([PG_ID]) TABLE [dbo].[xref_PG_TRAINING] int NOT NULL,int NOT NULL,datetime NOT NULL INTO PARENT_GUARDIAN (PG_FNAME, PG_LNAME) ('Dean','Barker') INTO PARENT_GUARDIAN (PG_FNAME, PG_LNAME) ('Frank','Purdue') INTO PARENT_GUARDIAN (PG_FNAME, PG_LNAME) ('John','Cummings') INTO TRAINING (TRAINING_NAME,TRAINING_DESC, MANDATORY) ('Youth Protection','Blah Blah','Yes') INTO TRAINING (TRAINING_NAME,TRAINING_DESC, MANDATORY) ('Fast Start: Den Leader','Blah Blah','Yes') INTO TRAINING (TRAINING_NAME,TRAINING_DESC, MANDATORY) ('Fast Start: Cubmaster','Blah Blah','Yes') INTO TRAINING (TRAINING_NAME,TRAINING_DESC, MANDATORY) ('Fast Start: Tiger Cub Den Leaders','Blah Blah','No') INTO TRAINING (TRAINING_NAME,TRAINING_DESC, MANDATORY) ('Fast Start: Webelos Den Leaders','Blah Blah','No') INTO TRAINING (TRAINING_NAME,TRAINING_DESC, MANDATORY) ('This is Scouting','Blah Blah','No') INTO xref_PG_TRAINING (PG_ID, TRAINING_ID, DATE_COMPLETED) (1,1,'1/1/2010') INTO xref_PG_TRAINING (PG_ID, TRAINING_ID, DATE_COMPLETED) (1,2,'1/3/2010') INTO xref_PG_TRAINING (PG_ID, TRAINING_ID, DATE_COMPLETED) (1,3,'1/4/2010') INTO xref_PG_TRAINING (PG_ID, TRAINING_ID, DATE_COMPLETED) (1,4,'1/6/2010') INTO xref_PG_TRAINING (PG_ID, TRAINING_ID, DATE_COMPLETED) (1,5,'1/6/2010') INTO xref_PG_TRAINING (PG_ID, TRAINING_ID, DATE_COMPLETED) (1,6,'1/18/2010') INTO xref_PG_TRAINING (PG_ID, TRAINING_ID, DATE_COMPLETED) (1,1,'1/4/2010') INTO xref_PG_TRAINING (PG_ID, TRAINING_ID, DATE_COMPLETED) (1,2,'1/7/2010') INTO xref_PG_TRAINING (PG_ID, TRAINING_ID, DATE_COMPLETED) (1,3,'1/10/2010')
CREATE
(
[TRAINING_ID]
[TRAINING_NAME]
[TRAINING_DESC]
[MANDATORY]
[DISPLAY_STATUS]
)
GO
CREATE
(
[PG_ID]
[PG_FNAME]
[PG_LNAME]
)
GO
CREATE
(
[PG_ID]
[TRAINING_ID]
[DATE_COMPLETED]
)
GO
INSERT
VALUES
INSERT
VALUES
INSERT
VALUES
GO
INSERT
VALUES
INSERT
VALUES
INSERT
VALUES
INSERT
VALUES
INSERT
VALUES
INSERT
VALUES
GO
-- PARENT_GUARDIAN DEAN PARKER HAS COMPLETED ALL POSSIBLE TRAINING
INSERT
VALUES
INSERT
VALUES
INSERT
VALUES
INSERT
VALUES
INSERT
VALUES
INSERT
VALUES
-- PARENT_GUARDIAN FRANK PURDUE HAS COMPLETED ONLY 3 CLASSES
INSERT
VALUES
INSERT
VALUES
INSERT
VALUES
-- PARENT_GUARDIAN JOHN CUMMINGS HAS NOT COMPLETED ANY CLASSES
--I need to create a stored procedure