Populate Bumps database

create.sql

CREATE TABLE [dbo].[Clubs]
(
[Name] [varchar] (50)
)

ALTER TABLE [dbo].[Clubs] ADD CONSTRAINT [PK_Clubs] PRIMARY KEY CLUSTERED  ([Name])

CREATE TABLE [dbo].[Crews]
(
[Club] [varchar] (50) COLLATE Latin1_General_CI_AS NOT NULL,
[Boat] [int] NOT NULL
)

ALTER TABLE [dbo].[Crews] ADD CONSTRAINT [FK_Crews_Clubs] FOREIGN KEY ([Club]) REFERENCES [dbo].[Clubs] ([Name])

import.sql

ALTER TABLE Crews DROP CONSTRAINT FK_Crews_Clubs

DELETE FROM Crews

INSERT INTO Crews
SELECT DISTINCT Club, Crew
FROM Raw

DELETE FROM Clubs

ALTER TABLE Crews ADD CONSTRAINT FK_Crews_Clubs FOREIGN KEY (Club) REFERENCES Clubs(Name)

INSERT INTO Clubs
SELECT DISTINCT Club
FROM Raw
AS Name