Where the partnerid = 11 I want to change it to 26 assuming all the other conditions in the where statement are true as well.

Thanks everyone for your help. It's much appreciated. I have my final where clause all sorted now.

Thanks again.

Thanks Jamie. That's seems to have done the trick. Now I just need to get my where clause to exclude those descriptions with zzz and yyy at the beginning...

Here is the sample data. Neither one of these clients bought bicycles. I have added the customer part to the query as well and still get the same results.

Name ...

Sorry guys, but I don't know what sample data would do when it's wrong.....I want every customer that has bought a bicycle and every other purchase too.....if they haven't bought...

Sorry to be a pain, but before I've even add the extra where clauses it doesn't appear to be giving me the correct results. I get 90000 records back when...

That's awesome. Thank you so much. I don't want to push the friendship but they have just now asked me if I can exlude anything that starts with...

This is what I have so far.

SELECT Customer.Name AS SortName,

vcltAttrib4_364.ainTVal AS Client_Relationship_Partner,

vFEAttrib4.attInstName AS Partner,

Matter.mtrDesc AS Description,

Matter.mtrDateOpened AS Date_Opened,

Matter.mtrDateClosed AS Date_Closed

FROM ((((Customer LEFT OUTER JOIN...

Thanks for that I think you might be right. That's the problem is there are no error message of any use. Just "Alter failed for Server 'Servername'" and in...

yes. Permissions are not an issue. I'm running the script as sys admin.

I'm not trying to delete the error logs, I'm trying to delete all file with the extension of txt. It's SQL 2005 SP2. I tried the script and same thing....

This is a third party web site and database. SQL sites on one box and the web app sits on the other. As a general rule all the SQL...

I'm not sure what you mean but it is sampling data every second on vertical scale max 100 and min 0. Is that what you meant?

Maybe I'm not understanding but my issue is not with the CPU. It's doing everything I would expect it's the fact that the Processor Queue Length won't go below...

It appears while the tables in all the 3 databases are called the same they don't always contain the same columns. There is around 10 tables in each database...