Viewing 15 posts - 136 through 150 (of 557 total)
August 16, 2018 at 3:08 pm
Hello Paul,
Whenever COUNT(*) is used in the SELECT clause of a statement, it has the 'same value' if it is repeated. It is the count of number of...
August 14, 2018 at 11:08 am
Something around these lines, especially the second solution might help you on.
The second query is equivalent to the first query, but might help in 'chopping' up the query.
August 14, 2018 at 7:55 am
Sorry for Butting In, this is not my expertise and I do not have a solutions. My apologies for that.
What often happens is that huge amounts of data...
August 9, 2018 at 7:30 am
July 19, 2018 at 6:51 am
xsevensinzx - Wednesday, July 18, 2018 5:47 PMIn terms of chunking, there are plenty of options out there.
Could you point out...
July 19, 2018 at 3:36 am
July 19, 2018 at 2:08 am
Thanks, Ben, but I have to ask again.... why would anyone need to...
July 17, 2018 at 6:43 am
Hello TIA,
What I use is a stored proc which can do a number of different searches, but it is a rather large routine because of the number of...
July 17, 2018 at 6:09 am
Maybe this does help :
Two rows A and B overlap when :
(A.stop > B.start AND B.stop > A.start)
But there is plenty of situations which maybe...
July 6, 2018 at 8:14 am
But the error which can put you in jail is using floating-point for...
July 6, 2018 at 7:48 am
Hallo All,
Some years ago I wrote a 'replace2' function which can do multiple replaces in one go.
It does the same job as a multiple nested replace, but...
June 7, 2018 at 6:39 am
Using fractions like 1/3 or even 1/10 is always risky when using float calculations. Both 1/3 and 1/10 are not exactly presented in most binairy systems.
A1, A2, B1,...
March 19, 2018 at 8:29 am
Viewing 15 posts - 136 through 150 (of 557 total)