Tag Archives: T-SQL

An Update to Skipping the Leading Digit in T-SQL–#SQLNewBlogger

Posted on October 17, 2022 by way0utwest

There was an interesting question in a forum, which I wrote about before. How do you skip the leading digit in a numeric value. I had looked at a UNION, but someone had a better suggestion, so I’m adding to … Continue reading →

Posted in Blog | Tagged , , | 4 Comments

T-SQL Tuesday #155–Using Dynamic SQL for SQLCMD

Posted on October 11, 2022 by way0utwest

It’s that time of month, and I’m the host this month. I wrote the invitation last week and now its’ time to answer. I’m actually using an example from the past that I was reminded of. That was the basis … Continue reading →

Posted in Blog | Tagged , , | 1 Comment

Replacing NULLs in a Left Join–#SQLNewBlogger

Posted on September 7, 2022 by way0utwest

I saw someone ask a question on how to replace NULL in a left join and decided to write a post. I realized this is one of those simple things that people new to SQL might not get. Another post … Continue reading →

Posted in Blog | Tagged , | Comments Off on Replacing NULLs in a Left Join–#SQLNewBlogger

New in SQL Server 2022 – Generate_Series

Posted on June 20, 2022 by way0utwest

One of the new language features added in SQL Server 2022 is the GENERATE_SERIES function. This allows you to generate a SELECT * FROM GENERATE_SERIES(start=1, stop=7) This gives me a simple sequence of numbers in a result set, with the … Continue reading →

Posted in Blog | Tagged , , | Comments Off on New in SQL Server 2022 – Generate_Series