Viewing 15 posts - 1,351 through 1,365 (of 1,398 total)
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...
August 20, 2019 at 12:03 pm
Why not just look for the dash, "-"?
IIF(InStr(Fields!my.Value,"-")=36, "Paris", "London")
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...
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...
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,...
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...
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...
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.
August 19, 2019 at 6:43 pm
You may...
August 19, 2019 at 6:25 pm
[
The same reason you unit test anything? It's either the new development or it's something you're modifying.
New development and modifications should be tested over and over until they work as...
August 19, 2019 at 6:07 pm
Yes I would 100% disagree with that, every object in the database does not interact with every other object in the DB in some exponentially spirally level of complexity. ...
August 19, 2019 at 5:44 pm
Sometimes
They're distinct. Is because performance?
August 19, 2019 at 5:37 pm
Ah, ok. So the reason you may want to keep unit tests is if anything needs to change with your data model, you've already documented how things should work and...
August 19, 2019 at 5:24 pm
In my opinion unit testing in a relational database is basically fruitless. The whole idea is the data model is schema bound. So what are you testing but only...
August 19, 2019 at 4:49 pm
David
the non-SQL parts of our C# app are tested with a few unit tests and a lot of manual tests.
We plan to reverse the quantity (unit testing first and...
August 19, 2019 at 4:43 pm
Viewing 15 posts - 1,351 through 1,365 (of 1,398 total)