Here it is

CREATE TABLE [dbo].[IX_SubInspectionTypes](

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

[SubInspectionTypeId] [int] NULL,

[InspectionItemId] [int] NULL,

[Active] [bit] NULL,

CONSTRAINT [PK_IX_SubInspectionTypes] PRIMARY KEY NONCLUSTERED

(

[ItemId] ASC

)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]

) ON [PRIMARY]

209True

134064True

12910934True

1044504314True

1445905988True

1437806012True

CREATE TABLE...

exactly.

also you can check the result set i have posted.

Here it is

TAble Inspectionitems

CREATE TABLE [dbo].[InspectionItems](

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

[TypeId] [int] NULL,

[FloorId] [int] NOT NULL,

[ProgramInstanceId] [int] NULL,

[InspectionItemName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[ZoneInstanceId] [int] NULL,

[Active] [bit] NULL CONSTRAINT [DF_InspectionItems_Active] DEFAULT...

Donald L Berndt II

can i expect any help from you regarding my store proc. I guess,am not able to use CTE's in the right way?

help

Hey Lynn

I really appreciate you prompt replies, though u cudnt spend time on this but am happy with your inputs.

I understand your job will be priority for you. Atleast with...

guys thanks for your hep so far.

I was just looking for something like CTE's which can replace cursors. I didnt work much on 2005 or CTE's. appreciate for that.

Lynn Pettis

I hope i gave everything u asked?

can this be done through CTE's or some simple queries.

help

guys any help, its really urgent for me.

I was expecting there shud be something we cana do in 2005.

Any suggestions on how can i run this without using cursors.

appreciate your inputs here.

But still i just wonder why wud it take 2 days to delete 15 million records.

this topic refers to this

http://www.sqlservercentral.com/Forums/Topic514630-338-1.aspx