The values in the ReportingGroup column in your sample data don't match up with those in the same column in your result set. Am I missing something, or have...

Right, I think I understand now. Please will you post some sample data (INSERT statements again) that will yield the results you're looking for.

Thanks

John

No, still not clear. You say you want to concatenate ReportingGroup, but your sample results only show one value per row in that column. And I'm afraid I...

Never mind performance - how are you going to display a minimum of 12,000 characters in your...

OK, so you want to concatenate all the preceding ReportingGroups into one column. I've got to ask - how many rows do you or will you have? If...

Yes, if you have multiple matches in the second table then you'll get one row for each in your result set. Now, what results are you expecting to see?

John

If there are only three columns, you might want to take a look at today's headline article[/url]. Of course, if this is something you're going to do regularly on...

Does Luis's solution get you anywhere close? If not, you might try including database name (or id) and date (with time portion, if any, stripped out) in your join...

So you have a table of DBCC check results and a table of backup results, and you want to join them? I'm not sure why you'd want to do...

Yes, and furthermore, a table variable only lives for the duration of the batch in which it is created, so you may find it difficult, if not impossible, to use...

Run that second subquery on its own, and you'll see it returns a different result for each of the two guises. That's why the whole thing returns a different...

Sounds like an extension of the UPDATE...FROM issue, where you can get unreported cardinality errors. If you update TableA based on a join to TableB, and there are multiple...

Is it the exact same message (unpersonalised) that you want to send to each recipient. You can send the same message to multiple recipients, so why not build the...

I've had this problem before. If I remember correctly, I solved it by creating stored procedures - one for each action (sp_start_job etc) and assigning the user permission to...

Ian

What happens if you CAST after doing the SUM?

John