What's the problem with using UNION?

If all three procs and each section output the same fields then why not just order them the same? It's not good...

This is where you're going to have to give us more information about what you actually want. Cadavre's solution produces one row for each distinct value of length...

The best way to get the contents of an element (especially if the content may change from document to document) is to use the child axis

SELECT @XML.query('//Author/child::*') ;

Me too and the link to the Finding Fragmentation article results in a FeedBurner 404 Error.

One possible modification that you might want to make is to change this:

d2.Color AS [text()]

to this:

d2.Color AS [data()]

That way your items would have a space between them instead of being...

No, not a dashboard. I want to develop reports and give end users and nice interface with which they can modify filter criteria, sorting setting and output format for...

Just wanted to add a little clarification on the filtering and sorting. I'm not referring to passing parameters statically to the web service in order to do filtering and...

I don't know why but I always think that OPENXML is the slow so I don't try it. Thanks for reminding me, it was about 10 times faster than looping...

Already used cross apply and it's VERY slow as well.

Mark-101232 (5/8/2012)

---

This should be quicker

select b.value('@UNIT_ID', 'nvarchar(100)'),

r.value('@DT', 'DATETIME'),

...

The problem is that the DB server may be in one location while the clients could be spread throughout multiple time zones. So, I store the datetime data in...

My script s designed to update an existing database so I need to check for existence first. It's an indexed view so I don't really want to drop and...

I think the derived table would create an even more complicated query since the query in the derived table would require and additional join to create a key field in...

I posted a message about this too. I am now 1-2 in installs. A 64-bit Vista system couldn't install, A 32-bit Vista system installed fine and a 32-bit...

It's not the mouse. Curious if if anyone else can startup the installer and V64 and see if it is normal for all the setup apps to run twice.

Oh, it launches by itself or I can run the setup.exe myself but the result is always the same.