Query

Question

Query

john-902052

SSCommitted

Points: 1578
More actions
December 31, 2010 at 4:31 pm

#388532

I was wondering if anyone could point me in the right direction here. I have a query
SELECT Distinct
c.[cInstID]
,c.[ClassID]
,c.[CaseID]
,c.[DateAttended]
,d.[PrgTopic]
,d.[PrgSeq]
,d.[ClassDate]
--,ct.ClassTypeID
--,ClassTypeChar
,d.ProgramID
FROM [Current].[dbo].[PartClassAssignments] c
inner join DUIClassInstances d on d.cInstID = c.cInstID
inner join PrgCycleItemToProgramXref xr on xr.ProgramID = d.ProgramID
inner join PrgCycleItems pci on pci.PrgCycleItemID = xr.PrgCycleItemID
inner join ClassTypes ct on ct.ClassTypeID = pci.ClassType
where c.ClassDate >= GETDATE()

but if I uncomment either of the two commented display values it doubles the number of rows returned where each row is duplicated. I am dying here if anyone has a clue.
Thanks
JD

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

akhandels Right there with Babe Points: 731 More actions · Answer 1

Hi,

Can you try to run the query for one c.[cInstID] by adding a where clause; and check the number of rows returned by commenting and uncommenting the mentioned columns.

Also, can you post DDL and DML so that I can run the query locally on my computer.

Thanks & Happy New Year !

Ashish.

john-902052 SSCommitted Points: 1578 More actions · Answer 2

If I do it for on cInstID I still get multiple rows. 5 table of DDL and DML will take awhile.

akhandels Right there with Babe Points: 731 More actions · Answer 3

In SQL Server 2008 management studio, DDL & DML can be scripted using the wizard like this:

http://www.kodyaz.com/articles/sql-server-script-data-with-generate-script-wizard.aspx

This is the fastest way to script DDL and data.

Thank You.

john-902052 SSCommitted Points: 1578 More actions · Answer 4

Awesome thanks for the tip.

USE [Current]

GO

/****** Object: Table [dbo].[PrgCycleItemToProgramXref] Script Date: 12/31/2010 16:53:16 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[PrgCycleItemToProgramXref](

[xrefID] [int] IDENTITY(1,1) NOT NULL,

[PrgCycleItemID] [int] NULL,

[ProgramID] [int] NULL,

[Seq] [int] NULL,

CONSTRAINT [PK_PrgCycleItemToProgramXref] PRIMARY KEY CLUSTERED

(

[xrefID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET IDENTITY_INSERT [dbo].[PrgCycleItemToProgramXref] ON

INSERT [dbo].[PrgCycleItemToProgramXref] ([xrefID], [PrgCycleItemID], [ProgramID], [Seq]) VALUES (31, 1, 2, 1)

INSERT [dbo].[PrgCycleItemToProgramXref] ([xrefID], [PrgCycleItemID], [ProgramID], [Seq]) VALUES (32, 2, 2, 2)

INSERT [dbo].[PrgCycleItemToProgramXref] ([xrefID], [PrgCycleItemID], [ProgramID], [Seq]) VALUES (35, 11, 2, 3)

INSERT [dbo].[PrgCycleItemToProgramXref] ([xrefID], [PrgCycleItemID], [ProgramID], [Seq]) VALUES (36, 8, 2, 4)

INSERT [dbo].[PrgCycleItemToProgramXref] ([xrefID], [PrgCycleItemID], [ProgramID], [Seq]) VALUES (53, 1, 3, 1)

INSERT [dbo].[PrgCycleItemToProgramXref] ([xrefID], [PrgCycleItemID], [ProgramID], [Seq]) VALUES (54, 2, 3, 2)

INSERT [dbo].[PrgCycleItemToProgramXref] ([xrefID], [PrgCycleItemID], [ProgramID], [Seq]) VALUES (55, 3, 3, 3)

INSERT [dbo].[PrgCycleItemToProgramXref] ([xrefID], [PrgCycleItemID], [ProgramID], [Seq]) VALUES (56, 4, 3, 4)

INSERT [dbo].[PrgCycleItemToProgramXref] ([xrefID], [PrgCycleItemID], [ProgramID], [Seq]) VALUES (57, 5, 3, 5)

INSERT [dbo].[PrgCycleItemToProgramXref] ([xrefID], [PrgCycleItemID], [ProgramID], [Seq]) VALUES (58, 6, 3, 6)

INSERT [dbo].[PrgCycleItemToProgramXref] ([xrefID], [PrgCycleItemID], [ProgramID], [Seq]) VALUES (59, 7, 3, 7)

INSERT [dbo].[PrgCycleItemToProgramXref] ([xrefID], [PrgCycleItemID], [ProgramID], [Seq]) VALUES (60, 8, 3, 8)

INSERT [dbo].[PrgCycleItemToProgramXref] ([xrefID], [PrgCycleItemID], [ProgramID], [Seq]) VALUES (61, 9, 3, 9)

INSERT [dbo].[PrgCycleItemToProgramXref] ([xrefID], [PrgCycleItemID], [ProgramID], [Seq]) VALUES (62, 10, 3, 10)

INSERT [dbo].[PrgCycleItemToProgramXref] ([xrefID], [PrgCycleItemID], [ProgramID], [Seq]) VALUES (63, 11, 3, 11)

INSERT [dbo].[PrgCycleItemToProgramXref] ([xrefID], [PrgCycleItemID], [ProgramID], [Seq]) VALUES (64, 12, 3, 12)

INSERT [dbo].[PrgCycleItemToProgramXref] ([xrefID], [PrgCycleItemID], [ProgramID], [Seq]) VALUES (65, 13, 3, 13)

INSERT [dbo].[PrgCycleItemToProgramXref] ([xrefID], [PrgCycleItemID], [ProgramID], [Seq]) VALUES (66, 14, 3, 14)

INSERT [dbo].[PrgCycleItemToProgramXref] ([xrefID], [PrgCycleItemID], [ProgramID], [Seq]) VALUES (67, 15, 3, 15)

INSERT [dbo].[PrgCycleItemToProgramXref] ([xrefID], [PrgCycleItemID], [ProgramID], [Seq]) VALUES (83, 1, 1, 1)

INSERT [dbo].[PrgCycleItemToProgramXref] ([xrefID], [PrgCycleItemID], [ProgramID], [Seq]) VALUES (84, 2, 1, 2)

INSERT [dbo].[PrgCycleItemToProgramXref] ([xrefID], [PrgCycleItemID], [ProgramID], [Seq]) VALUES (85, 3, 1, 3)

INSERT [dbo].[PrgCycleItemToProgramXref] ([xrefID], [PrgCycleItemID], [ProgramID], [Seq]) VALUES (86, 4, 1, 4)

INSERT [dbo].[PrgCycleItemToProgramXref] ([xrefID], [PrgCycleItemID], [ProgramID], [Seq]) VALUES (87, 5, 1, 5)

INSERT [dbo].[PrgCycleItemToProgramXref] ([xrefID], [PrgCycleItemID], [ProgramID], [Seq]) VALUES (88, 6, 1, 6)

INSERT [dbo].[PrgCycleItemToProgramXref] ([xrefID], [PrgCycleItemID], [ProgramID], [Seq]) VALUES (89, 7, 1, 7)

INSERT [dbo].[PrgCycleItemToProgramXref] ([xrefID], [PrgCycleItemID], [ProgramID], [Seq]) VALUES (90, 8, 1, 8)

INSERT [dbo].[PrgCycleItemToProgramXref] ([xrefID], [PrgCycleItemID], [ProgramID], [Seq]) VALUES (91, 9, 1, 9)

INSERT [dbo].[PrgCycleItemToProgramXref] ([xrefID], [PrgCycleItemID], [ProgramID], [Seq]) VALUES (92, 10, 1, 10)

INSERT [dbo].[PrgCycleItemToProgramXref] ([xrefID], [PrgCycleItemID], [ProgramID], [Seq]) VALUES (93, 11, 1, 11)

INSERT [dbo].[PrgCycleItemToProgramXref] ([xrefID], [PrgCycleItemID], [ProgramID], [Seq]) VALUES (94, 12, 1, 12)

INSERT [dbo].[PrgCycleItemToProgramXref] ([xrefID], [PrgCycleItemID], [ProgramID], [Seq]) VALUES (95, 13, 1, 13)

INSERT [dbo].[PrgCycleItemToProgramXref] ([xrefID], [PrgCycleItemID], [ProgramID], [Seq]) VALUES (96, 14, 1, 14)

INSERT [dbo].[PrgCycleItemToProgramXref] ([xrefID], [PrgCycleItemID], [ProgramID], [Seq]) VALUES (97, 15, 1, 15)

SET IDENTITY_INSERT [dbo].[PrgCycleItemToProgramXref] OFF

/****** Object: Table [dbo].[PrgCycleItems] Script Date: 12/31/2010 16:53:16 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[PrgCycleItems](

[PrgCycleItemID] [int] IDENTITY(1,1) NOT NULL,

[Description] [nvarchar](50) NULL,

[ClassType] [int] NULL,

CONSTRAINT [PK_PrgCycleItems] PRIMARY KEY CLUSTERED

(

[PrgCycleItemID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET IDENTITY_INSERT [dbo].[PrgCycleItems] ON

INSERT [dbo].[PrgCycleItems] ([PrgCycleItemID], [Description], [ClassType]) VALUES (1, N'Use and Affects of Alcohol', 3)

INSERT [dbo].[PrgCycleItems] ([PrgCycleItemID], [Description], [ClassType]) VALUES (2, N'The Nature of Alcoholism', 3)

INSERT [dbo].[PrgCycleItems] ([PrgCycleItemID], [Description], [ClassType]) VALUES (3, N'Impairment of the Driving Task 33344', 3)

INSERT [dbo].[PrgCycleItems] ([PrgCycleItemID], [Description], [ClassType]) VALUES (4, N'Positive Non-Drinking Alternatives', 3)

INSERT [dbo].[PrgCycleItems] ([PrgCycleItemID], [Description], [ClassType]) VALUES (5, N'Consequences of Drinking and Driving', 3)

INSERT [dbo].[PrgCycleItems] ([PrgCycleItemID], [Description], [ClassType]) VALUES (6, N'Alcohol/Family/Individual/Society', 3)

INSERT [dbo].[PrgCycleItems] ([PrgCycleItemID], [Description], [ClassType]) VALUES (7, N'Physio and Psycho Aspects of Alcohol', 2)

INSERT [dbo].[PrgCycleItems] ([PrgCycleItemID], [Description], [ClassType]) VALUES (8, N'Alcoholism Ahead', 2)

INSERT [dbo].[PrgCycleItems] ([PrgCycleItemID], [Description], [ClassType]) VALUES (9, N'Choice Points and Responsibilities', 2)

INSERT [dbo].[PrgCycleItems] ([PrgCycleItemID], [Description], [ClassType]) VALUES (10, N'Decision Making and Goal Setting', 2)

INSERT [dbo].[PrgCycleItems] ([PrgCycleItemID], [Description], [ClassType]) VALUES (11, N'How to say NO', 2)

INSERT [dbo].[PrgCycleItems] ([PrgCycleItemID], [Description], [ClassType]) VALUES (12, N'Society as a Friendly Pusher', 2)

INSERT [dbo].[PrgCycleItems] ([PrgCycleItemID], [Description], [ClassType]) VALUES (13, N'Positive/Negative Lifestyles/Values', 2)

INSERT [dbo].[PrgCycleItems] ([PrgCycleItemID], [Description], [ClassType]) VALUES (14, N'Community Resources', 2)

INSERT [dbo].[PrgCycleItems] ([PrgCycleItemID], [Description], [ClassType]) VALUES (15, N'Alcohol and the Family', 2)

INSERT [dbo].[PrgCycleItems] ([PrgCycleItemID], [Description], [ClassType]) VALUES (31, N'Test', 2)

SET IDENTITY_INSERT [dbo].[PrgCycleItems] OFF

/****** Object: Table [dbo].[PartClassAssignments] Script Date: 12/31/2010 16:53:16 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[PartClassAssignments](

[cInstID] [int] IDENTITY(1,1) NOT NULL,

[ClassID] [int] NULL,

[PrgTopic] [nvarchar](50) NULL,

[PrgSeq] [int] NULL,

[ClassDate] [datetime] NULL,

[CounselorID] [int] NULL,

[CaseID] [int] NULL,

[DateAttended] [datetime] NULL,

CONSTRAINT [PK_PartClassAssignments] PRIMARY KEY CLUSTERED

(

[cInstID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET IDENTITY_INSERT [dbo].[PartClassAssignments] ON

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (1, 99, N'Use and Affects of Alcohol', 1, CAST(0x00009F9B00000000 AS DateTime), 4, 1220, CAST(0x00009E2E00000000 AS DateTime))

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (2, 99, N'The Nature of Alcoholism', 2, CAST(0x00009FA200000000 AS DateTime), 4, 1220, CAST(0x00009E3500000000 AS DateTime))

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (3, 99, N'Impairment of the Driving Task', 3, CAST(0x00009FA900000000 AS DateTime), 4, 1220, CAST(0x00009E3C00000000 AS DateTime))

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (4, 99, N'Positive Non-Drinking Alternatives', 4, CAST(0x00009FB000000000 AS DateTime), 4, 1220, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (5, 99, N'Consequences of Drinking and Driving', 5, CAST(0x00009FB700000000 AS DateTime), 4, 1220, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (6, 99, N'Alcohol/Family/Individual/Society', 6, CAST(0x00009FBE00000000 AS DateTime), 4, 1220, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (7, 99, N'Physio and Psycho Aspects of Alcohol', 7, CAST(0x00009FC500000000 AS DateTime), 4, 1220, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (8, 99, N'Alcoholism Ahead', 8, CAST(0x00009FCC00000000 AS DateTime), 4, 1220, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (9, 99, N'Choice Points and Responsibilities', 9, CAST(0x00009FD300000000 AS DateTime), 4, 1220, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (10, 99, N'Decision Making and Goal Setting', 10, CAST(0x00009FDA00000000 AS DateTime), 4, 1220, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (11, 99, N'How to say NO', 11, CAST(0x00009FE100000000 AS DateTime), 4, 1220, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (12, 99, N'Society as a Friendly Pusher', 12, CAST(0x00009FE800000000 AS DateTime), 4, 1220, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (13, 99, N'Positive/Negative Lifestyles/Values', 13, CAST(0x00009FEF00000000 AS DateTime), 4, 1220, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (14, 99, N'Community Resources', 14, CAST(0x00009FF600000000 AS DateTime), 4, 1220, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (15, 99, N'Alcohol and the Family', 15, CAST(0x00009FFD00000000 AS DateTime), 4, 1220, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (17, 99, N'Use and Affects of Alcohol', 1, CAST(0x00009F9B00000000 AS DateTime), 4, 21, CAST(0x00009E5D00000000 AS DateTime))

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (18, 99, N'The Nature of Alcoholism', 2, CAST(0x00009FA200000000 AS DateTime), 4, 21, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (19, 99, N'Impairment of the Driving Task', 3, CAST(0x00009FA900000000 AS DateTime), 4, 21, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (20, 99, N'Positive Non-Drinking Alternatives', 4, CAST(0x00009FB000000000 AS DateTime), 4, 21, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (21, 99, N'Consequences of Drinking and Driving', 5, CAST(0x00009FB700000000 AS DateTime), 4, 21, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (22, 99, N'Alcohol/Family/Individual/Society', 6, CAST(0x00009FBE00000000 AS DateTime), 4, 21, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (23, 99, N'Physio and Psycho Aspects of Alcohol', 7, CAST(0x00009FC500000000 AS DateTime), 4, 21, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (24, 99, N'Alcoholism Ahead', 8, CAST(0x00009FCC00000000 AS DateTime), 4, 21, CAST(0x00009E5A00000000 AS DateTime))

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (25, 99, N'Choice Points and Responsibilities', 9, CAST(0x00009FD300000000 AS DateTime), 4, 21, CAST(0x00009E5A00000000 AS DateTime))

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (26, 99, N'Decision Making and Goal Setting', 10, CAST(0x00009FDA00000000 AS DateTime), 4, 21, CAST(0x00009E5A00000000 AS DateTime))

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (27, 99, N'How to say NO', 11, CAST(0x00009FE100000000 AS DateTime), 4, 21, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (28, 99, N'Society as a Friendly Pusher', 12, CAST(0x00009FE800000000 AS DateTime), 4, 21, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (29, 99, N'Positive/Negative Lifestyles/Values', 13, CAST(0x00009FEF00000000 AS DateTime), 4, 21, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (30, 99, N'Community Resources', 14, CAST(0x00009FF600000000 AS DateTime), 4, 21, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (31, 99, N'Alcohol and the Family', 15, CAST(0x00009FFD00000000 AS DateTime), 4, 21, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (32, 99, N'Use and Affects of Alcohol', 1, CAST(0x00009F9B00000000 AS DateTime), 4, 1222, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (33, 99, N'The Nature of Alcoholism', 2, CAST(0x00009FA200000000 AS DateTime), 4, 1222, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (34, 99, N'Impairment of the Driving Task', 3, CAST(0x00009FA900000000 AS DateTime), 4, 1222, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (35, 99, N'Positive Non-Drinking Alternatives', 4, CAST(0x00009FB000000000 AS DateTime), 4, 1222, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (36, 99, N'Consequences of Drinking and Driving', 5, CAST(0x00009FB700000000 AS DateTime), 4, 1222, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (37, 99, N'Alcohol/Family/Individual/Society', 6, CAST(0x00009FBE00000000 AS DateTime), 4, 1222, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (38, 99, N'Physio and Psycho Aspects of Alcohol', 7, CAST(0x00009FC500000000 AS DateTime), 4, 1222, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (39, 99, N'Alcoholism Ahead', 8, CAST(0x00009FCC00000000 AS DateTime), 4, 1222, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (40, 99, N'Choice Points and Responsibilities', 9, CAST(0x00009FD300000000 AS DateTime), 4, 1222, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (41, 99, N'Decision Making and Goal Setting', 10, CAST(0x00009FDA00000000 AS DateTime), 4, 1222, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (42, 99, N'How to say NO', 11, CAST(0x00009FE100000000 AS DateTime), 4, 1222, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (43, 99, N'Society as a Friendly Pusher', 12, CAST(0x00009FE800000000 AS DateTime), 4, 1222, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (44, 99, N'Positive/Negative Lifestyles/Values', 13, CAST(0x00009FEF00000000 AS DateTime), 4, 1222, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (45, 99, N'Community Resources', 14, CAST(0x00009FF600000000 AS DateTime), 4, 1222, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (46, 99, N'Alcohol and the Family', 15, CAST(0x00009FFD00000000 AS DateTime), 4, 1222, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (47, 99, N'Use and Affects of Alcohol', 1, CAST(0x00009F9B00000000 AS DateTime), 4, 1223, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (48, 99, N'The Nature of Alcoholism', 2, CAST(0x00009FA200000000 AS DateTime), 4, 1223, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (49, 99, N'Impairment of the Driving Task', 3, CAST(0x00009FA900000000 AS DateTime), 4, 1223, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (50, 99, N'Positive Non-Drinking Alternatives', 4, CAST(0x00009FB000000000 AS DateTime), 4, 1223, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (51, 99, N'Consequences of Drinking and Driving', 5, CAST(0x00009FB700000000 AS DateTime), 4, 1223, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (52, 99, N'Alcohol/Family/Individual/Society', 6, CAST(0x00009FBE00000000 AS DateTime), 4, 1223, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (53, 99, N'Physio and Psycho Aspects of Alcohol', 7, CAST(0x00009FC500000000 AS DateTime), 4, 1223, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (54, 99, N'Alcoholism Ahead', 8, CAST(0x00009FCC00000000 AS DateTime), 4, 1223, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (55, 99, N'Choice Points and Responsibilities', 9, CAST(0x00009FD300000000 AS DateTime), 4, 1223, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (56, 99, N'Decision Making and Goal Setting', 10, CAST(0x00009FDA00000000 AS DateTime), 4, 1223, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (57, 99, N'How to say NO', 11, CAST(0x00009FE100000000 AS DateTime), 4, 1223, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (58, 99, N'Society as a Friendly Pusher', 12, CAST(0x00009FE800000000 AS DateTime), 4, 1223, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (59, 99, N'Positive/Negative Lifestyles/Values', 13, CAST(0x00009FEF00000000 AS DateTime), 4, 1223, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (60, 99, N'Community Resources', 14, CAST(0x00009FF600000000 AS DateTime), 4, 1223, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (61, 99, N'Alcohol and the Family', 15, CAST(0x00009FFD00000000 AS DateTime), 4, 1223, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (62, 99, N'Use and Affects of Alcohol', 1, CAST(0x00009F9B00000000 AS DateTime), 4, 1223, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (63, 99, N'The Nature of Alcoholism', 2, CAST(0x00009FA200000000 AS DateTime), 4, 1223, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (64, 99, N'Impairment of the Driving Task', 3, CAST(0x00009FA900000000 AS DateTime), 4, 1223, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (65, 99, N'Positive Non-Drinking Alternatives', 4, CAST(0x00009FB000000000 AS DateTime), 4, 1223, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (66, 99, N'Consequences of Drinking and Driving', 5, CAST(0x00009FB700000000 AS DateTime), 4, 1223, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (67, 99, N'Alcohol/Family/Individual/Society', 6, CAST(0x00009FBE00000000 AS DateTime), 4, 1223, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (68, 99, N'Physio and Psycho Aspects of Alcohol', 7, CAST(0x00009FC500000000 AS DateTime), 4, 1223, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (69, 99, N'Alcoholism Ahead', 8, CAST(0x00009FCC00000000 AS DateTime), 4, 1223, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (70, 99, N'Choice Points and Responsibilities', 9, CAST(0x00009FD300000000 AS DateTime), 4, 1223, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (71, 99, N'Decision Making and Goal Setting', 10, CAST(0x00009FDA00000000 AS DateTime), 4, 1223, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (72, 99, N'How to say NO', 11, CAST(0x00009FE100000000 AS DateTime), 4, 1223, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (73, 99, N'Society as a Friendly Pusher', 12, CAST(0x00009FE800000000 AS DateTime), 4, 1223, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (74, 99, N'Positive/Negative Lifestyles/Values', 13, CAST(0x00009FEF00000000 AS DateTime), 4, 1223, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (75, 99, N'Community Resources', 14, CAST(0x00009FF600000000 AS DateTime), 4, 1223, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (76, 99, N'Alcohol and the Family', 15, CAST(0x00009FFD00000000 AS DateTime), 4, 1223, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (77, 99, N'Use and Affects of Alcohol', 1, CAST(0x00009F9B00000000 AS DateTime), 4, 1227, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (78, 99, N'The Nature of Alcoholism', 2, CAST(0x00009FA200000000 AS DateTime), 4, 1227, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (79, 99, N'Impairment of the Driving Task', 3, CAST(0x00009FA900000000 AS DateTime), 4, 1227, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (80, 99, N'Positive Non-Drinking Alternatives', 4, CAST(0x00009FB000000000 AS DateTime), 4, 1227, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (81, 99, N'Consequences of Drinking and Driving', 5, CAST(0x00009FB700000000 AS DateTime), 4, 1227, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (82, 99, N'Alcohol/Family/Individual/Society', 6, CAST(0x00009FBE00000000 AS DateTime), 4, 1227, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (83, 99, N'Physio and Psycho Aspects of Alcohol', 7, CAST(0x00009FC500000000 AS DateTime), 4, 1227, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (84, 99, N'Alcoholism Ahead', 8, CAST(0x00009FCC00000000 AS DateTime), 4, 1227, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (85, 99, N'Choice Points and Responsibilities', 9, CAST(0x00009FD300000000 AS DateTime), 4, 1227, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (86, 99, N'Decision Making and Goal Setting', 10, CAST(0x00009FDA00000000 AS DateTime), 4, 1227, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (87, 99, N'How to say NO', 11, CAST(0x00009FE100000000 AS DateTime), 4, 1227, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (88, 99, N'Society as a Friendly Pusher', 12, CAST(0x00009FE800000000 AS DateTime), 4, 1227, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (89, 99, N'Positive/Negative Lifestyles/Values', 13, CAST(0x00009FEF00000000 AS DateTime), 4, 1227, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (90, 99, N'Community Resources', 14, CAST(0x00009FF600000000 AS DateTime), 4, 1227, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (91, 99, N'Alcohol and the Family', 15, CAST(0x00009FFD00000000 AS DateTime), 4, 1227, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (92, 99, N'Use and Affects of Alcohol', 1, CAST(0x00009F9B00000000 AS DateTime), 4, 1228, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (93, 99, N'The Nature of Alcoholism', 2, CAST(0x00009FA200000000 AS DateTime), 4, 1228, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (94, 99, N'Impairment of the Driving Task', 3, CAST(0x00009FA900000000 AS DateTime), 4, 1228, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (95, 99, N'Positive Non-Drinking Alternatives', 4, CAST(0x00009FB000000000 AS DateTime), 4, 1228, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (96, 99, N'Consequences of Drinking and Driving', 5, CAST(0x00009FB700000000 AS DateTime), 4, 1228, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (97, 99, N'Alcohol/Family/Individual/Society', 6, CAST(0x00009FBE00000000 AS DateTime), 4, 1228, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (98, 99, N'Physio and Psycho Aspects of Alcohol', 7, CAST(0x00009FC500000000 AS DateTime), 4, 1228, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (99, 99, N'Alcoholism Ahead', 8, CAST(0x00009FCC00000000 AS DateTime), 4, 1228, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (100, 99, N'Choice Points and Responsibilities', 9, CAST(0x00009FD300000000 AS DateTime), 4, 1228, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (101, 99, N'Decision Making and Goal Setting', 10, CAST(0x00009FDA00000000 AS DateTime), 4, 1228, NULL)

GO

print 'Processed 100 total records'

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (102, 99, N'How to say NO', 11, CAST(0x00009FE100000000 AS DateTime), 4, 1228, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (103, 99, N'Society as a Friendly Pusher', 12, CAST(0x00009FE800000000 AS DateTime), 4, 1228, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (104, 99, N'Positive/Negative Lifestyles/Values', 13, CAST(0x00009FEF00000000 AS DateTime), 4, 1228, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (105, 99, N'Community Resources', 14, CAST(0x00009FF600000000 AS DateTime), 4, 1228, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (106, 99, N'Alcohol and the Family', 15, CAST(0x00009FFD00000000 AS DateTime), 4, 1228, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (107, 99, N'Use and Affects of Alcohol', 1, CAST(0x00009F9B00000000 AS DateTime), 4, 1230, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (108, 99, N'The Nature of Alcoholism', 2, CAST(0x00009FA200000000 AS DateTime), 4, 1230, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (109, 99, N'Impairment of the Driving Task', 3, CAST(0x00009FA900000000 AS DateTime), 4, 1230, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (110, 99, N'Positive Non-Drinking Alternatives', 4, CAST(0x00009FB000000000 AS DateTime), 4, 1230, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (111, 99, N'Consequences of Drinking and Driving', 5, CAST(0x00009FB700000000 AS DateTime), 4, 1230, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (112, 99, N'Alcohol/Family/Individual/Society', 6, CAST(0x00009FBE00000000 AS DateTime), 4, 1230, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (113, 99, N'Physio and Psycho Aspects of Alcohol', 7, CAST(0x00009FC500000000 AS DateTime), 4, 1230, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (114, 99, N'Alcoholism Ahead', 8, CAST(0x00009FCC00000000 AS DateTime), 4, 1230, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (115, 99, N'Choice Points and Responsibilities', 9, CAST(0x00009FD300000000 AS DateTime), 4, 1230, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (116, 99, N'Decision Making and Goal Setting', 10, CAST(0x00009FDA00000000 AS DateTime), 4, 1230, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (117, 99, N'How to say NO', 11, CAST(0x00009FE100000000 AS DateTime), 4, 1230, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (118, 99, N'Society as a Friendly Pusher', 12, CAST(0x00009FE800000000 AS DateTime), 4, 1230, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (119, 99, N'Positive/Negative Lifestyles/Values', 13, CAST(0x00009FEF00000000 AS DateTime), 4, 1230, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (120, 99, N'Community Resources', 14, CAST(0x00009FF600000000 AS DateTime), 4, 1230, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (121, 99, N'Alcohol and the Family', 15, CAST(0x00009FFD00000000 AS DateTime), 4, 1230, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (122, 99, N'Use and Affects of Alcohol', 1, CAST(0x00009F9B00000000 AS DateTime), 4, 1232, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (123, 99, N'The Nature of Alcoholism', 2, CAST(0x00009FA200000000 AS DateTime), 4, 1232, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (124, 99, N'Impairment of the Driving Task', 3, CAST(0x00009FA900000000 AS DateTime), 4, 1232, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (125, 99, N'Positive Non-Drinking Alternatives', 4, CAST(0x00009FB000000000 AS DateTime), 4, 1232, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (126, 99, N'Consequences of Drinking and Driving', 5, CAST(0x00009FB700000000 AS DateTime), 4, 1232, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (127, 99, N'Alcohol/Family/Individual/Society', 6, CAST(0x00009FBE00000000 AS DateTime), 4, 1232, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (128, 99, N'Physio and Psycho Aspects of Alcohol', 7, CAST(0x00009FC500000000 AS DateTime), 4, 1232, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (129, 99, N'Alcoholism Ahead', 8, CAST(0x00009FCC00000000 AS DateTime), 4, 1232, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (130, 99, N'Choice Points and Responsibilities', 9, CAST(0x00009FD300000000 AS DateTime), 4, 1232, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (131, 99, N'Decision Making and Goal Setting', 10, CAST(0x00009FDA00000000 AS DateTime), 4, 1232, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (132, 99, N'How to say NO', 11, CAST(0x00009FE100000000 AS DateTime), 4, 1232, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (133, 99, N'Society as a Friendly Pusher', 12, CAST(0x00009FE800000000 AS DateTime), 4, 1232, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (134, 99, N'Positive/Negative Lifestyles/Values', 13, CAST(0x00009FEF00000000 AS DateTime), 4, 1232, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (135, 99, N'Community Resources', 14, CAST(0x00009FF600000000 AS DateTime), 4, 1232, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (136, 99, N'Alcohol and the Family', 15, CAST(0x00009FFD00000000 AS DateTime), 4, 1232, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (137, 99, N'Use and Affects of Alcohol', 1, CAST(0x0000A00400000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (138, 99, N'The Nature of Alcoholism', 2, CAST(0x0000A00B00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (139, 99, N'Impairment of the Driving Task', 3, CAST(0x0000A01200000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (140, 99, N'Positive Non-Drinking Alternatives', 4, CAST(0x0000A01900000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (141, 99, N'Consequences of Drinking and Driving', 5, CAST(0x0000A02000000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (142, 99, N'Alcohol/Family/Individual/Society', 6, CAST(0x0000A02700000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (143, 99, N'Physio and Psycho Aspects of Alcohol', 7, CAST(0x0000A02E00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (144, 99, N'Alcoholism Ahead', 8, CAST(0x0000A03500000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (145, 99, N'Choice Points and Responsibilities', 9, CAST(0x0000A03C00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (146, 99, N'Decision Making and Goal Setting', 10, CAST(0x0000A04300000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (147, 99, N'How to say NO', 11, CAST(0x0000A04A00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (148, 99, N'Society as a Friendly Pusher', 12, CAST(0x0000A05100000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (149, 99, N'Positive/Negative Lifestyles/Values', 13, CAST(0x0000A05800000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (150, 99, N'Community Resources', 14, CAST(0x0000A05F00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (151, 99, N'Alcohol and the Family', 15, CAST(0x0000A06D00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (152, 99, N'Use and Affects of Alcohol', 1, CAST(0x0000A07400000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (153, 99, N'The Nature of Alcoholism', 2, CAST(0x0000A07B00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (154, 99, N'Impairment of the Driving Task 33344', 3, CAST(0x0000A08200000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (155, 99, N'Positive Non-Drinking Alternatives', 4, CAST(0x0000A08900000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (156, 99, N'Consequences of Drinking and Driving', 5, CAST(0x0000A09000000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (157, 99, N'Alcohol/Family/Individual/Society', 6, CAST(0x0000A09700000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (158, 99, N'Physio and Psycho Aspects of Alcohol', 7, CAST(0x0000A09E00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (159, 99, N'Alcoholism Ahead', 8, CAST(0x0000A0A500000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (160, 99, N'Choice Points and Responsibilities', 9, CAST(0x0000A0AC00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (161, 99, N'Decision Making and Goal Setting', 10, CAST(0x0000A0B300000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (162, 99, N'How to say NO', 11, CAST(0x0000A0BA00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (163, 99, N'Society as a Friendly Pusher', 12, CAST(0x0000A0C100000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (164, 99, N'Positive/Negative Lifestyles/Values', 13, CAST(0x0000A0C800000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (165, 99, N'Community Resources', 14, CAST(0x0000A0CF00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (166, 99, N'Alcohol and the Family', 15, CAST(0x0000A0D600000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (167, 99, N'Use and Affects of Alcohol', 1, CAST(0x0000A0DD00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (168, 99, N'The Nature of Alcoholism', 2, CAST(0x0000A0E400000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (169, 99, N'Impairment of the Driving Task 33344', 3, CAST(0x0000A0EB00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (170, 99, N'Positive Non-Drinking Alternatives', 4, CAST(0x0000A0F200000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (171, 99, N'Consequences of Drinking and Driving', 5, CAST(0x0000A0F900000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (172, 99, N'Alcohol/Family/Individual/Society', 6, CAST(0x0000A10000000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (173, 99, N'Physio and Psycho Aspects of Alcohol', 7, CAST(0x0000A10700000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (174, 99, N'Alcoholism Ahead', 8, CAST(0x0000A10E00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (175, 99, N'Choice Points and Responsibilities', 9, CAST(0x0000A11500000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (176, 99, N'Decision Making and Goal Setting', 10, CAST(0x0000A11C00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (177, 99, N'How to say NO', 11, CAST(0x0000A12300000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (178, 99, N'Society as a Friendly Pusher', 12, CAST(0x0000A12A00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (179, 99, N'Positive/Negative Lifestyles/Values', 13, CAST(0x0000A13100000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (180, 99, N'Community Resources', 14, CAST(0x0000A13800000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (181, 99, N'Alcohol and the Family', 15, CAST(0x0000A13F00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (182, 99, N'Use and Affects of Alcohol', 1, CAST(0x0000A14600000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (183, 99, N'The Nature of Alcoholism', 2, CAST(0x0000A14D00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (184, 99, N'Impairment of the Driving Task 33344', 3, CAST(0x0000A15400000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (185, 99, N'Positive Non-Drinking Alternatives', 4, CAST(0x0000A15B00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (186, 99, N'Consequences of Drinking and Driving', 5, CAST(0x0000A16200000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (187, 99, N'Alcohol/Family/Individual/Society', 6, CAST(0x0000A16900000000 AS DateTime), 4, 1233, CAST(0x00009E5D00000000 AS DateTime))

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (188, 99, N'Physio and Psycho Aspects of Alcohol', 7, CAST(0x0000A17000000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (189, 99, N'Alcoholism Ahead', 8, CAST(0x0000A17700000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (190, 99, N'Choice Points and Responsibilities', 9, CAST(0x0000A17E00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (191, 99, N'Decision Making and Goal Setting', 10, CAST(0x0000A18500000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (192, 99, N'How to say NO', 11, CAST(0x0000A18C00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (193, 99, N'Society as a Friendly Pusher', 12, CAST(0x0000A19300000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (194, 99, N'Positive/Negative Lifestyles/Values', 13, CAST(0x0000A19A00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (195, 99, N'Community Resources', 14, CAST(0x0000A1A100000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (196, 99, N'Alcohol and the Family', 15, CAST(0x0000A1A800000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (197, 99, N'Use and Affects of Alcohol', 1, CAST(0x0000A1AF00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (198, 99, N'The Nature of Alcoholism', 2, CAST(0x0000A1B600000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (199, 99, N'Impairment of the Driving Task 33344', 3, CAST(0x0000A1BD00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (200, 99, N'Positive Non-Drinking Alternatives', 4, CAST(0x0000A1C400000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (201, 99, N'Consequences of Drinking and Driving', 5, CAST(0x0000A1CB00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (202, 99, N'Alcohol/Family/Individual/Society', 6, CAST(0x0000A1D200000000 AS DateTime), 4, 1233, NULL)

GO

print 'Processed 200 total records'

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (203, 99, N'Physio and Psycho Aspects of Alcohol', 7, CAST(0x0000A1D900000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (204, 99, N'Alcoholism Ahead', 8, CAST(0x0000A1E000000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (205, 99, N'Choice Points and Responsibilities', 9, CAST(0x0000A1E700000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (206, 99, N'Decision Making and Goal Setting', 10, CAST(0x0000A1EE00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (207, 99, N'How to say NO', 11, CAST(0x0000A1F500000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (208, 99, N'Society as a Friendly Pusher', 12, CAST(0x0000A1FC00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (209, 99, N'Positive/Negative Lifestyles/Values', 13, CAST(0x0000A20300000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (210, 99, N'Community Resources', 14, CAST(0x0000A20A00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (211, 99, N'Alcohol and the Family', 15, CAST(0x0000A21100000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (212, 99, N'Use and Affects of Alcohol', 1, CAST(0x0000A21800000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (213, 99, N'The Nature of Alcoholism', 2, CAST(0x0000A21F00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (214, 99, N'Impairment of the Driving Task 33344', 3, CAST(0x0000A22600000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (215, 99, N'Positive Non-Drinking Alternatives', 4, CAST(0x0000A22D00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (216, 99, N'Consequences of Drinking and Driving', 5, CAST(0x0000A23400000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (217, 99, N'Alcohol/Family/Individual/Society', 6, CAST(0x0000A23B00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (218, 99, N'Physio and Psycho Aspects of Alcohol', 7, CAST(0x0000A24200000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (219, 99, N'Alcoholism Ahead', 8, CAST(0x0000A24900000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (220, 99, N'Choice Points and Responsibilities', 9, CAST(0x0000A25000000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (221, 99, N'Decision Making and Goal Setting', 10, CAST(0x0000A25700000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (222, 99, N'How to say NO', 11, CAST(0x0000A25E00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (223, 99, N'Society as a Friendly Pusher', 12, CAST(0x0000A26500000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (224, 99, N'Positive/Negative Lifestyles/Values', 13, CAST(0x0000A26C00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (225, 99, N'Community Resources', 14, CAST(0x0000A27300000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (226, 99, N'Alcohol and the Family', 15, CAST(0x0000A27A00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (227, 99, N'Use and Affects of Alcohol', 1, CAST(0x0000A28100000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (228, 99, N'The Nature of Alcoholism', 2, CAST(0x0000A28800000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (229, 99, N'Impairment of the Driving Task 33344', 3, CAST(0x0000A28F00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (230, 99, N'Positive Non-Drinking Alternatives', 4, CAST(0x0000A29D00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (231, 99, N'Consequences of Drinking and Driving', 5, CAST(0x0000A2A400000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (232, 99, N'Alcohol/Family/Individual/Society', 6, CAST(0x0000A2AB00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (233, 99, N'Physio and Psycho Aspects of Alcohol', 7, CAST(0x0000A2B200000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (234, 99, N'Alcoholism Ahead', 8, CAST(0x0000A2B900000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (235, 99, N'Choice Points and Responsibilities', 9, CAST(0x0000A2C000000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (236, 99, N'Decision Making and Goal Setting', 10, CAST(0x0000A2C700000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (237, 99, N'How to say NO', 11, CAST(0x0000A2CE00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (238, 99, N'Society as a Friendly Pusher', 12, CAST(0x0000A2D500000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (239, 99, N'Positive/Negative Lifestyles/Values', 13, CAST(0x0000A2DC00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (240, 99, N'Community Resources', 14, CAST(0x0000A2E300000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (241, 99, N'Alcohol and the Family', 15, CAST(0x0000A2EA00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (242, 99, N'Use and Affects of Alcohol', 1, CAST(0x0000A2F100000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (243, 99, N'The Nature of Alcoholism', 2, CAST(0x0000A2F800000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (244, 99, N'Impairment of the Driving Task 33344', 3, CAST(0x0000A2FF00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (245, 99, N'Positive Non-Drinking Alternatives', 4, CAST(0x0000A30600000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (246, 99, N'Consequences of Drinking and Driving', 5, CAST(0x0000A30D00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (247, 99, N'Alcohol/Family/Individual/Society', 6, CAST(0x0000A31400000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (248, 99, N'Physio and Psycho Aspects of Alcohol', 7, CAST(0x0000A31B00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (249, 99, N'Alcoholism Ahead', 8, CAST(0x0000A32200000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (250, 99, N'Choice Points and Responsibilities', 9, CAST(0x0000A32900000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (251, 99, N'Decision Making and Goal Setting', 10, CAST(0x0000A33000000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (252, 99, N'How to say NO', 11, CAST(0x0000A33700000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (253, 99, N'Society as a Friendly Pusher', 12, CAST(0x0000A33E00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (254, 99, N'Positive/Negative Lifestyles/Values', 13, CAST(0x0000A34500000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (255, 99, N'Community Resources', 14, CAST(0x0000A34C00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (256, 99, N'Alcohol and the Family', 15, CAST(0x0000A35300000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (257, 99, N'Use and Affects of Alcohol', 1, CAST(0x0000A35A00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (258, 99, N'The Nature of Alcoholism', 2, CAST(0x0000A36100000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (259, 99, N'Impairment of the Driving Task 33344', 3, CAST(0x0000A36800000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (260, 99, N'Positive Non-Drinking Alternatives', 4, CAST(0x0000A36F00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (261, 99, N'Consequences of Drinking and Driving', 5, CAST(0x0000A37600000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (262, 99, N'Alcohol/Family/Individual/Society', 6, CAST(0x0000A37D00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (263, 99, N'Physio and Psycho Aspects of Alcohol', 7, CAST(0x0000A38400000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (264, 99, N'Alcoholism Ahead', 8, CAST(0x0000A38B00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (265, 99, N'Choice Points and Responsibilities', 9, CAST(0x0000A39200000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (266, 99, N'Decision Making and Goal Setting', 10, CAST(0x0000A39900000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (267, 99, N'How to say NO', 11, CAST(0x0000A3A000000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (268, 99, N'Society as a Friendly Pusher', 12, CAST(0x0000A3A700000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (269, 99, N'Positive/Negative Lifestyles/Values', 13, CAST(0x0000A3AE00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (270, 99, N'Community Resources', 14, CAST(0x0000A3B500000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (271, 99, N'Alcohol and the Family', 15, CAST(0x0000A3BC00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (272, 99, N'Use and Affects of Alcohol', 1, CAST(0x0000A3C300000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (273, 99, N'The Nature of Alcoholism', 2, CAST(0x0000A3CA00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (274, 99, N'Impairment of the Driving Task 33344', 3, CAST(0x0000A3D100000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (275, 99, N'Positive Non-Drinking Alternatives', 4, CAST(0x0000A3D800000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (276, 99, N'Consequences of Drinking and Driving', 5, CAST(0x0000A3DF00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (277, 99, N'Alcohol/Family/Individual/Society', 6, CAST(0x0000A3E600000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (278, 99, N'Physio and Psycho Aspects of Alcohol', 7, CAST(0x0000A3ED00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (279, 99, N'Alcoholism Ahead', 8, CAST(0x0000A3F400000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (280, 99, N'Choice Points and Responsibilities', 9, CAST(0x0000A3FB00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (281, 99, N'Decision Making and Goal Setting', 10, CAST(0x0000A40200000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (282, 99, N'How to say NO', 11, CAST(0x0000A40900000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (283, 99, N'Society as a Friendly Pusher', 12, CAST(0x0000A41000000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (284, 99, N'Positive/Negative Lifestyles/Values', 13, CAST(0x0000A41700000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (285, 99, N'Community Resources', 14, CAST(0x0000A41E00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (286, 99, N'Alcohol and the Family', 15, CAST(0x0000A42500000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (287, 99, N'Use and Affects of Alcohol', 1, CAST(0x0000A42C00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (288, 99, N'The Nature of Alcoholism', 2, CAST(0x0000A43300000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (289, 99, N'Impairment of the Driving Task 33344', 3, CAST(0x0000A43A00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (290, 99, N'Positive Non-Drinking Alternatives', 4, CAST(0x0000A44100000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (291, 99, N'Consequences of Drinking and Driving', 5, CAST(0x0000A44800000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (292, 99, N'Alcohol/Family/Individual/Society', 6, CAST(0x0000A44F00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (293, 99, N'Physio and Psycho Aspects of Alcohol', 7, CAST(0x0000A45600000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (294, 99, N'Alcoholism Ahead', 8, CAST(0x0000A45D00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (295, 99, N'Choice Points and Responsibilities', 9, CAST(0x0000A46400000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (296, 99, N'Decision Making and Goal Setting', 10, CAST(0x0000A46B00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (297, 99, N'How to say NO', 11, CAST(0x0000A47200000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (298, 99, N'Society as a Friendly Pusher', 12, CAST(0x0000A47900000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (299, 99, N'Positive/Negative Lifestyles/Values', 13, CAST(0x0000A48000000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (300, 99, N'Community Resources', 14, CAST(0x0000A48700000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (301, 99, N'Alcohol and the Family', 15, CAST(0x0000A48E00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (302, 99, N'Use and Affects of Alcohol', 1, CAST(0x0000A49500000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (303, 99, N'The Nature of Alcoholism', 2, CAST(0x0000A49C00000000 AS DateTime), 4, 1233, NULL)

GO

print 'Processed 300 total records'

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (304, 99, N'Impairment of the Driving Task 33344', 3, CAST(0x0000A4A300000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (305, 99, N'Positive Non-Drinking Alternatives', 4, CAST(0x0000A4AA00000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (306, 99, N'Consequences of Drinking and Driving', 5, CAST(0x0000A4B100000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (307, 99, N'Alcohol/Family/Individual/Society', 6, CAST(0x0000A4B800000000 AS DateTime), 4, 1233, NULL)

INSERT [dbo].[PartClassAssignments] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [CaseID], [DateAttended]) VALUES (308, 99, N'Physio and Psycho Aspects of Alcohol', 7, CAST(0x0000A4BF00000000 AS DateTime), 4, 1233, NULL)

SET IDENTITY_INSERT [dbo].[PartClassAssignments] OFF

/****** Object: Table [dbo].[DUIClassInstances] Script Date: 12/31/2010 16:53:16 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[DUIClassInstances](

[cInstID] [int] IDENTITY(1,1) NOT NULL,

[ClassID] [int] NULL,

[PrgTopic] [nvarchar](50) NULL,

[PrgSeq] [int] NULL,

[ClassDate] [datetime] NULL,

[CounselorID] [int] NULL,

[ProgramID] [int] NULL,

CONSTRAINT [PK_DUIClassInstances] PRIMARY KEY CLUSTERED

(

[cInstID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET IDENTITY_INSERT [dbo].[DUIClassInstances] ON

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (43, 97, N'Use and Affects of Alcohol', 1, CAST(0x00009E3D00000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (44, 97, N'The Nature of Alcoholism', 2, CAST(0x00009E4400000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (45, 97, N'How to say NO', 3, CAST(0x00009E4B00000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (46, 97, N'Alcoholism Ahead', 4, CAST(0x00009E5200000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (47, 97, N'Use and Affects of Alcohol', 1, CAST(0x00009E5900000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (48, 97, N'The Nature of Alcoholism', 2, CAST(0x00009E6000000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (49, 97, N'How to say NO', 3, CAST(0x00009E6700000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (50, 97, N'Alcoholism Ahead', 4, CAST(0x00009E6E00000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (51, 97, N'Use and Affects of Alcohol', 1, CAST(0x00009E7500000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (52, 97, N'The Nature of Alcoholism', 2, CAST(0x00009E7C00000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (53, 97, N'How to say NO', 3, CAST(0x00009E8300000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (54, 97, N'Alcoholism Ahead', 4, CAST(0x00009E8A00000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (55, 97, N'Use and Affects of Alcohol', 1, CAST(0x00009E9100000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (56, 97, N'The Nature of Alcoholism', 2, CAST(0x00009E9800000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (57, 97, N'How to say NO', 3, CAST(0x00009E9F00000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (58, 97, N'Alcoholism Ahead', 4, CAST(0x00009EA600000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (59, 97, N'Use and Affects of Alcohol', 1, CAST(0x00009EAD00000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (60, 97, N'The Nature of Alcoholism', 2, CAST(0x00009EB400000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (61, 97, N'How to say NO', 3, CAST(0x00009EBB00000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (62, 97, N'Alcoholism Ahead', 4, CAST(0x00009EC200000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (63, 97, N'Use and Affects of Alcohol', 1, CAST(0x00009EC900000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (64, 97, N'The Nature of Alcoholism', 2, CAST(0x00009ED000000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (65, 97, N'How to say NO', 3, CAST(0x00009ED700000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (66, 97, N'Alcoholism Ahead', 4, CAST(0x00009EDE00000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (67, 97, N'Use and Affects of Alcohol', 1, CAST(0x00009EE500000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (68, 97, N'The Nature of Alcoholism', 2, CAST(0x00009EEC00000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (69, 97, N'How to say NO', 3, CAST(0x00009EF300000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (70, 97, N'Alcoholism Ahead', 4, CAST(0x00009EFA00000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (71, 97, N'Use and Affects of Alcohol', 1, CAST(0x00009F0100000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (72, 97, N'The Nature of Alcoholism', 2, CAST(0x00009F0800000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (73, 97, N'How to say NO', 3, CAST(0x00009F0F00000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (74, 97, N'Alcoholism Ahead', 4, CAST(0x00009F1600000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (75, 97, N'Use and Affects of Alcohol', 1, CAST(0x00009F1D00000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (76, 97, N'The Nature of Alcoholism', 2, CAST(0x00009F2400000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (77, 97, N'How to say NO', 3, CAST(0x00009F2B00000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (78, 97, N'Alcoholism Ahead', 4, CAST(0x00009F3200000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (79, 97, N'Use and Affects of Alcohol', 1, CAST(0x00009F3900000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (80, 97, N'The Nature of Alcoholism', 2, CAST(0x00009F4000000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (81, 97, N'How to say NO', 3, CAST(0x00009F4700000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (82, 97, N'Alcoholism Ahead', 4, CAST(0x00009F4E00000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (83, 97, N'Use and Affects of Alcohol', 1, CAST(0x00009F5500000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (84, 97, N'The Nature of Alcoholism', 2, CAST(0x00009F5C00000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (85, 97, N'How to say NO', 3, CAST(0x00009F6300000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (86, 97, N'Alcoholism Ahead', 4, CAST(0x00009F6A00000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (87, 97, N'Use and Affects of Alcohol', 1, CAST(0x00009F7100000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (88, 97, N'The Nature of Alcoholism', 2, CAST(0x00009F7800000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (89, 97, N'How to say NO', 3, CAST(0x00009F7F00000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (90, 97, N'Alcoholism Ahead', 4, CAST(0x00009F8600000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (91, 97, N'Use and Affects of Alcohol', 1, CAST(0x00009F8D00000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (92, 97, N'The Nature of Alcoholism', 2, CAST(0x00009F9400000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (93, 97, N'How to say NO', 3, CAST(0x00009F9B00000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (94, 97, N'Alcoholism Ahead', 4, CAST(0x00009FA200000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (95, 97, N'Use and Affects of Alcohol', 1, CAST(0x00009FA900000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (96, 97, N'The Nature of Alcoholism', 2, CAST(0x00009FB000000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (97, 97, N'How to say NO', 3, CAST(0x00009FB700000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (98, 97, N'Alcoholism Ahead', 4, CAST(0x00009FBE00000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (99, 97, N'Use and Affects of Alcohol', 1, CAST(0x00009FC500000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (100, 97, N'The Nature of Alcoholism', 2, CAST(0x00009FCC00000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (101, 97, N'How to say NO', 3, CAST(0x00009FD300000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (102, 97, N'Alcoholism Ahead', 4, CAST(0x00009FDA00000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (103, 97, N'Use and Affects of Alcohol', 1, CAST(0x00009FE100000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (104, 97, N'The Nature of Alcoholism', 2, CAST(0x00009FE800000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (105, 97, N'How to say NO', 3, CAST(0x00009FEF00000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (106, 97, N'Alcoholism Ahead', 4, CAST(0x00009FF600000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (107, 97, N'Use and Affects of Alcohol', 1, CAST(0x00009FFD00000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (108, 97, N'The Nature of Alcoholism', 2, CAST(0x0000A00400000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (109, 97, N'How to say NO', 3, CAST(0x0000A00B00000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (110, 97, N'Alcoholism Ahead', 4, CAST(0x0000A01200000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (111, 97, N'Use and Affects of Alcohol', 1, CAST(0x0000A01900000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (112, 97, N'The Nature of Alcoholism', 2, CAST(0x0000A02000000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (113, 97, N'How to say NO', 3, CAST(0x0000A02700000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (114, 97, N'Alcoholism Ahead', 4, CAST(0x0000A02E00000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (115, 97, N'Use and Affects of Alcohol', 1, CAST(0x0000A03500000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (116, 97, N'The Nature of Alcoholism', 2, CAST(0x0000A03C00000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (117, 97, N'How to say NO', 3, CAST(0x0000A04300000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (118, 97, N'Alcoholism Ahead', 4, CAST(0x0000A04A00000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (119, 97, N'Use and Affects of Alcohol', 1, CAST(0x0000A05100000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (120, 97, N'The Nature of Alcoholism', 2, CAST(0x0000A05800000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (121, 97, N'How to say NO', 3, CAST(0x0000A05F00000000 AS DateTime), 5, NULL)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (187, 99, N'Use and Affects of Alcohol', 1, CAST(0x0000A00400000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (188, 99, N'The Nature of Alcoholism', 2, CAST(0x0000A00B00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (189, 99, N'Impairment of the Driving Task', 3, CAST(0x0000A01200000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (190, 99, N'Positive Non-Drinking Alternatives', 4, CAST(0x0000A01900000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (191, 99, N'Consequences of Drinking and Driving', 5, CAST(0x0000A02000000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (192, 99, N'Alcohol/Family/Individual/Society', 6, CAST(0x0000A02700000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (193, 99, N'Physio and Psycho Aspects of Alcohol', 7, CAST(0x0000A02E00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (194, 99, N'Alcoholism Ahead', 8, CAST(0x0000A03500000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (195, 99, N'Choice Points and Responsibilities', 9, CAST(0x0000A03C00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (196, 99, N'Decision Making and Goal Setting', 10, CAST(0x0000A04300000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (197, 99, N'How to say NO', 11, CAST(0x0000A04A00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (198, 99, N'Society as a Friendly Pusher', 12, CAST(0x0000A05100000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (199, 99, N'Positive/Negative Lifestyles/Values', 13, CAST(0x0000A05800000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (200, 99, N'Community Resources', 14, CAST(0x0000A05F00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (280, 99, N'Alcohol and the Family', 15, CAST(0x0000A06D00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (281, 99, N'Use and Affects of Alcohol', 1, CAST(0x0000A07400000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (282, 99, N'The Nature of Alcoholism', 2, CAST(0x0000A07B00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (283, 99, N'Impairment of the Driving Task 33344', 3, CAST(0x0000A08200000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (284, 99, N'Positive Non-Drinking Alternatives', 4, CAST(0x0000A08900000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (285, 99, N'Consequences of Drinking and Driving', 5, CAST(0x0000A09000000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (286, 99, N'Alcohol/Family/Individual/Society', 6, CAST(0x0000A09700000000 AS DateTime), 4, 1)

GO

print 'Processed 100 total records'

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (287, 99, N'Physio and Psycho Aspects of Alcohol', 7, CAST(0x0000A09E00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (288, 99, N'Alcoholism Ahead', 8, CAST(0x0000A0A500000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (289, 99, N'Choice Points and Responsibilities', 9, CAST(0x0000A0AC00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (290, 99, N'Decision Making and Goal Setting', 10, CAST(0x0000A0B300000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (291, 99, N'How to say NO', 11, CAST(0x0000A0BA00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (292, 99, N'Society as a Friendly Pusher', 12, CAST(0x0000A0C100000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (293, 99, N'Positive/Negative Lifestyles/Values', 13, CAST(0x0000A0C800000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (294, 99, N'Community Resources', 14, CAST(0x0000A0CF00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (295, 99, N'Alcohol and the Family', 15, CAST(0x0000A0D600000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (296, 99, N'Use and Affects of Alcohol', 1, CAST(0x0000A0DD00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (297, 99, N'The Nature of Alcoholism', 2, CAST(0x0000A0E400000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (298, 99, N'Impairment of the Driving Task 33344', 3, CAST(0x0000A0EB00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (299, 99, N'Positive Non-Drinking Alternatives', 4, CAST(0x0000A0F200000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (300, 99, N'Consequences of Drinking and Driving', 5, CAST(0x0000A0F900000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (301, 99, N'Alcohol/Family/Individual/Society', 6, CAST(0x0000A10000000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (302, 99, N'Physio and Psycho Aspects of Alcohol', 7, CAST(0x0000A10700000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (303, 99, N'Alcoholism Ahead', 8, CAST(0x0000A10E00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (304, 99, N'Choice Points and Responsibilities', 9, CAST(0x0000A11500000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (305, 99, N'Decision Making and Goal Setting', 10, CAST(0x0000A11C00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (306, 99, N'How to say NO', 11, CAST(0x0000A12300000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (307, 99, N'Society as a Friendly Pusher', 12, CAST(0x0000A12A00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (308, 99, N'Positive/Negative Lifestyles/Values', 13, CAST(0x0000A13100000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (309, 99, N'Community Resources', 14, CAST(0x0000A13800000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (310, 99, N'Alcohol and the Family', 15, CAST(0x0000A13F00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (311, 99, N'Use and Affects of Alcohol', 1, CAST(0x0000A14600000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (312, 99, N'The Nature of Alcoholism', 2, CAST(0x0000A14D00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (313, 99, N'Impairment of the Driving Task 33344', 3, CAST(0x0000A15400000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (314, 99, N'Positive Non-Drinking Alternatives', 4, CAST(0x0000A15B00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (315, 99, N'Consequences of Drinking and Driving', 5, CAST(0x0000A16200000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (316, 99, N'Alcohol/Family/Individual/Society', 6, CAST(0x0000A16900000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (317, 99, N'Physio and Psycho Aspects of Alcohol', 7, CAST(0x0000A17000000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (318, 99, N'Alcoholism Ahead', 8, CAST(0x0000A17700000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (319, 99, N'Choice Points and Responsibilities', 9, CAST(0x0000A17E00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (320, 99, N'Decision Making and Goal Setting', 10, CAST(0x0000A18500000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (321, 99, N'How to say NO', 11, CAST(0x0000A18C00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (322, 99, N'Society as a Friendly Pusher', 12, CAST(0x0000A19300000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (323, 99, N'Positive/Negative Lifestyles/Values', 13, CAST(0x0000A19A00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (324, 99, N'Community Resources', 14, CAST(0x0000A1A100000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (325, 99, N'Alcohol and the Family', 15, CAST(0x0000A1A800000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (326, 99, N'Use and Affects of Alcohol', 1, CAST(0x0000A1AF00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (327, 99, N'The Nature of Alcoholism', 2, CAST(0x0000A1B600000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (328, 99, N'Impairment of the Driving Task 33344', 3, CAST(0x0000A1BD00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (329, 99, N'Positive Non-Drinking Alternatives', 4, CAST(0x0000A1C400000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (330, 99, N'Consequences of Drinking and Driving', 5, CAST(0x0000A1CB00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (331, 99, N'Alcohol/Family/Individual/Society', 6, CAST(0x0000A1D200000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (332, 99, N'Physio and Psycho Aspects of Alcohol', 7, CAST(0x0000A1D900000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (333, 99, N'Alcoholism Ahead', 8, CAST(0x0000A1E000000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (334, 99, N'Choice Points and Responsibilities', 9, CAST(0x0000A1E700000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (335, 99, N'Decision Making and Goal Setting', 10, CAST(0x0000A1EE00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (336, 99, N'How to say NO', 11, CAST(0x0000A1F500000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (337, 99, N'Society as a Friendly Pusher', 12, CAST(0x0000A1FC00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (338, 99, N'Positive/Negative Lifestyles/Values', 13, CAST(0x0000A20300000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (339, 99, N'Community Resources', 14, CAST(0x0000A20A00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (340, 99, N'Alcohol and the Family', 15, CAST(0x0000A21100000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (341, 99, N'Use and Affects of Alcohol', 1, CAST(0x0000A21800000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (342, 99, N'The Nature of Alcoholism', 2, CAST(0x0000A21F00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (343, 99, N'Impairment of the Driving Task 33344', 3, CAST(0x0000A22600000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (344, 99, N'Positive Non-Drinking Alternatives', 4, CAST(0x0000A22D00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (345, 99, N'Consequences of Drinking and Driving', 5, CAST(0x0000A23400000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (346, 99, N'Alcohol/Family/Individual/Society', 6, CAST(0x0000A23B00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (347, 99, N'Physio and Psycho Aspects of Alcohol', 7, CAST(0x0000A24200000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (348, 99, N'Alcoholism Ahead', 8, CAST(0x0000A24900000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (349, 99, N'Choice Points and Responsibilities', 9, CAST(0x0000A25000000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (350, 99, N'Decision Making and Goal Setting', 10, CAST(0x0000A25700000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (351, 99, N'How to say NO', 11, CAST(0x0000A25E00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (352, 99, N'Society as a Friendly Pusher', 12, CAST(0x0000A26500000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (353, 99, N'Positive/Negative Lifestyles/Values', 13, CAST(0x0000A26C00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (354, 99, N'Community Resources', 14, CAST(0x0000A27300000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (355, 99, N'Alcohol and the Family', 15, CAST(0x0000A27A00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (356, 99, N'Use and Affects of Alcohol', 1, CAST(0x0000A28100000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (357, 99, N'The Nature of Alcoholism', 2, CAST(0x0000A28800000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (358, 99, N'Impairment of the Driving Task 33344', 3, CAST(0x0000A28F00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (438, 99, N'Positive Non-Drinking Alternatives', 4, CAST(0x0000A29D00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (439, 99, N'Consequences of Drinking and Driving', 5, CAST(0x0000A2A400000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (440, 99, N'Alcohol/Family/Individual/Society', 6, CAST(0x0000A2AB00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (441, 99, N'Physio and Psycho Aspects of Alcohol', 7, CAST(0x0000A2B200000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (442, 99, N'Alcoholism Ahead', 8, CAST(0x0000A2B900000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (443, 99, N'Choice Points and Responsibilities', 9, CAST(0x0000A2C000000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (444, 99, N'Decision Making and Goal Setting', 10, CAST(0x0000A2C700000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (445, 99, N'How to say NO', 11, CAST(0x0000A2CE00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (446, 99, N'Society as a Friendly Pusher', 12, CAST(0x0000A2D500000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (447, 99, N'Positive/Negative Lifestyles/Values', 13, CAST(0x0000A2DC00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (448, 99, N'Community Resources', 14, CAST(0x0000A2E300000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (449, 99, N'Alcohol and the Family', 15, CAST(0x0000A2EA00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (450, 99, N'Use and Affects of Alcohol', 1, CAST(0x0000A2F100000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (451, 99, N'The Nature of Alcoholism', 2, CAST(0x0000A2F800000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (452, 99, N'Impairment of the Driving Task 33344', 3, CAST(0x0000A2FF00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (453, 99, N'Positive Non-Drinking Alternatives', 4, CAST(0x0000A30600000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (454, 99, N'Consequences of Drinking and Driving', 5, CAST(0x0000A30D00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (455, 99, N'Alcohol/Family/Individual/Society', 6, CAST(0x0000A31400000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (456, 99, N'Physio and Psycho Aspects of Alcohol', 7, CAST(0x0000A31B00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (457, 99, N'Alcoholism Ahead', 8, CAST(0x0000A32200000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (458, 99, N'Choice Points and Responsibilities', 9, CAST(0x0000A32900000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (459, 99, N'Decision Making and Goal Setting', 10, CAST(0x0000A33000000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (460, 99, N'How to say NO', 11, CAST(0x0000A33700000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (461, 99, N'Society as a Friendly Pusher', 12, CAST(0x0000A33E00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (462, 99, N'Positive/Negative Lifestyles/Values', 13, CAST(0x0000A34500000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (463, 99, N'Community Resources', 14, CAST(0x0000A34C00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (464, 99, N'Alcohol and the Family', 15, CAST(0x0000A35300000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (465, 99, N'Use and Affects of Alcohol', 1, CAST(0x0000A35A00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (466, 99, N'The Nature of Alcoholism', 2, CAST(0x0000A36100000000 AS DateTime), 4, 1)

GO

print 'Processed 200 total records'

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (467, 99, N'Impairment of the Driving Task 33344', 3, CAST(0x0000A36800000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (468, 99, N'Positive Non-Drinking Alternatives', 4, CAST(0x0000A36F00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (469, 99, N'Consequences of Drinking and Driving', 5, CAST(0x0000A37600000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (470, 99, N'Alcohol/Family/Individual/Society', 6, CAST(0x0000A37D00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (471, 99, N'Physio and Psycho Aspects of Alcohol', 7, CAST(0x0000A38400000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (472, 99, N'Alcoholism Ahead', 8, CAST(0x0000A38B00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (473, 99, N'Choice Points and Responsibilities', 9, CAST(0x0000A39200000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (474, 99, N'Decision Making and Goal Setting', 10, CAST(0x0000A39900000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (475, 99, N'How to say NO', 11, CAST(0x0000A3A000000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (476, 99, N'Society as a Friendly Pusher', 12, CAST(0x0000A3A700000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (477, 99, N'Positive/Negative Lifestyles/Values', 13, CAST(0x0000A3AE00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (478, 99, N'Community Resources', 14, CAST(0x0000A3B500000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (479, 99, N'Alcohol and the Family', 15, CAST(0x0000A3BC00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (480, 99, N'Use and Affects of Alcohol', 1, CAST(0x0000A3C300000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (481, 99, N'The Nature of Alcoholism', 2, CAST(0x0000A3CA00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (482, 99, N'Impairment of the Driving Task 33344', 3, CAST(0x0000A3D100000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (483, 99, N'Positive Non-Drinking Alternatives', 4, CAST(0x0000A3D800000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (484, 99, N'Consequences of Drinking and Driving', 5, CAST(0x0000A3DF00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (485, 99, N'Alcohol/Family/Individual/Society', 6, CAST(0x0000A3E600000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (486, 99, N'Physio and Psycho Aspects of Alcohol', 7, CAST(0x0000A3ED00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (487, 99, N'Alcoholism Ahead', 8, CAST(0x0000A3F400000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (488, 99, N'Choice Points and Responsibilities', 9, CAST(0x0000A3FB00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (489, 99, N'Decision Making and Goal Setting', 10, CAST(0x0000A40200000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (490, 99, N'How to say NO', 11, CAST(0x0000A40900000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (491, 99, N'Society as a Friendly Pusher', 12, CAST(0x0000A41000000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (492, 99, N'Positive/Negative Lifestyles/Values', 13, CAST(0x0000A41700000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (493, 99, N'Community Resources', 14, CAST(0x0000A41E00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (494, 99, N'Alcohol and the Family', 15, CAST(0x0000A42500000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (495, 99, N'Use and Affects of Alcohol', 1, CAST(0x0000A42C00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (496, 99, N'The Nature of Alcoholism', 2, CAST(0x0000A43300000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (497, 99, N'Impairment of the Driving Task 33344', 3, CAST(0x0000A43A00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (498, 99, N'Positive Non-Drinking Alternatives', 4, CAST(0x0000A44100000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (499, 99, N'Consequences of Drinking and Driving', 5, CAST(0x0000A44800000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (500, 99, N'Alcohol/Family/Individual/Society', 6, CAST(0x0000A44F00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (501, 99, N'Physio and Psycho Aspects of Alcohol', 7, CAST(0x0000A45600000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (502, 99, N'Alcoholism Ahead', 8, CAST(0x0000A45D00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (503, 99, N'Choice Points and Responsibilities', 9, CAST(0x0000A46400000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (504, 99, N'Decision Making and Goal Setting', 10, CAST(0x0000A46B00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (505, 99, N'How to say NO', 11, CAST(0x0000A47200000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (506, 99, N'Society as a Friendly Pusher', 12, CAST(0x0000A47900000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (507, 99, N'Positive/Negative Lifestyles/Values', 13, CAST(0x0000A48000000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (508, 99, N'Community Resources', 14, CAST(0x0000A48700000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (509, 99, N'Alcohol and the Family', 15, CAST(0x0000A48E00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (510, 99, N'Use and Affects of Alcohol', 1, CAST(0x0000A49500000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (511, 99, N'The Nature of Alcoholism', 2, CAST(0x0000A49C00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (512, 99, N'Impairment of the Driving Task 33344', 3, CAST(0x0000A4A300000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (513, 99, N'Positive Non-Drinking Alternatives', 4, CAST(0x0000A4AA00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (514, 99, N'Consequences of Drinking and Driving', 5, CAST(0x0000A4B100000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (515, 99, N'Alcohol/Family/Individual/Society', 6, CAST(0x0000A4B800000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (516, 99, N'Physio and Psycho Aspects of Alcohol', 7, CAST(0x0000A4BF00000000 AS DateTime), 4, 1)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (596, 100, N'How to say NO', 11, CAST(0x00009E5200000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (597, 100, N'Society as a Friendly Pusher', 12, CAST(0x00009E5900000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (598, 100, N'Positive/Negative Lifestyles/Values', 13, CAST(0x00009E6000000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (599, 100, N'Community Resources', 14, CAST(0x00009E6700000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (600, 100, N'Alcohol and the Family', 15, CAST(0x00009E6E00000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (601, 100, N'Use and Affects of Alcohol', 1, CAST(0x00009E7500000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (602, 100, N'The Nature of Alcoholism', 2, CAST(0x00009E7C00000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (603, 100, N'Impairment of the Driving Task 33344', 3, CAST(0x00009E8300000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (604, 100, N'Positive Non-Drinking Alternatives', 4, CAST(0x00009E8A00000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (605, 100, N'Consequences of Drinking and Driving', 5, CAST(0x00009E9100000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (606, 100, N'Alcohol/Family/Individual/Society', 6, CAST(0x00009E9800000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (607, 100, N'Physio and Psycho Aspects of Alcohol', 7, CAST(0x00009E9F00000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (608, 100, N'Alcoholism Ahead', 8, CAST(0x00009EA600000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (609, 100, N'Choice Points and Responsibilities', 9, CAST(0x00009EAD00000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (610, 100, N'Decision Making and Goal Setting', 10, CAST(0x00009EB400000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (611, 100, N'How to say NO', 11, CAST(0x00009EBB00000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (612, 100, N'Society as a Friendly Pusher', 12, CAST(0x00009EC200000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (613, 100, N'Positive/Negative Lifestyles/Values', 13, CAST(0x00009EC900000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (614, 100, N'Community Resources', 14, CAST(0x00009ED000000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (615, 100, N'Alcohol and the Family', 15, CAST(0x00009ED700000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (616, 100, N'Use and Affects of Alcohol', 1, CAST(0x00009EDE00000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (617, 100, N'The Nature of Alcoholism', 2, CAST(0x00009EE500000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (618, 100, N'Impairment of the Driving Task 33344', 3, CAST(0x00009EEC00000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (619, 100, N'Positive Non-Drinking Alternatives', 4, CAST(0x00009EF300000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (620, 100, N'Consequences of Drinking and Driving', 5, CAST(0x00009EFA00000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (621, 100, N'Alcohol/Family/Individual/Society', 6, CAST(0x00009F0100000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (622, 100, N'Physio and Psycho Aspects of Alcohol', 7, CAST(0x00009F0800000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (623, 100, N'Alcoholism Ahead', 8, CAST(0x00009F0F00000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (624, 100, N'Choice Points and Responsibilities', 9, CAST(0x00009F1600000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (625, 100, N'Decision Making and Goal Setting', 10, CAST(0x00009F1D00000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (626, 100, N'How to say NO', 11, CAST(0x00009F2400000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (627, 100, N'Society as a Friendly Pusher', 12, CAST(0x00009F2B00000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (628, 100, N'Positive/Negative Lifestyles/Values', 13, CAST(0x00009F3200000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (629, 100, N'Community Resources', 14, CAST(0x00009F3900000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (630, 100, N'Alcohol and the Family', 15, CAST(0x00009F4000000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (631, 100, N'Use and Affects of Alcohol', 1, CAST(0x00009F4700000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (632, 100, N'The Nature of Alcoholism', 2, CAST(0x00009F4E00000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (633, 100, N'Impairment of the Driving Task 33344', 3, CAST(0x00009F5500000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (634, 100, N'Positive Non-Drinking Alternatives', 4, CAST(0x00009F5C00000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (635, 100, N'Consequences of Drinking and Driving', 5, CAST(0x00009F6300000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (636, 100, N'Alcohol/Family/Individual/Society', 6, CAST(0x00009F6A00000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (637, 100, N'Physio and Psycho Aspects of Alcohol', 7, CAST(0x00009F7100000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (638, 100, N'Alcoholism Ahead', 8, CAST(0x00009F7800000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (639, 100, N'Choice Points and Responsibilities', 9, CAST(0x00009F7F00000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (640, 100, N'Decision Making and Goal Setting', 10, CAST(0x00009F8600000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (641, 100, N'How to say NO', 11, CAST(0x00009F8D00000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (642, 100, N'Society as a Friendly Pusher', 12, CAST(0x00009F9400000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (643, 100, N'Positive/Negative Lifestyles/Values', 13, CAST(0x00009F9B00000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (644, 100, N'Community Resources', 14, CAST(0x00009FA200000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (645, 100, N'Alcohol and the Family', 15, CAST(0x00009FA900000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (646, 100, N'Use and Affects of Alcohol', 1, CAST(0x00009FB000000000 AS DateTime), 8, 3)

GO

print 'Processed 300 total records'

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (647, 100, N'The Nature of Alcoholism', 2, CAST(0x00009FB700000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (648, 100, N'Impairment of the Driving Task 33344', 3, CAST(0x00009FBE00000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (649, 100, N'Positive Non-Drinking Alternatives', 4, CAST(0x00009FC500000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (650, 100, N'Consequences of Drinking and Driving', 5, CAST(0x00009FCC00000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (651, 100, N'Alcohol/Family/Individual/Society', 6, CAST(0x00009FD300000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (652, 100, N'Physio and Psycho Aspects of Alcohol', 7, CAST(0x00009FDA00000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (653, 100, N'Alcoholism Ahead', 8, CAST(0x00009FE100000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (654, 100, N'Choice Points and Responsibilities', 9, CAST(0x00009FE800000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (655, 100, N'Decision Making and Goal Setting', 10, CAST(0x00009FEF00000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (656, 100, N'How to say NO', 11, CAST(0x00009FF600000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (657, 100, N'Society as a Friendly Pusher', 12, CAST(0x00009FFD00000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (658, 100, N'Positive/Negative Lifestyles/Values', 13, CAST(0x0000A00400000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (659, 100, N'Community Resources', 14, CAST(0x0000A00B00000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (660, 100, N'Alcohol and the Family', 15, CAST(0x0000A01200000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (661, 100, N'Use and Affects of Alcohol', 1, CAST(0x0000A01900000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (662, 100, N'The Nature of Alcoholism', 2, CAST(0x0000A02000000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (663, 100, N'Impairment of the Driving Task 33344', 3, CAST(0x0000A02700000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (664, 100, N'Positive Non-Drinking Alternatives', 4, CAST(0x0000A02E00000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (665, 100, N'Consequences of Drinking and Driving', 5, CAST(0x0000A03500000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (666, 100, N'Alcohol/Family/Individual/Society', 6, CAST(0x0000A03C00000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (667, 100, N'Physio and Psycho Aspects of Alcohol', 7, CAST(0x0000A04300000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (668, 100, N'Alcoholism Ahead', 8, CAST(0x0000A04A00000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (669, 100, N'Choice Points and Responsibilities', 9, CAST(0x0000A05100000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (670, 100, N'Decision Making and Goal Setting', 10, CAST(0x0000A05800000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (671, 100, N'How to say NO', 11, CAST(0x0000A05F00000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (672, 100, N'Society as a Friendly Pusher', 12, CAST(0x0000A06600000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (673, 100, N'Positive/Negative Lifestyles/Values', 13, CAST(0x0000A06D00000000 AS DateTime), 8, 3)

INSERT [dbo].[DUIClassInstances] ([cInstID], [ClassID], [PrgTopic], [PrgSeq], [ClassDate], [CounselorID], [ProgramID]) VALUES (674, 100, N'Community Resources', 14, CAST(0x0000A07400000000 AS DateTime), 8, 3)

SET IDENTITY_INSERT [dbo].[DUIClassInstances] OFF

/****** Object: Table [dbo].[ClassTypes] Script Date: 12/31/2010 16:53:16 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[ClassTypes](

[ClassTypeID] [int] IDENTITY(1,1) NOT NULL,

[ClassTypeChar] [nvarchar](1) NULL,

[ClassTypeDesc] [nvarchar](50) NULL,

CONSTRAINT [PK_ClassTypes] PRIMARY KEY CLUSTERED

(

[ClassTypeID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET IDENTITY_INSERT [dbo].[ClassTypes] ON

INSERT [dbo].[ClassTypes] ([ClassTypeID], [ClassTypeChar], [ClassTypeDesc]) VALUES (2, N'G', N'Group')

INSERT [dbo].[ClassTypes] ([ClassTypeID], [ClassTypeChar], [ClassTypeDesc]) VALUES (3, N'E', N'Education')

INSERT [dbo].[ClassTypes] ([ClassTypeID], [ClassTypeChar], [ClassTypeDesc]) VALUES (4, N'F', N'Face2Face')

INSERT [dbo].[ClassTypes] ([ClassTypeID], [ClassTypeChar], [ClassTypeDesc]) VALUES (10, N'A', N'Absence')

INSERT [dbo].[ClassTypes] ([ClassTypeID], [ClassTypeChar], [ClassTypeDesc]) VALUES (11, N'M', N'Meeting')

INSERT [dbo].[ClassTypes] ([ClassTypeID], [ClassTypeChar], [ClassTypeDesc]) VALUES (12, N'P', N'Phase 2')

SET IDENTITY_INSERT [dbo].[ClassTypes] OFF

akhandels Right there with Babe Points: 731 More actions · Answer 5

The query shows two rows for each cInstID because the data has two classTypeId in classType table. It seems like there is nothing wrong with the query; if the query results appear incorrect please look into your data. Most likely it is due to bad data.

Also, as a design good practice, there needs to be foreign key constraints added.

Thanks.

john-902052 SSCommitted Points: 1578 More actions · Answer 6

Your reply doesn't make any sense. The columns for ClassTypes are ClassTypeID, ClassTypeChar and ClassTypeDesc. Why if it is dup data is it that they duplicate records only appear when I call for a column?

LutzM SSC Guru Points: 107049 More actions · Answer 7

The result makes perfectly sense to me:

Let's look at an example:

[cInstID]=187

Without the two columns in question you have one row only. But as soon as you include one of the both columns ct.ClassTypeID or ClassTypeChar you'll get two rows, because for [cInstID]=187 you have [ClassTypeID] values 2 and 3 and [ClassTypeChar] values 'G' and 'E'.

Since those values are different, they'll double the number of rows.

You could use min/max (you'd need to change your DISTINCT into a GROUP BY), a specific value in a WHERE condition (e.g. [ClassTypeID] = 2) or any other method that'll return your expected result.

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

john-902052 SSCommitted Points: 1578 More actions · Answer 8

Please forgive me but I just am not understanding. CInstID is an identity column so there can not be two in the same table. The data only has one row for the cInstID=187 and so the doubling is happening in the query.

At the end of the day all I am trying to do is get the list of PartClassAssignments >= today with the ClassTypeChar field.

I do appreciate your willingness to help me out on this.

LutzM SSC Guru Points: 107049 More actions · Answer 9

john-902052 (1/1/2011)
Please forgive me but I just am not understanding. CInstID is an identity column so there can not be two in the same table. The data only has one row for the cInstID=187 and so the doubling is happening in the query.
At the end of the day all I am trying to do is get the list of PartClassAssignments >= today with the ClassTypeChar field.
I do appreciate your willingness to help me out on this.

You're right in terms of the single table. But due to your join conditions you'll multiply the number of rows. The table responsible for the cross join is PrgCycleItemToProgramXref. Just include pci.PrgCycleItemID in your SELECT DISTINCT statement and you'll see where the problem starts.

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

LutzM SSC Guru Points: 107049 More actions · Answer 10

I'm not sure about your data structure but maybe all that's missing is to include a join on the Seq columns: xr.ProgramID = d.ProgramID AND d.PrgSeq = xr.Seq

Edit: and as s side effect, you won't need your DISTINCT anymore....

DISITNCT sometimes is misused to overcome either missing join or where conditions or a bad database design. 😉

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 11

akhandels (12/31/2010)
In SQL Server 2008 management studio, DDL & DML can be scripted using the wizard like this:
http://www.kodyaz.com/articles/sql-server-script-data-with-generate-script-wizard.aspx
This is the fastest way to script DDL and data.
Thank You.

Cracker hint 😀

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)