katesl (7/15/2010)

---

>>

So it's OK to depend on a job that runs infrequently, but it's not OK to depend on a table that has to be maintained infrequently? Where's your...

ziangij (7/15/2010)

---

i have populated data till year 2050 as a contigency measure 😀

Tom Williams-175034 (7/15/2010)

---

Here we've always been of the belief that you shouldn't have tables with date ranges, because...

Here we've always been of the belief that you shouldn't have tables with date ranges, because tables get created and populated, the query in question works, and the table gets...

Or to take Kenneth's use of char(39), how about:

SELECT Bob FROM Dog WHERE Bob LIKE '%' + CHAR(39) + '%'

Pretty much the same thing really - useful when...