Viewing 15 posts - 76 through 90 (of 154 total)
For this particular scenario the following would also work with no need for the Partition By clause. Why get fancy when simple will do?
CREATE TABLE #tbData
( ...
May 30, 2023 at 8:59 pm
Do those reasons have a unique character that separates them? Your original post doesn't show one but I had to ask.
Ghads Jeff I know this is a quality question...
May 30, 2023 at 8:34 pm
There is a shortage of COBOL developers around here. The salaries being paid for experienced COBOL developers are astronomical.
And this is part of what I am talking about as...
May 30, 2023 at 3:51 pm
Yes the solution covers the concatenated reasons -- so would you be able to create the staging tables and if yes then I can guide you through populating them so...
May 30, 2023 at 3:24 pm
First off string comparisons are never going to be highly efficient just by the nature of that beast which is why numerics are used most of the time. For instance,...
May 30, 2023 at 3:10 pm
So, how would you propose that most of the worlds largest financial institution's replace COBOL? Or, for the matter, many vary large companies?
Replace all the mainframes with servers? Move...
May 30, 2023 at 1:58 pm
And now you can even use .NET COBOL. Cobol isn't dead.
As I said it would not surprise me if they have continued to try and create a better dinosaur...
May 30, 2023 at 3:35 am
Please, don't malign COBOL. It is a good language and still in use.
Okay you and I will have to agree to disagree on this one. Not that it is...
May 27, 2023 at 5:41 pm
Okay while that is all nice to know it does not drill down to the issue that you have which will require you to examine the basic data and those...
May 26, 2023 at 2:06 am
If it was not obvious, what frederico_fons is saying is that you have a one-to-many relationship between your BBI$Barcodes table and your BBI$Item_Ledger_Entry table and you are seeking to make...
May 25, 2023 at 2:16 pm
Fair enough. be advised that it sounded like you were blasting SQL and be advised that it sounded like you were using your COBOL example to reinforce that.
Okay also...
May 21, 2023 at 11:39 pm
Okay fair enough and thanks Johnathan AC Roberts that explains dissecting the single word all by itself -- but then I did use a caveat it by saying "within context"....
May 21, 2023 at 10:59 pm
Okay if I understood your last post I will say -- (1) I do not make sarcastic comments without including an 😉 to let you know I am not being...
May 21, 2023 at 3:10 am
Well, Phil Parkin just because a word does not currently exist within any known dictionary does not mean it is not a viable word. In fact, Shakespeare is credited with...
May 20, 2023 at 3:31 pm
No Jeff Moden I did not state that SQL was a dinosaur at all, I think I basically referred to others doing so with dynotopic languages such as Cobol. I...
May 20, 2023 at 6:12 am
Viewing 15 posts - 76 through 90 (of 154 total)