XSINIL is a good tip. It is an option if you switch your query from EXPLICIT to ELEMENTS.

What is your question?

I am not seeing a way to do it in one query...maybe someone else will chime in, but something along these lines may work for you:

USE AdventureWorks2008R2

GO

DECLARE @xml XML =...

If you go for the videos Gail posted all I can say is buckle in tight, I gave them a listen a while back (at her recommendation) when trying to...

Are you sure you bound the schema to the proc parameter...

When I save just the top portion of your script as a new PS script:

param(

[string]$itype=$(Throw "Parameter missing: -type FULL|DIFF|LOG"),

[string]$iSQLServerInstance=$(Throw "Parameter missing: -SQLServerInstance...

Bill Tidwell (6/3/2011)

---

opc.three

Help me out here. I have no DDL or DML. The sample data included in my post was captured from a raw-data/ ASCII file supplied by...

Excellent!

however for question 1 if the update statement takes more than a min to run, it does not log the...

I little over my head so thought I would bring it up here...neat post buried in SSIS forum:

http://www.sqlservercentral.com/Forums/Topic1119608-148-1.aspx

First thoughts: parameter sniffing or parallellism diffs in plans based on diff parameters....

Use the -e parameter of sqlcmd.

As an aside...why are you compelled to call sqlcmd from within a T-SQL process using xp_cmdshell? You generally better leaving the default of having xp_cmdshell...

Sounds like you're just starting out on the topic...Books Online is usually a good place to look to find a high-level overview as well as examples of the practical applications...

Here is the article I think Chris was alluding to:

http://www.sqlservercentral.com/articles/T-SQL/68467/%5B/url%5D

I second what Ron said. Help us by providing DDL to create test tables, DML to create test data and your expected results and we'll help you by providing tested...

PS I think it's odd that you can get away with this in SQL Server. I had a similar initial thought to what GSquared posted...a visceral "NO" to the premise...

That's the query structure I was thinking would work for you. You are using clock number, not name, which is a proper column to partition on...