176 reputation
18
bio website
location Sacramento, CA
age 37
visits member for 3 years, 2 months
seen Aug 1 at 18:17

Pre-graduate student, California State University at Sacramento.


May
14
awarded  Notable Question
Aug
9
accepted Displaying Parent Child Information, With Certain Parent Columns Only Shown Once
Aug
9
comment Totals Column - Blank if Zero or NULL
Also, too: Go Bruins! Sorry, as a fellow Bruins fan since the Cam Neely/Ray Bourque era, I couldn't help but see that in your profile, haha. ; o ) OK, I'm done.
Aug
9
comment Totals Column - Blank if Zero or NULL
Thank you, Aaron--in your replies I'm hearing defensiveness, irritation, anger--you name it--about this because you really want more respect for your limited time and attention...and maybe more appreciation and recognition for the amount of effort you put into answering questions...and it would really make your life a lot better if people took more care before responding, so it doesn't waste your time. That's what I'm hearing. I think we're getting pretty meta, so, if agreeable to you, let's go offline if you prefer discussing further--you can reach me at my username @ gmail . Thank you again.
Aug
8
accepted Totals Column - Blank if Zero or NULL
Aug
8
comment Totals Column - Blank if Zero or NULL
To follow-up: I'll remove the downvote--I do appreciate your help and clarification. When I saw the answer beginning with a discussion of table aliases (late last night), my eyes glazed over and I did not notice you had also supplied an actual answer to the question--I assumed the code only served as an example of your preferences on using table aliases. Looking at the edit history of the answer, I now see how you started with only the answer, then added the (helpful) notes above. Thank you again.
Aug
8
comment Totals Column - Blank if Zero or NULL
: o ) Thank you Aaron--to answer your questions: No; and no.
Aug
8
awarded  Critic
Aug
8
comment Totals Column - Blank if Zero or NULL
Thank you, Aaron; since this seems more like a comment than an answer, as time and motivation permits, would you please delete it and move it to a comment, above, or re-word as an answer? I appreciate the insights, but I'm struggling to see this as an answer to my question. Thank you.
Aug
8
comment Displaying Parent Child Information, With Certain Parent Columns Only Shown Once
Thanks Greenstone; this might represent an acceptable answer...I'll have to try it out.
Aug
8
comment Displaying Parent Child Information, With Certain Parent Columns Only Shown Once
Thanks RLF; option #1 seems like my current approach...with option #2, would it require running the subquery twice? Thanks again.
Aug
6
asked Totals Column - Blank if Zero or NULL
Aug
5
asked Displaying Parent Child Information, With Certain Parent Columns Only Shown Once
Jul
19
awarded  Popular Question
Mar
18
comment Stop SQL Server service(s) before defragmenting drive?
As a follow-up, after defragmenting the drive, performance has only marginally improved. Remus seems correct in his diagnosis of a RAM issue.
Mar
13
comment Stop SQL Server service(s) before defragmenting drive?
I'm marking this as the best current answer, since it seems "Yes" if we use the right tool. Thanks!
Mar
13
accepted Stop SQL Server service(s) before defragmenting drive?
Mar
12
comment Stop SQL Server service(s) before defragmenting drive?
Thanks Remus; if only I ruled the world.... We contract with a third-party vendor for the app, so not in our direct control, regrettably. I do appreciate your insight, thank you.
Mar
11
revised Stop SQL Server service(s) before defragmenting drive?
added 250 characters in body
Mar
11
revised Stop SQL Server service(s) before defragmenting drive?
added 1011 characters in body