Does the following example help you?

http://howto.thibeault.cc/2008/02/join-sql-update.html

Please provide the schema and so dummy data...

Try the following URL's, I hope this helps:

http://stackoverflow.com/questions/164593/how-do-i-install-sql-server-odbc-driver

http://msdn.microsoft.com/en-us/library/ms131321.aspx

What is the relationship between Purchasing and Vault_043011?

Why are we joining on a value as opposed to a common field?

Could you be more specific as to your objective?

As you mentioned you do not know all of the Business Requirements.

You may want to get clarification on the requirements and fully understand them before you proceed.

You stated that a...

How do you identify a new client?

I would start by rewriting a query that incudes all of the column, aggregates and tables that you need.

Try to avoid <>, instead use...

You need to be more than a Local Admin. You need to be a Domain Admin or a Local Admin on each Server that you are accessing resources within your...

You need an Account that has the minimum permissions to read, write to access whatever resources that you need.

It is not recommended using a Domain Account for it grants excessive...

You can use sp_who or sp_who_2 or sp_who3, or the DMV's and DBCC OPENTRAN.

Listed in the following URL is an article that contains a Stored that references the system tables:

http://sqlserverplanet.com/dmv-queries/a-better-sp_who2-using-dmvs-sp_who3

The Administrative Account that you are using is not a Domain Admin it is a Local Admin.

What Accounts do you use for the SQL Server Agent on other SQL Server...

If your objective is to :

Return the sum of all transactions for all NEW clients, grouped by broker Name

Then why are you doing the following?

group by clients.clientkey, masterclientkey, name

Why are...

Do you have table definitions, to include FK Constraints & sample data?

Could you restate the question for it could easily be misinterpreted?

Have you checked the connections to the Database?

Are there jobs running, user connections or open transactions?

Regards,

Welsh

Did you notice the following paragraph in the link that I sent you?

You stated that you are using the Local Service Account.

Do not select the Local Service account. The SQL...