CREATE TABLE [SchoolPeriod_T] (
	[Yr] [int] NOT NULL ,
	[Bldg] [tinyint] NOT NULL ,
	[PerDay] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[PerSlot] [tinyint] NOT NULL ,
	[PerStart] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[PerEnd] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[Period] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[PerType] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[DayOrder] AS (case (left([PerDay],1)) when 'M' then '1' when 'T' then '2' when 'W' then '3' when 'R' then '4' when 'F' then '5' else '0' end) ,
	CONSTRAINT [PKSchoolPeriod] PRIMARY KEY  CLUSTERED 
	(
		[Yr],
		[Bldg],
		[DayOrder],
		[PerDay],
		[PerSlot]
	)  ON [PRIMARY] ,
	CONSTRAINT [FKSchoolPeriodSchoolYr] FOREIGN KEY 
	(
		[Bldg],
		[Yr]
	) REFERENCES [SchoolYr_T] (
		[Bldg],
		[Yr]
	)
) ON [PRIMARY]
GO

.
.
.
Set ArithAbort On
Set CONCAT_NULL_YIELDS_NULL On
Set QUOTED_IDENTIFIER On
Set ANSI_NULLS On
Set ANSI_PADDING On
Set ANSI_WARNINGS On
Set NUMERIC_ROUNDABORT Off
.
.
.
If @Copy_School_Period$N_Y='Y'
Begin
	insert into schoolperiod_t (Yr, Bldg, PerDay, PerSlot, PerStart, PerEnd, Period, PerType)
	
	 SELECT @Current_Yr+1, Bldg, PerDay, PerSlot, PerStart, PerEnd, Period, PerType
	 FROM Stufiles.dbo.SchoolPeriod_T Where Yr=@Current_Yr and Bldg=@Bldg$$

Begin Tran
	insert into schoolperiod_t (Yr, Bldg, PerDay, PerSlot, PerStart, PerEnd, Period, PerType)
	
	 SELECT 2008, Bldg, PerDay, PerSlot, PerStart, PerEnd, Period, PerType
	 FROM Stufiles.dbo.SchoolPeriod_T Where Yr=2007 and Bldg=10
Rollback

SET NUMERIC_ROUNDABORT OFF
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
SET ARITHABORT ON
SET CONCAT_NULL_YIELDS_NULL ON
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE 

.....

GO