Clone Records in same tables TSQL 2005

CREATE TABLE [dbo].[Session](
	[sessionid] [int] IDENTITY(1,1) NOT NULL,
	[sessionname] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[year] [int] NOT NULL,
	[registration] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[startdate] [datetime] NOT NULL,
	[enddate] [datetime] NOT NULL,
	[active] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[lastupdate] [datetime] NULL,
	[lastupdateuser] [int] NULL
) ON [PRIMARY]
 
CREATE TABLE [dbo].[ClassSchedule](
	[classschid] [int] IDENTITY(1,1) NOT NULL,
	[classid] [int] NOT NULL,
	[sessionid] [int] NOT NULL,
	[sectionid] [int] NOT NULL,
	[instid] [int] NOT NULL,
	[fee] [money] NOT NULL,
	[web] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[onlinediscid] [int] NULL,
	[maxstudent] [smallint] NULL,
	[startdate] [datetime] NULL,
	[enddate] [datetime] NULL,
	[notes] [varchar](150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[status] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[createdby] [int] NULL,
	[createdate] [datetime] NULL,
	[lastupdateuser] [int] NULL,
	[lastupdate] [datetime] NULL
) ON [PRIMARY]
 
CREATE TABLE [dbo].[Schedule](
	[classschid] [int] NOT NULL,
	[day] [int] NOT NULL,
	[time] [varchar](12) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[createdby] [int] NULL,
	[createdate] [datetime] NULL,
	[lastupdateuser] [int] NULL,
	[lastupdate] [datetime] NULL
) ON [PRIMARY]
 
Attempted Stored Proc code:
AddNewSession
ALTER PROCEDURE [dbo].[AddNewSession] 
	-- Add the parameters for the stored procedure here
	@sessionid int OUT,
	@sessionname varchar(50), -- example: Summer 2008
	@year int,
	@registration varchar(10),
	@active varchar(3), -- yes or no string
	@startdate datetime,
	@enddate datetime,
	@userid int
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;
DECLARE @oldsessionid int
DECLARE @createdate datetime
 
SET @oldsessionid = (SELECT sessionid FROM Session WHERE active = 'yes')
SET @createdate = getdate()
 
IF (UPPER(@active) = 'YES')
	SET @active = 'yes'
ELSE
	SET @active = 'no'
 
-- Add new Session 
 
insert into [dbo].[Session]
([sessionid],[sessionname],[year],
	[registration],[startdate],[enddate],[active],[lastupdate],[lastupdateuser]) 
values (@sessionid,@sessionname,@year,
	@registration,@startdate,@enddate,@active, @createdate, @userid)
 
SET @sessionid = SCOPE_IDENTITY()
 
-- Insert new class schedule based on old class schedule
INSERT INTO dbo.ClassSchdeule
SELECT classid, @sessionid, sectionid,
	instid,fee,web,onlinediscid,maxstudent,
	@startdate,@enddate, notes, status, @userid,
	@createdate
FROM dbo.ClassSchedule
WHERE sessionid = @oldsessionid
 
-- Now, insert new schedule based on new class schedule
INSERT INTO dbo.Schedule 
SELECT @@identity, [day], [time], createdby,
  createdate
FROM dbo.Schedule
WHERE classschid = @classschid
 
END