Find Nth Occurrence of Character Function V3

In the tradition of best practice & code improvement, a third iteration of a script that finds the Nth occurrence of a Target string within another string (Original author unknown, V2 author vextant).This version returns zero if an Nth occurrence is not found (similar to V1), but also provides the ability to search the string […]

2007-06-29 (first published: )

406 reads

Blogs

How to put a SQL Server Database into Recovery Pending

By

You might be asking why on earth would you want to get a database...

SQL Server on Linux Storage Secrets on Microsoft Channel 9

By

I’m thrilled to have recently released a video with Microsoft’s Data Exposed on Channel...

Daily Coping 29 Jul 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Having sum(amount) = 0 returns negatives as well.

By C-M-A

Hello all, I'm trying to get a list of ID's that have a total...

How to limit SQL Job Success events

By Graham Van der vaart

Hi, We have a monitoring tool that reads Windows Event Log entries for Failure...

SQL Server Agent producing unreproducible error

By Thom A

I've built a Powershell script, which I want to run through SQL Server Agent....

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers