INSERT INTO [Town]
	(
		[StateId],
		[Name],
		[PostCode]
	)
	VALUES
	(
		(SELECT [StateId] FROM [State] WHERE [Abbreviation] = @State),
		@Name,
		@PostCode
	);