Viewing 15 posts - 31 through 45 (of 185 total)
I couldn't disagree more with the thought that consistency creates quality. In fact, I suspect quality creates consistency, because when most people find something that both works well and...
May 16, 2008 at 7:44 am
Dave,
All of this has been very helpful. I rearranged your explanation, and added some pseudocode, and it makes perfect sense.
--Number of days since 1 Jan 1900
Select DATEDIFF(dd,0, GetDate())
--Midnight...
May 16, 2008 at 6:42 am
Dave,
The logic you provided was actually more elaborate than I needed, but it made me look more closely at my comparisons to get it to work. I ended up...
May 15, 2008 at 11:47 am
Dave,
It can't hurt to try. Thanks for putting this together, and I'll let you know how it works. I'm working on the table scan issue right now, and...
May 14, 2008 at 10:38 am
Jeremy,
Thanks so much for responding; my apologies for taking so long to get back to this. (Long response time: there's a trend developing here:))
I'm going to take a...
May 14, 2008 at 9:52 am
Dennis,
Thank you so much for the explanation. As Professor Higgins said about Lize Doolittle, 'by george, I think she's got it'.
Mattie.
May 12, 2008 at 6:41 am
Steve,
Thanks for responding, I probably should have opened a new topic. I'm not arguing about the need for a primary key, and I realize that it has to be...
May 9, 2008 at 9:20 am
Andy,
I know you wrote this article light years ago, and my question is a little off your topic, but I'd like to ask anyway. I understand the concept of...
May 9, 2008 at 6:30 am
I recently had this question, and because I'm using SS2K, couldn't use CTEs. Thanks to this terrific forum, I was provided with a very nice solution that doesn't rely...
March 13, 2008 at 2:13 pm
Heh... ok... let me turn that around on you... isn't a column that serves two purposes like wearing two watches? 😉
Jeff,
I don't think so, but since I didn't think that...
March 7, 2008 at 9:31 am
Thanks Lynn and pmohan for the code you posted. I took it pretty much as is, and have been able to create a view that makes it look for...
March 7, 2008 at 7:27 am
Thanks Lynn and Jeff for responding.
Jeff, correct me if I've screwed up my terminology, but isn't the normalized design the one without a StopWeightEffectiveDate column, but a trigger would be...
February 29, 2008 at 8:08 am
Thanks so much to both of you. I don't recall looking at ProgramName when I ran sp_who2, but I don't think it would have been too helpful, because there...
February 6, 2008 at 10:06 am
True enough, and the more tables you have, the more you have to look at the order you do things in. You may have to disable RI, or let...
November 16, 2007 at 8:01 am
Viewing 15 posts - 31 through 45 (of 185 total)