Viewing 13 posts - 136 through 149 (of 149 total)
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
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
December 6, 2010 at 3:12 pm
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...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
November 24, 2010 at 3:41 am
@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.
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
November 18, 2010 at 2:01 am
@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? There's no...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
November 5, 2010 at 12:47 am
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.
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
November 4, 2010 at 3:51 am
Thanks for the tip Peter. I'll give it a shot and get back to you.
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
November 3, 2010 at 12:40 pm
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...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
November 1, 2010 at 3:25 am
spelling and gramer
😛
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
October 27, 2010 at 1:10 pm
is it better to be right or employed?
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...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
October 16, 2010 at 9:53 pm
IMO a points based system leads to worse answers as people chase the points posting the easy answer.
That's pretty much my argument! We seem to be in furious agreement. Ten...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
October 7, 2010 at 3:41 am
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...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
October 7, 2010 at 2:05 am
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...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
October 7, 2010 at 1:50 am
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...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
July 3, 2010 at 1:57 pm
Viewing 13 posts - 136 through 149 (of 149 total)