Tag Archives: T-SQL

CHOOSE’ing a Beer: #SQLNewBlogger

Posted on March 26, 2025 by way0utwest

We recently published an article on CHOOSE at SQL Server Central. I thought it was a good intro, but as someone noted in the comments, how do you use CHOOSE? Do you have to hard code choices? This post shows … Continue reading →

Posted in Blog | Tagged , , | Comments Off on CHOOSE’ing a Beer: #SQLNewBlogger

DATEADD Truncates the Number Parameter: #SQLNewBlogger

Posted on March 19, 2025 by way0utwest

This was an interesting thing I saw in a Question of the Day submission. I hadn’t thought about the issue, but apparently DATEADD truncates values rather than rounding them. I’m not sure why that is the case, but it is. … Continue reading →

Posted in Blog | Tagged , , | 1 Comment

Tally Table Alternatives: #SQLNewBlogger

Posted on March 12, 2025 by way0utwest

We published an article recently at SQL Server Central on Tally Tables in Fabric from John Miner. In it he showed how this can be efficient. A day after he published it, he sent me an addendum to note that … Continue reading →

Posted in Blog | Tagged , | 1 Comment

A Couple Quick GENERATE_SERIES Tests

Posted on March 5, 2025 by way0utwest

I had someone reach out about generate_series() recently, saying they hadn’t realized this was a new feature in SQL Server 2022. They were wondering if it was better than using a tally table. I didn’t want to do an exhaustive … Continue reading →

Posted in Blog | Tagged , | 2 Comments