Need to filter by date range...

• toddasd

  SSCertifiable

  Points: 6298

  More actions

  June 13, 2011 at 4:29 pm

  #1338095

  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: 1004356

  More actions

  June 15, 2011 at 7:52 pm

  #1339415

  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)