Viewing 15 posts - 151 through 165 (of 1,415 total)
In your first post, I specifically remember seeing an "ra_number" column. I don't see it in your sample data however. I remember this because one of the steps I went...
November 13, 2019 at 9:57 pm
status" must appear in the GROUP BY clause or be used in an aggregate function
trying to get success and failed status count in same line instead getting 2 records...
November 11, 2019 at 9:47 pm
It always helps to include sample data so that people can work with your code and make changes to see what would work.
Anyways:
you are grouping by status, so that introduces...
November 11, 2019 at 9:20 pm
I wonder if you are asking for more work from folks than they usually do here.
HOWEVER it would help if you also reformatted your code for readability and included some...
November 11, 2019 at 8:39 pm
looks like you are looping through the temp table and calling a stored procedure for each row.
You could consider an index on the temp table on column "rownumber" because if...
November 7, 2019 at 10:12 pm
If you DO actually have 100's of servers you need to do this to, then you actually do need some help because if you do actually land or build a...
November 4, 2019 at 8:44 pm
disclaimer, I am not arguing.
_however_
You really can't blame the original developers, everybody always talks about how relational databases have no implicit order and its very understandable that, given this philosophy,...
November 1, 2019 at 7:47 pm
If I can ever get SSIS to work, I'm hoping to start using it, I used to love bcp, other forms of bulk loads etc, but our systems...
October 31, 2019 at 4:01 pm
If I can ever get SSIS to work, I'm hoping to start using it, I used to love bcp, other forms of bulk loads etc, but our systems got reorganized...
October 31, 2019 at 1:35 pm
regarding the SSDT mess, I had studio 15 installed so I could follow one of our developers efforts, but then I went and installed a local SQL 16 and plus...
October 30, 2019 at 9:33 pm
scdecade interesting stuff! If / when you get a public project going you should drop us a note!
October 30, 2019 at 9:28 pm
My point was that the inner catch did the eating if the error was in the inner try, not the outter, unless I'm not getting the same situation...
October 30, 2019 at 9:14 pm
I just tried something similar and it seems that the outer catch wouldn't catch anything that the inner catch eats. I could be wrong, I just couldn't duplicate...
October 30, 2019 at 8:36 pm
I haven't played with net core, do you have any info on the type conversion differences? I can't find anything, weak google fu I guess.
In C# since 5...
October 30, 2019 at 6:47 pm
Oh boy how I love vendor code. I am not exaggerating to say I just saw this.
try
{
OneLineOfCode;
try
{
AnotherLineOfCode;
try
{
ThirdLineOfCode;
}
catch(Exception ex) {}
}
catch(Exception ex) {}
}
catch(Exception ex) {}
It is bad enough...
October 30, 2019 at 6:24 pm
Viewing 15 posts - 151 through 165 (of 1,415 total)