It runs contrary to previous teachings, but - create correlated sub-queries to ensure what you're looking for.

This is a bit more wordy, but does allow for better control over the...

most of those are baked into how the FOR XML expects to to give it names. The easiest thing there is to just read through the FOR XML documentation...

You really don't want to be using EXPLICIT, it tends to be way to onerous.

Try this:

declare @fun table(id int identity(1,1), val2 int, val3 int, val4 int)

insert @fun

values (1,2,3),(5,6,7)

select 'Column1'...

it's not that hard to pretend you're coming from a specific address (called IP spoofing). It's a sad statement of affairs , but there's a fair amount of shareware...

The XML data type is capped at 2GB. Unfortunately that means you must be encountering some other error if it is truncating before that.

How are you going about checking...

Also - keep in mind with this kind of pattern, when you say "nothing dynamic", you need to be strong about that. As in - your message from the...

Another way to do it without EXPLICIT:

select t.root_element as '@value',

(select distinct elementA as 'elementA/@value'

from @tab tabinner1 where tabinner1.root_element=t.root_element

for XML path(''),TYPE),

(select distinct elementZ as 'elementZ/@value'

from @tab tabinner where tabinner.root_element=t.root_element

for XML path(''),TYPE)

from...

Well you certainly could do that. Altova puts out non-feature limited tools in their demo. 30 days was plenty to get us up and running.

Of course, you will need...

Look at the Altova...

Assuming you're running this against a SQL Server 2008 version, you can create functions and stored procedures using what is called SQLCLR. These are .NET assemblies built and compiled...

Why use the VBScript option? You're in 2008, leverage the full .NET version of Regex.

If you change the function into a stored proc you will have a lot more...

Craig Farrell (1/14/2011)

---

Random note:

Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was...

Never mind whether you like loops or not, this has crash and burn written all over...

Craig Farrell (12/30/2010)

---

I've dealt with...

LutzM (12/22/2010)

---

Gagne (12/22/2010)

---

...

Lutz, that sounds like you're saying that generally speaking, virtualizing a SQL Server will impact performance and that it's all a question of whether it will slow it...