Viewing 15 posts - 901 through 915 (of 4,087 total)
I think the following is going to be faster and simpler. It only reads the table once each loop instead of once to insert into the temp table and once...
September 17, 2018 at 2:20 pm
September 17, 2018 at 12:01 pm
I mean that it will usually be impossible to tell whether Table C is...
September 17, 2018 at 11:50 am
September 17, 2018 at 10:12 am
You've been around long enough to know that you should provide sample data and expected results.
Drew
September 17, 2018 at 9:52 am
I have this View:
Create View xyz As
Select Value,
MAX(Case When Other = 'Color' Then Description...
September 17, 2018 at 9:39 am
I don't consider this a CROSS JOIN. It's an INNER JOIN on GPID and Name. A CROSS JOIN would produce 36 rows, whereas this only has 18.
Drew
September 17, 2018 at 8:49 am
alexander.lummer - Friday, September 14, 2018 1:52 PMHow would you prefer I provide you with a sample data?
Please see my very first...
September 14, 2018 at 3:14 pm
alexander.lummer - Friday, September 14, 2018 12:11 PMCan i attach an excel file? will make it easier
Yes, you can attach an Excel...
September 14, 2018 at 1:36 pm
That's not true at all. Here is an easy demonstration of that fact.
You...
September 14, 2018 at 1:05 pm
September 14, 2018 at 12:51 pm
Table C is joining to Table A's initial state. But the final result will be affected...
September 14, 2018 at 12:40 pm
It's complicated by the fact that there are actually two different (but related) behaviors: logical and physical processing. Think of it as the logical is how humans think about it...
September 14, 2018 at 12:22 pm
September 14, 2018 at 10:03 am
Viewing 15 posts - 901 through 915 (of 4,087 total)