I am not worthy!:-D Worked like a charm. Thank you very much!

Norm Hill

Lynn,

Thanks for bearing with me.

My Data:

SELECT 'STUDENT','STUDENT1','Class1','<< Not Set >>',1 UNION ALL

SELECT 'STUDENT','STUDENT2','Class1','<< Not Set >>',1 UNION ALL

SELECT 'STUDENT','STUDENT3','Class2','Registered',1 UNION ALL

SELECT...

K. Cline,

Thanks for responding but the issue is that WaitList for Class1 should have a 1 not 4 and Class1 should have...

Makes sense WayneS. Here's a go at providing the pertinent information:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- if the Classes Table exists, drop it

IF OBJECT_ID('MyDB..Classes','U') IS NOT NULL

DROP TABLE CLASSES

-- CREATE...