I worked it out (and it's kinda obvious now that I look at it). The header for the child groups is actually a row in parent group. 😛

Cheers

GPO

You don't even need to use the word 'GO'. You can set the batch separator to be some string other than 'GO' in the SSMS options. Inveterate prankster and SQL...

@Iulian -207023: Yes totally agree about the GO and drops. Wasn't sure whether the missing GO was some trick part of the question. Very interesting quirk to be aware of.

@sql.monkey

I'm probably missing something here - wouldn't be the first time, but what do you do when your PK and your date column are in a different order?...

Well I'll be dog-tarned. It worked. Simple, yet obscure. That's why we love Reporting Services.

A thousand virtual thank-yous are on their way.

Thanks for the tip Peter. I'll give it a shot and get back to you.

As a slight aside, I have to do this sort of a lot at the moment, and it's common to have tables with start_date_time and end_date_time columns. You'll often want...

😛

For the small day to day irritations, maybe it's better to be employed. Maybe. For the big issues it's better to be right...

That's pretty much my argument! We seem to be in furious agreement. Ten...

There's no doubt this is a great resource, particularly for those of us fairly new to the caper, and I'm personally far richer for it. It would be good to...

Just one question. What's the significance of the (nolock) hint? Could you argue that none of the answers could be guaranteed in the event of a dirty read? Cheers and...

So (sorry for sounding dumb) how do you handle situations where the data has a significant level of sensitivity and you want the DBA to manage it, but not read...