Thanks. I will wait till later.

There are rows which do not contain the 3 letter character representation of a week day at characters 2 through 4. They are:

'[Spreadsheet Extractor Big Block Allocs -- Dyn.Calc.Cache...

Why does the clustered index improve performance. More specifically, what is the clustered index doing that is different? I will try this once I get into work.

Also Jeff Moden earlier...

How did you replace my indexes with a clustered index? Were they added to the apllication and user table?

there are indexes on the Application and User Tables. My previous post has all the structures and sampl data which i should have posted initially.

I have now added sample data along with all the code for tables and indexes etc. Hopefully this will make things clearer

---tables

CREATE TABLE [stg_LogFiles] (

...

my tables are:

---index

CREATE

INDEX [IX_FirstFour] ON stg_LogFiles ([Firstfour])

WITH

DROP_EXISTING

ON [PRIMARY]

---tables

CREATE TABLE [stg_LogFiles] (

[LineRead] [varchar] (100) COLLATE Latin1_General_CI_AS NULL ,

[Importeddate] [datetime] NULL CONSTRAINT [DF__stg_LogFi__Impor__5441852A] DEFAULT (getdate()),

[Firstfour]...

I created the computed column and the index on that column. The computed column is as follows

--Add Computed Column

ALTER TABLE MyTable

ADD comp_column AS substring(LineRead,2,4) varchar

--Create Column

CREATE INDEX IX_COMPColumn ON...

If i add the computed colum presumably the index to create is a non clustered index?

Hey, thanks guys for your help. I actually decided to to look into the execution plan myself and try and work something out. I have managed to get it down...

Sorry about the post. I am doing a thousand things at once. I have reposted the execution plan with hopefully the right infoemation. Excuse me for making mistakes as I...

Apologies for the double posting of this topic and any other confusion. Initially I was testing this in a sql 2000 environment which is why there is an original post...

I have included a rtf file showing the graphical representation of the execution plan.

Regards

I managed to solve this myself. The DO command had to be on the same line as the for /f "tokens = 1,2,3".....

Regards

Sauce1979

Many thanks. Much appreciated.