# Browse by Tags

Tagged Content List
• #### Blog Post: TSQL - Solve it YOUR Way - Finding a Person's Current Age Based on Birth Date

Introduction: As part of the blog series TSQL - Solve it YOUR Way , today's topic will cover a question asked recently in the T-SQL MSDN forums where the solution, at first, seems extremely obvious. However, as solutions were proposed and flaws were discovered with the proposals, the interesting nature...
• #### Blog Post: TSQL - Solve it YOUR Way - Parsing Tips and Tricks - Returning Digits after the Decimal Point

Introduction: As part of the blog series TSQL - Solve it YOUR Way , today we will tackle a numeric parsing question. While past topics include solutions that vary from 15-150 lines of TSQL code, all of today's solutions will be very short. A question was recently posted in the MSDN forums asking how...
• #### Blog Post: TSQL - Solve it YOUR Way - Finding the Longest Repeated Substring

Introduction: As part of the blog series TSQL - Solve it YOUR Way , today's topic will cover a common programming interview question where we are asked to find the longest repeated substring in a given string, followed by different solutions and explanations from three of the more helpful and creative...
• #### Blog Post: TSQL - Solve it YOUR Way - Finding the percentage of NULL values for each column in a table

Introduction: As part of the blog series TSQL - Solve it YOUR Way , today's topic will cover a question asked in the Transact-SQL MSDN Forums here , followed by three different solutions from three of the more helpful and creative contributors in the TSQL MSDN forums, Jens Suessmeyer, Naomi Nosonovsky...
• #### Blog Post: TSQL - Solve it YOUR Way - Finding the MAX Value from Multiple Columns

Introduction: As part of the blog series TSQL - Solve it YOUR Way , today's topic will cover a question recently asked in the Transact-SQL MSDN Forums here , followed by four different solutions from three of the more helpful and creative contributors in the TSQL MSDN forums, Jingyang Li, Steven Wang...
• #### Blog Post: TSQL - Solve it YOUR Way - Gaps and Islands... With a Twist!

Introduction: As part of the blog series TSQL - Solve it YOUR Way , today's topic is a variation of the popular T-SQL question titled "Gaps and Islands" followed by three different solutions presented by three of the more helpful and creative contributors in the TSQL MSDN forums, Steven Wang, Alejandro...
• #### Blog Post: TSQL - Solve it YOUR Way - Text to Speech

Introduction: As part of the blog series TSQL - Solve it YOUR Way , I will present a topic recently discussed in the Transact-SQL MSDN forum here , followed by three different solutions to this problem supplied by three of the most active and helpful contributors in the forums, Tom Cooper, Naomi Nosonovsky...