Tag Archives: T-SQL

T-SQL Tuesday #156–Ready for Production

It’s a busy time for me, but it’s also T-SQL Tuesday blog party day. I’m rushing a bit as I forgot about this (thanks for the reminder, Deb) and had to help on the ranch this morning. In any case, … Continue reading

Posted in Blog | Tagged , , | 1 Comment

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

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

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

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