Free download at the US Census Bureau web site

http://www.census.gov/tiger/tms/gazetteer/places2k.txt

The default recursion limit is 100.

You need to add Option (MaxRecursion 32000) to the Query

You can choose a number lower than 32000, but must be at least equal to the...

Jeff

Thanks for the response and the time measurements. Unfortunately, the MaxRecursion Option cannot be applied inside the function, it has to be applied in the Select statement using the function....

Below is a function based on recursion for parsing a string with a specfied delimiter

Go

If Object_id('GmtGetTokens') is not null drop Function GmtGetTokens

GO

Create Function dbo.GmtGetTokens(

@AllElse Varchar(8000),

...

Noel

Perhaps I mis-stated the problem. I am looking for separate contiguous intervals with the same value, not the start and end for any value [as your code provides].

In any...

I have a somewhat different business application summarized below.

A table with columns Interval and Value. These represent an activity that occurs at each minute of a 24 hour day.

The...

The Visitor

The Edge of Heaven

The Diving Bell and the Butterfly

The Other Side

Transamerica

Gran Torino

Slumdog Millionaire

Create function CalculateVerhoeffDigit(@p_input varchar(Max))

returns smallint

As

Begin

Declare @PV_D varchar(100),@PV_P varchar(80),@PV_INV varchar(10)

Declare @lv_c Int, @lv_m Int,@lv_n varchar(255), @lv_i Int,@lv_len Int

Set @PV_D= '0123456789123406789523401789563401289567401239567859876043216598710432765982104387659321049876543210'

Set @PV_P= '01234567891576283094580379614289160435279453126870428657390127938064157046913258'

Set @PV_INV= '0432156789'

Set @lv_c= 0

Set @lv_i= 0

Set @lv_len= Len(@p_input)

Set...