Robert Cary

  • Interests: Sleight of hand magic, cycling, bowling, poker

Technical Article

Find Nth Occurrence of Character Function (Set Based)

This function was originally contributed by other visitors. Below is an example of a set based approach to the problem. This script requires a numbers table (see SqlServerCentral article http://www.sqlservercentral.com/columnists/mcoles/2547.asp for more details)Please note that this code is uses SQL2005 featuresEnjoy!Robert Caryhttp://tsqlland.blogspot.com

5 (1)

2006-10-20 (first published: )

540 reads

Blogs

Alert Filtering in SQL Monitor

By

SQL Monitor has improved a lot over the last couple of years. We have...

SharePoint List only returns 100 items in Azure Logic App

By

I was reading a SharePoint List using the “Get Items” activity in an Azure...

Daily Coping 27 Jun 2022

By

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

Read the latest Blogs

Forums

transaction log backup for log shipping vs manual backup

By sqlfriend

If I setup log shipping for a database, and I want to do a...

Veritas Net Backup

By ramana3327

Hi, We are using SQL 2014 version. The scheduled backup job is failing with...

Database backup and restore

By DBA

Hello, I've a user database which I want to migrate to new server, so...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers