Viewing 15 posts - 31 through 45 (of 54 total)
Thanks, xsevensinzx, and others.
I think as my first step I...
August 31, 2018 at 8:21 am
August 29, 2018 at 9:48 am
August 28, 2018 at 1:18 pm
Drew,
I should have added that each source set of data has a different set of columns. They do not have any kind of primary key already.
August 28, 2018 at 10:48 am
INS4_LIMITED is the name he gave to the result set returned by the CTE...
July 24, 2018 at 9:19 am
Steve,
This may be a silly question, but what is the significance of '_LIMITED' that you appended to the original table name "INS4" so it was 'INS4_LIMITED' on the subquery...
July 24, 2018 at 7:31 am
Thanks, now I know what CTE stands for when I see it here. Also, CTE is apparently not covered in my beginners guide to SQL. I'm only 3/4 of the...
July 19, 2018 at 12:58 pm
sgmunson - Thank you, that did exactly what I was looking for. I would have never gotten that on my own. I am going to see if I can expand on...
July 19, 2018 at 12:01 pm
First off, the value of INS4.Modifier cannot be both 26 and NULL in...
July 19, 2018 at 5:35 am
July 18, 2018 at 1:25 pm
@Jackie Lowery - At this point, I don't know the OVER command, yet. My full query with the updated CASE statements is below.
@Drew Allen - Also I am not...
February 15, 2018 at 8:15 am
February 15, 2018 at 6:55 am
For example, COUNT(CASE WHEN...
February 14, 2018 at 11:55 am
February 7, 2018 at 7:16 am
February 6, 2018 at 1:11 pm
Viewing 15 posts - 31 through 45 (of 54 total)