T-SQL's CHARINDEX() function is a useful for parsing out characters within a string. However, it only returns the first occurrence of a character. Oftentimes one needs to locate the Nth instance of a character or a space, which can be a complicated task in standard T-SQL. This function I wrote, imaginatively named CHARINDEX2(), allows one to do this. It receives, as arguments, the target string or character, the string to be searched, and the occurrence of the target string/character.
A short but interesting article, the author has figured out a way to create a PDF from a stored procedure without using a third party library.