ThomasH,

Thankyou for your comments.

I will copy the SQL into NotePad and format the joins to identify any duplicates. I don't understand why they are in there as I am using...

ThomasH,

Thankyou for your ideas.

I have tried the derived Table link and this is the results.

Prior to adding the derived link to my select the view took 45 seconds when executing...

The view I changed its one of the selected Columns in this view. It is a column in the tcOrder file. The column too had nothing to do with Indexes...

I have just tried to put it into the SQL code but the layout and results grid go grey when I run it an the error appears. This is my...

This is the code I am using...

case dbo.tcOrder.Approved when 1 then Adjusted_Number_Of_Days_Shipped_Early_Or_Late else Number_Of_Days_Shipped_Early_Or_Late end

Which column of the View Designer grid do I paste this into? I have tried the...