Yes, the emails can be received every day of the week, including Saturdays and Sundays, but worked from Monday to Saturday. I never used a calendar table, maybe I can...

As usual on Christmas, I plan to do several things but then I end up completing 50% (if I'm lucky). Anyway, to-do list for this year:

- completing the website in...

Hi Brad,

thanks for this article, I was completely unaware of the issue. Just a question (that in my humble opinion has no answer): how could you prove that your code...

@adma3613 Another user has explained the reason why it's better to avoid this solution. I copy and paste his answer:

"these queries are non SARGable, which would result in an...

Hi Steve,

it seems to me that there are a couple of minor mistakes in the solution: "The only query that will return the two rows is the one that uses...

@celko As a newbie, I must admit that I was aware that if a number is divisible by 3 AND by 5, it means that it is divisible...

Just impressive, 453 ms for 1 million rows! I didn't expect it to be so fast.

As for the CASE, I was wondering whether it was better to use "5"...

Oh too good, let's say that your articles are really helpful: I've just applied what I've learned. By the way, I've compared your Tally function with the same function with...

@mister.magoo You will be happy to know that your solution is slightly faster than mine! Have a look at the times:

-- if the parameter is 1000: 76 ms (instead of...

@mister.magoo Hi, I used the row_number and a cross join after reading the Jeff's articles. You can see my solution somewhere in the page.

Could you tell me one thing? If...

Hi Jeff, first of all let me thank you for all the information provided. I spent one day in reading the articles, testing and re-testing. It was really worth. I...