If I understand the problem correctly, what about:

CREATE PROCEDURE x

(@ParamList XML)

AS

DECLARE @iDoc int

EXEC dbo.sp_xml_preparedocument @iDoc OUTPUT, @ParmList

INSERT INTO dbo.MyTable

(Id, Value)

SELECT

(Id, Value)

FROM OPENXML(@iDoc, '/MyParameterList',1)

WITH(Id int '@Id',

Value varchar(50) '@Value')

EXEC dbo.sp_xml_removedocument @iDoc

GO

That will...

Please don't cross-post the same question.

http://www.sqlservercentral.com/Forums/Topic408403-338-1.aspx

And I agree with the initial response.

Maybe I'm confused by the question, but are you looking for a SELECT statement? Something like:

SELECT o.OrderId

,o.Custermer

,d.ProductId

...

Most systems do some form of option #2. The main reason being, reporting. Your basic report engine just isn't going to be able to figure out the bit mask the...

You should look at the number of scans and reads each one is doing. Time is nice & all, but for most queries, reducing scans or reads leads to reductions...

It is possible, but as Colin has noted, it's definitely not the right approach. If you were to try it, the trick would be to only use a single parameter,...

What data type is the BadPasswordTime inside the database?

What about using sqlcmd to control the execution & output of the script?

There are not TSQL commands that take control of Management Studio and its behavior.

Please repost over in the 2000 forum to get 2000 specific help.

Everyone's favorite answer: it depends. If you have an inline function that is returing a table value, it effectively works like a view and the query processor blows out the...

I'm not sure it's a secret, but I can click on the Object Explorer window, say on the "Tables" folder within a database and there it is.

You got it? Cool. It's a neat little trick that I learned from a Microsoft Consultant. It's good to see other people find it useful too.

Yeah. I put it that way in case, like us, you have a compound PK.

I'd stay away from table valued functions unless performance is completely not a concern.

The cross apply should only return a single value such that you'd get more than one row,...

Hmmm. Not an easy one. I looked through the code, I generated the query. Everything looks ok, assuming the data types in the tables are as presented, with one possible...