Need to filter by date range...

Question

Need to filter by date range...

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply

toddasd SSCertifiable Points: 6298 More actions · Answer 1

Jeff Moden (6/13/2011)
sql_jr (6/13/2011)
Thank you, Jeff! I see quite a lot of activity around my post (which doesn't really have anything to do w/my original question 🙂 But, I am quite grateful for Jeff's expertise - even if he yelled at me 🙁
Heh... sorry. Didn't mean to make it look like I was yelling at you specifically. Using BETWEEN on dates has become a viral problem so I've become prone to making sure no one misses the suggestion to not use BETWEEN with dates.
I also apologize for the bit of a highjack of your thread. As a bit of a side bar (I don't know if it matters to you), but the problem you posted has inspired me to begin work on an article on the subject so I really appreciate your original post on the subject.

So when is a problem going to inspire you to write a book so we can all buy it from amazon? 🙂

______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.

Jeff Moden SSC Guru Points: 1004414 More actions · Answer 2

toddasd (6/13/2011)
Jeff Moden (6/13/2011)
sql_jr (6/13/2011)
Thank you, Jeff! I see quite a lot of activity around my post (which doesn't really have anything to do w/my original question 🙂 But, I am quite grateful for Jeff's expertise - even if he yelled at me 🙁
Heh... sorry. Didn't mean to make it look like I was yelling at you specifically. Using BETWEEN on dates has become a viral problem so I've become prone to making sure no one misses the suggestion to not use BETWEEN with dates.
I also apologize for the bit of a highjack of your thread. As a bit of a side bar (I don't know if it matters to you), but the problem you posted has inspired me to begin work on an article on the subject so I really appreciate your original post on the subject.
So when is a problem going to inspire you to write a book so we can all buy it from amazon? 🙂

Maybe sooner than I thought. I started a book last year... got in 3 chapters deep and (temporarily) put it aside to do PASS and a couple of other things. I didn't make the cut on PASS as a presenter this year so I might actually have some time soon.

And thank you for the very nice compliment. That absolutely made my day. 🙂

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)