Viewing 15 posts - 361 through 375 (of 1,478 total)
Hi David
My remark was not meant to make feel bad. You have to understand that using a script and showing us what you need, helps most...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
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/
February 22, 2012 at 9:24 am
david.alcock (2/22/2012)
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
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/
February 22, 2012 at 6:22 am
If the procedure doesn’t have a query plan in the cache, it generate one according to the parameters that were passed and then stores that plan in the cache. ...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
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/
February 22, 2012 at 4:01 am
Is this is what you need?
select
'SUPPLIER' as 'PEOPLE/Person/@role',
'Some persons' as 'PEOPLE/Name'
for xml path('')
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
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/
February 22, 2012 at 3:29 am
I’m sorry, but I can’t understand what you need. Can you post a small script that creates a table, inserts few records into the table and then show us...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
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/
February 22, 2012 at 3:12 am
The code will do just what it is suppose to do. It will begin the transaction, then will do all the DML statements as part of the transaction (regardless...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
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/
February 15, 2012 at 2:11 am
Here is a post that looks similar to your post http://claysql.blogspot.com/2011/06/sql-server-error-occurred-while.html . Although the poster did not write that it has no error message when switches to...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
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/
February 15, 2012 at 1:59 am
Did you try any search engine before posting the question? I just used Google on the phrase " An error occurred while executing batch. Error message is: The directory...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
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/
February 14, 2012 at 10:49 pm
You can do it with just an update statement that works with the ranking functions (in your case dense_rank function and a CTE). Here is an example that...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
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/
February 14, 2012 at 10:31 pm
Eugene Elutin – Very creative. Learned my lesson for today:-)
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
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/
February 14, 2012 at 10:23 am
This is taken from BOL “The CREATE PROCEDURE statement cannot be combined with other Transact-SQL statements in a single batch.”
You have few ways to work around it. One...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
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/
February 14, 2012 at 9:20 am
I have to admit that I didn’t have such problem, so I’m not writing from experience, but if I’d run into this situation this would be the things that I’d...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
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/
February 14, 2012 at 4:06 am
Sorry but I didn’t understand what you need. I’ve also noticed that there are many readers to your question, but no answer yet. I suggest that you’ll...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
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/
February 14, 2012 at 1:47 am
The syntax is correct, but of course it does nothing because you are rollbacking the transaction. If what you intended to do is to delete some rows and then...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
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/
February 8, 2012 at 10:54 am
I had to do it once, and I changed the insert and update procedures that the replication created in the target database. In the procedures instead of using the...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
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/
February 7, 2012 at 10:31 pm
Viewing 15 posts - 361 through 375 (of 1,478 total)