"WHERE crc.[value] < parms.end_dt" was not necessary at all so I deleted it.  Your function obviated that necessity.  I wrote that but then I pasted it in with...

• This reply was modified 5 years, 6 months ago by  Steve Collins.

What have you tried?  As I recall SSMS export will not properly escape the text.  I'm pretty sure tho SSIS csv export does.

Your proc produced the correct output.  I'm still trying to get my head around cross apply.  It's kind of magical.  The last part, where not exists, I was really sure...

Danke schön!  Nicely done -- it's in my toolbox now.

We have a project coming up where I'll have the chance to alter or replace the following proc (which runs in...

IIF(Mid(Fields!my.Value, 30, 1)="(","London", "Paris")

or (because the position counts counted the brackets):

IIF(Mid(Fields!my.Value, 28, 1)="(","London", "Paris")

Just to be clear there are 3 possible patterns?

1. Working Reference : [123456] (text in brackets) -  loads more text
2. Working Reference : [123456789] (text in brackets) -  loads more text
3. Working...

If this can't be done by absolute offset then that raises a bunch of issues.  What can you say about the characters that appear in the 'xxxxxxx xxxxxxx' segments?  Can...

In this string the dash appears in the 33rd (or 32 starting from 0) position:

xxxxxxx xxxxxxxxx : 123456 (xx) - xxxxxxx...

In this string the dash appears in the 36th position:

xxxxxxx...

Why not just look for the dash, "-"?

IIF(InStr(Fields!my.Value,"-")=36, "Paris", "London")

Why pick the first thing he said?  I chose the last thing!  He had pretty much the same conversation we're having and already made the distinction between testing to...

The code you posted has two lines that say: "fetch next from dbcursor into @zipname,@imageid" within the cursor loop.  Please try with only one fetch (at the end of the...

Hmm... Here's a segment of the code we're running in production:

select @sql=
'with history_cte as ( ' +
'select ' +
   cast(@test_id as varchar(12)) + ' hf_id,...

Not really. Saying that I don't think you understand, is not an ad hominem attack. I also didn't mean it as an insult, just trying to figure...

Not really. Saying that I don't think you understand, is not an ad hominem attack. I also didn't mean it as an insult, just trying to figure out where...

Aha, gotcha.  I see what you mean about sometimes also.  Sometimes it matters even tho they're distinct.  Thank you.