Glad you got it sorted.

Your solution would indicate a problem with user rights as previously suggested. If i am not mistaken you need to use a different connection to execute...

Do you have a specific problem with this process or are you just looking for a "How to"?

If the latter is the case then i would have a look...

Thanks for your reply but the disabled items do not effect the outcome of the loop. All they do is move or delete the files once processed.

Its a bit lazy but why not just update the table after the bulk load has finished?

Forgot to mention, i have also made a post about the same issue on experts exchane. No one has come up with a solution as good as yours, so would...

Thanks for the explination. Always good to learn something new.

I am in the process of checking the data now.

Thanks again

Hi RBarryYoung.

Thanks so much for your hard work. I ran the script (the one that uses tmp tables) this morning and results were returned in just over 20mins. Since...

Thank you SO MUCH for all of your hard work and over a weekend too. I am away from my computer until monday but will start testing it first thing...

Thats for that. have run it and it does not seem to have helped. Without searching for name variations the query takes 17 seconds. I have let it run for...

CREATE TABLE [dbo].[Surname](

[Source_Name] [varchar](20) NOT NULL,

[Name_Variation] [varchar](20) NOT NULL,

[Score] [int] NOT NULL

) ON [PRIMARY]

Both surname and forename tables are the same. There is a clustered index on the source_name column....

Sorry, my mistake. the AVP alias is the same as the P alias. I have changed the name of the table (and i thought all of the aliases) to remove...

Thanks, i will try that. It wont effect the query at the mo becuase its the initial cross join that is causing the problems. Also each of the sub selects...

Thanks for the links. I have had a look and i do not think that the fuzzy matching is the correct route for me to go down.

The names...

Thanks for your answer Samuel.

I know its a bit cheeky, but would you be able to provide some more information as to how i would use the fuzzy transformation to...

Actually, it was my mistake. It was complaining because i was inserting the rowguid. Take that out and it all works fine.:D