Lynn,

I seriously doubt you would find a trustworthy source that specifically states that you need to allow an extra 2GB for PAE.

From what I understand, the amount of memory required...

Another thing that will do it is the undo buffer, particularly if they are using formatting tools on very large scripts, but aside from regularly closing and restarting, there is...

You know there is always the Tally table is you want to get an ordering identifier out of the XML in the first instance...

declare @Products xml = N'<BS>

<B Id="5" />

<B...

Because you have not specified an ORDER in your SELECT.

Without an ORDER BY clause, you are NEVER guaranteed any specific ordering.

You are very welcome and thanks for the kind feedback.

If you can provide a sample dataset, it would help...

However, it looks like you are after this:

SELECT top 1

(select 1 AS [@number] for xml path('revision'),type),

[highlight="#ffff11"](select [/highlight]

(select

...

It looks like valid xml, so you could try this, but it's not really simple

declare @sample table(id int identity(1,1) not null primary key,Results varchar(max));

insert @sample(Results)

values('

<set type="TomAgingAlertProperties">

<TomAgingAlertProperties>

<properties>

...

Is the data valid XML in reality (the sample isn't very clear)?

You need to include the headings/subheadings in the data and group the report by them.

your sample output doesn't match the previous examples, so I can't give an exact query, but this is the general idea...

(select 'I' as [@type],'1000000002' as [data()] for xml path('uniquereference'),type)

I forgot to mention that you cannot have an xml version declaration in an XML datatype in SQL Server, so once you have the xml how you want it, you...

use subselects and the "type" option to add levels...

SELECT TOP 1

(select 1 as [@number] for xml path('revision'),type)

, (select

[UNIQUE_IDENTIFIER] AS uniqueidentifier

...

Try copying the first data row down so all the rows have exactly the same data - does it fail then also?

My findings differ, in that the "bit trick" makes no significant difference in Jeff's test harness.

I am not saying it doesn't work for some, but not for me on 2014...

SELECT CustNO,count(DISTINCT ChkNo) AS ChkCount

FROM CUST_PAY

GROUP BY CustNO