if you look at the top center of the Forum window, about half an inch below the RedGate ad, is a link called "My Posts". If you click that...

Jacob Pressures (9/4/2008)

---

Here is the error i get.

Error: #1

Date: 9/4/2008 10:24:59 AM

ADO Error: #-2147467259

Description:...

This can actually be viewed as two different issues: 1) how to get the data you want and 2) how to get that data into the format that you want.

This...

I am pretty sure that I know how to do it too. I just need the OP to answer my question first:

rbarryyoung (9/4/2008)

---

How many different locales and how many...

This is seriously cool, Jack. ...

Make sure that Hyperthreading is off and MAXDOP is set to 1.

How many different locales and how many different RowKeys are there?

Glad we could help. FYI, for CLR you will probably need the EXTERNAL_ACCESS permission and SAFE is not enough for writing to files.

Hmmm, sounds like a performance problem. 😛

Matt Miller (9/3/2008)

---

That's why you keep seeing the old "the order of processing is not guaranteed" disclaimers on MSDN as to these kinds of things....

Well, thanks for the feedback! 🙂 Some of the credit goes to Michael Coles SQL XML book, which I have been reading this week. It too is...

Here is the script that I used to test it:

Set Nocount ON

create table cit(cno int, descr varchar(16))

create table nit(cno int, descr varchar(16))

go

Insert into cit select 100, ''

Insert into nit select...

Because I put it in.

sturner (9/3/2008)

---

actually, that join would set descr = to the "2nd"...

Christian Buettner (9/3/2008)

---

But here is something similar that might work out:

sqlcmd -S TheServerNameHere -o C:\Results.txt -Q "SET NOCOUNT ON;SET ROWCOUNT 200;DECLARE @A nvarchar(max);SELECT @A = ISNULL(@A,'') + ISNULL(OBJECT_DEFINITION(id), object_name(id) +...