DECLARE @XML XML = '<MESSAGE>

<HEADER>

<Source_System>ACF</Source_System>

<Target_System>CRIMS</Target_System>

<System_Date>2011/01/14</System_Date>

<Generation_Date>2011/09/05</Generation_Date>

<Generation_Time>11:25:28</Generation_Time>

</HEADER>

<DETAIL>

<Account_CD>VPBN</Account_CD>

<Source_Security_ID>131924</Source_Security_ID>

<Long_Short_Code>L</Long_Short_Code>

<Valuation_Date>2011/01/14</Valuation_Date>

<Qty>N</Qty>

<Tax_lot_ID>N</Tax_lot_ID>

<Position_Or_TaxLot>P</Position_Or_TaxLot>

<Desc>última flor do Lácio</Desc>

<Source>ACF</Source>

</DETAIL>

<TRAILER>

<Number_of_Records>N</Number_of_Records>

</TRAILER>

</MESSAGE>';

SELECT @XML.value('(/MESSAGE/DETAIL/Account_CD/text())[1]','varchar(100)') AS Account_CD;

Just add the rest of the columns you need by following that pattern.

GilaMonster (9/15/2011)

GSquared (9/15/2011)

What if you happen to know that 40% of the cars in there are white? That'll help you plan how long this project will take, and what...

jcrawf02 (9/15/2011)

GSquared (9/15/2011)

Ninja's_RGR'us (9/15/2011)

Much better than what I could have done without someone proof...

I don't think SQL 2008 licenses will cover SQL 2005, but I wouldn't swear to that. Ask on Microsoft's support site. You'll get a more authoritative answer there.

Okay, I have to ask, how will that delete any data?

Perhaps a problem with the path to the executable? Do you fully qualify that in the call, or just call "winrar.exe"?

SELECT 'delete from ' + name + ';'

FROM sys.tables

WHERE type = 'U'

Copy-and-paste the results into a connection window and run them.

Or use that for a cursor and execute the commands...

Ninja's_RGR'us (9/15/2011)

Much better than what I could have done without someone proof reading. ...

"Aligned" in this case essentially means "same columns and function and file(s)". It just makes the query engine do less work when it does partition switching. It doesn't...

I put what I could.

This is simply the name for how SQL Server guesses when it doesn't know. The name probably comes from the programming concept of "magic numbers", which are...

Edit: Deleted the rest of my post because this debate is just looney at this point. Shouldn't have brought it back up.

I found another interesting...

I doubt anyone is still interested, but yesterday, the data about poverty in the US was updated. The stats are bad (thank you incompetent/malignant federal government and Federal Reserve...

Ditto! (In the manner of Taggart in Blazing Saddles.)

Very well done!

Is MARS enabled on the server? Won't matter if it's a single resultset, it will still fail the insert, as per Insert Exec in BOL/MSDN.

A proc that returns multiple...