Viewing 15 posts - 1,366 through 1,380 (of 1,419 total)
What have you tried? As I recall SSMS export will not properly escape the text. I'm pretty sure tho SSIS csv export does.
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 21, 2019 at 3:07 pm
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...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 21, 2019 at 1:48 pm
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...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 20, 2019 at 11:30 pm
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")
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 20, 2019 at 6:51 pm
Just to be clear there are 3 possible patterns?
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 20, 2019 at 3:01 pm
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...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 20, 2019 at 2:02 pm
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...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 20, 2019 at 12:03 pm
Why not just look for the dash, "-"?
IIF(InStr(Fields!my.Value,"-")=36, "Paris", "London")
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 20, 2019 at 11:48 am
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...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 19, 2019 at 9:03 pm
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...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 19, 2019 at 8:37 pm
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,...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 19, 2019 at 8:05 pm
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...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 19, 2019 at 7:51 pm
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...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 19, 2019 at 6:59 pm
Aha, gotcha. I see what you mean about sometimes also. Sometimes it matters even tho they're distinct. Thank you.
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 19, 2019 at 6:43 pm
You may...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 19, 2019 at 6:25 pm
Viewing 15 posts - 1,366 through 1,380 (of 1,419 total)