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...

david.alcock (2/22/2012)

---

Many thanks, I was trying to simplify the script, appreciate a more concise example would have been a bit more helpful. Is there a way, like having the...

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. ...

Is this is what you need?

select

'SUPPLIER' as 'PEOPLE/Person/@role',

'Some persons' as 'PEOPLE/Name'

for xml path('')

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...

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...

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...

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...

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...

Eugene Elutin – Very creative. Learned my lesson for today:-)

Adi

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...

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...

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...

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...

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...