TSQL function to detect SQL Agent job state

This article has a T-SQL function to detect the SQL Agent job state.

Aggregate Function Product()

The TSQL aggregate function SUM() gives a number based on the addition of the values of multiple rows to each other. Do the same thing but with multiplication instead of addition.

INSERT OUTPUT

Twist in ISNULL function

Be careful while using the ISNULL function

Strings and Defaults

Hashing

How to get monthly YTD data

This article presents an easy method to get YTD data grouped by months in T-SQL.

Multiple Inserts

Time Zone

T-SQL Development, or: How I Learned to Stop Worrying and Love Word

Microsoft Office Word is useful. There, I have confessed it, it's useful to me while I am working with TSQL. It's possibly only the search and replace function that I like but it's wrapped in Word so I have to take it like that. I use it a lot to help me capture the results of a stored procedure.