Tag Archives: T-SQL

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

Using a Regular Expression to Detect a Number–#SQLNewBlogger

Posted on June 15, 2022 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Here are some hints to get started. I had a customer recently that was looking to work with Data … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Using a Regular Expression to Detect a Number–#SQLNewBlogger