Viewing 15 posts - 3,196 through 3,210 (of 3,738 total)
Does the following example help you?
http://howto.thibeault.cc/2008/02/join-sql-update.html
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 11, 2011 at 3:07 pm
Please provide the schema and so dummy data...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 11, 2011 at 2:57 pm
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
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 11, 2011 at 2:53 pm
What is the relationship between Purchasing and Vault_043011?
Why are we joining on a value as opposed to a common field?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 11, 2011 at 2:41 pm
Could you be more specific as to your objective?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 11, 2011 at 2:28 pm
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 11, 2011 at 2:25 pm
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 11, 2011 at 12:43 pm
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 11, 2011 at 11:40 am
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 11, 2011 at 11:22 am
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
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 11, 2011 at 11:00 am
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 11, 2011 at 10:53 am
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 11, 2011 at 10:20 am
Do you have table definitions, to include FK Constraints & sample data?
Could you restate the question for it could easily be misinterpreted?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 11, 2011 at 10:07 am
Have you checked the connections to the Database?
Are there jobs running, user connections or open transactions?
Regards,
Welsh
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 11, 2011 at 9:58 am
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 11, 2011 at 9:49 am
Viewing 15 posts - 3,196 through 3,210 (of 3,738 total)