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)

You rated this post out of 5. Change rating

2006-10-20 (first published: )

541 reads

Blogs

Creating an Empty Repo in GitHub–#SQLNewBlogger

By

I saw someone struggling with getting started with a Visual Studio project and Azure...

Product Review: DataVeil

By

If you’re looking at data masking tools, I recently was able to review the...

The Last Price Bump for the Data Community Summit

By

This week the cost of the PASS Data Community Summit jumps up to full...

Read the latest Blogs

Forums

Partition Large Tables needed

By sqlguy80

Hello Gurus, I have  a requirement and need to implement the solution quickly. SQL...

Deleting the Standby file

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Deleting the Standby file

If You Build It, Will They Use Linux?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item If You Build It, Will...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers