Your correct it was a lookup table that I added later on in the project and didn't go back and fix the old records.

Thanks so much.

Exactly it was like setting up the problem linked me into the borg consciousness and I solved the problem.

I am so sorry I forgot to say thank you.

So....

Thank you very much for helping.

WOW! you guys are so awesome and fast. No it is not real data it is just demo data that looks real, names, dob etc have been changed to protect...

No this is a scheduling system. Don't really have any love for DISTINCT. I am a newbie T-SQL programmer who picked it up on my own.

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...

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...

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]...

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

Here here Mr. Poole great points. I have blogged extensively about this very topic.

http://www.seitmc.com/BlogEngine/

I have been working at home for more than 10 years now and love it. I worked for IBM for 8 years from home and was on of IBM's...

Everything right now is in SPs I just have a bunch of little ones like

select * from Table where Key = @key

was looking for a better (safe) way...

Wow thanks for the encouragement and the reminder of why I don't post here often.

I would love to understand your code.

:w00t: That is completely over my head bu thanks