The query is used for a rather complex computation needed in the result of a highly used stored procedure.

Occasionally, the execution plan would include a Hash Join operator in a...

Thanks for helping me identify a query where by using OPTION(RECOMPILE) I was able to reduce execution time of "completely unpredictable" to a few seconds. 🙂

Who knows. 🙂

The OP never came back with a sample as comprehensive as yours. 😉

Try this:

declare@resultxml

set@result

= (

selectTests.Test.query('Id')

,Tests.Test.query('Name')

,Tests.Test.query('Inputs')

,TestResults.Results.query('child::*')

from@xmlinput.nodes

('

/Tests/Test

') Tests (Test)

inner joinTestResults

onTestResults.RequestId = Tests.Test.query('Id').value('.', 'int')

for xml path('Test'), root('Tests'), type

)

select@result

What permissions do you have on the SQL Server instance?

Evil has no boundaries.

Yes, you can use variables with sqlcmd, see Books Online (http://msdn.microsoft.com/en-us/library/ms188714.aspx) for more details.

E.g.:

In your script change the definition to:

:r $(scriptfile)

Assign the variable at execution:

sqlcmd.exe -v scriptfile="\\user\c$\folder\xyz.sql"

Weird. What has also worked for me in the past, even though I have no clue as to how or why, was as follows:

1) create a copy of the config...

This sounds like a case for the Service Broker. I suggest you start by looking it up in Books Online (plenty of examples there), then perhaps come back here with...

Answered in "the other" thread.

Consider using SSIS for this. With the Foreach Loop Container you can process all files (specified) in a source folder, extract data from them, and then move them to an...

Have you verified which configuration file is being used at execution?

Have you verified that the file actually is use has the value set correctly?

SSIS config files can really be a...

What data type are you using and why?

Consider switching to varbinary - either max if you'r images can be larger that 8000 bytes, or a more appropriate length.

You can output the values into a table variable. What exactly are you trying to achieve?

On SQL Server 2005 (and later) you can use the OUTPUT clause of the INSERT statement to retrieve the identity values.

Books Online article:

http://msdn.microsoft.com/en-us/library/ms174335(SQL.90).aspx

Look at example K.

On SQL 2000...