Viewing 11 posts - 1 through 11 (of 11 total)
As has been said, yours is a good and valuable newsletter but I completely 'get' the fatigue thing. Nobody needs that, so carry on. Three will be just fine. Thanks...
April 28, 2021 at 8:10 am
Actually, DATETIME is stored as two integers, the first being the number of...
January 16, 2019 at 7:05 am
Ask yourself:
How many times have I looked at dates on web pages and found myself looking for more examples to see whether the first bit or the middle bit...
January 16, 2019 at 6:24 am
January 16, 2019 at 6:17 am
January 16, 2019 at 4:54 am
I have long felt that the ambiguity between MMDDYYYY and DDMMYYYY, with or without separators, is intolerable and should have been terminated on Day 2 of SQL's arrival in the...
January 16, 2019 at 4:35 am
July 3, 2018 at 10:20 am
This has been a personal annoyance for years.
Surely, the import engine should properly respect the double quotes (or whatever specified character) as string delimiters, if so directed. We would...
July 3, 2018 at 2:43 am
I think it depends on the purpose of the request.
If my 'customer' wants a one-time answer to such a question, on less than a huge table, I think my solution...
January 30, 2014 at 9:04 am
Fair comment Jeff. Point taken.
Fortunately, I don't have huge data or paying customers, so on a horses-for-courses basis, the method suits me well enough.
Food for thought though, thanks.
Jerry
January 30, 2014 at 8:29 am
Nice article Jeff, a nice brain-teaser, thank you.
I got this far, via a rather round-about route...
select * from testtable
where datediff(month,startdate,'oct 2013') >= 0
and datediff(month,'oct 2013',enddate) >= 0
This deals...
January 30, 2014 at 7:45 am
Viewing 11 posts - 1 through 11 (of 11 total)