The WHILE loop executes a block of code repeatedly as long as a specified condition is true. While your example is a good introduction, the primary lesson for advanced T-SQL training is that you ...

Scenario The DA team leader has requested a TABLE function to be created Requirements for the Table function... 1: A single date input param for MonthEnd e.g. 2016-1-31 Parameter name suggested e.g.

While there are a great many books, blogs, and articles out there on T-SQL, there are always a few little "tricks" that many people overlook, or that many authors assume readers know. So this week, ...