My last gig was a couple hundred GB across 50 or so databases but very very busy... like 3500-4500 batch requests a second busy on the most active DB.

My current...

Agreed. Architecting, that would be fun. Day to day support? That's another story.

Here is some more recent info from the SQLCAT team... among some other petabyte monsters and companies they profile the databases running XBOX live which adds 12 TB monthly as...

I realize this is a long time after the original question was asked but for future visitors... I believe this is what you were looking for.

http://msdn.microsoft.com/en-us/magazine/cc135978.aspx

In the...

Though the technical trickery of the XML path is cool, I am really disappointed in myself for not coming up with the simplicity of the "select =" statement. Thanks...

I thought the link I provided took you to a larger version. Apparantly not, sorry. I've attached the image here:

I'm using Crystal 2008, SQL Server 2008 and Visual Studio 2008.

Here is the exact error message I get when I run the crystal report while debugging within VS. This...

The interesting thing is that with it 'ON' or 'OFF' SQL behaves the same. It returns a null if no child records are found.

Crystal however was only happy...

I'll add one more comment to this post for future forum users. I discovered that I had to have the database option "arithabort" set to 'ON' when using this...

Thanks again guys, the combination of responses gave me exactly what I needed. That stuff post that accounts for '&' and '' characters is pretty trick. I can...

Thanks I'll look into the xml path. The reason this isn't being handled at the application level is because they want this for a Crystal Report that can be...