Viewing 15 posts - 1 through 15 (of 143 total)
Actually the first set also gives duplicates (mode = 0). It is the nulls that are duplicates.
I can fix it by using DISTINCT but not sure if that...
March 27, 2019 at 11:15 pm
The union does give flexibility to how the rows are handled.
I did it like your first suggestion and just changed valueType to allow me to use the where...
January 31, 2019 at 10:26 am
That wasn't really what I meant but I figured out how to do it.
I can't stop all three from being sent from the cross apply, but I...
January 30, 2019 at 11:18 pm
Another question on the above cross apply.
Using the above Cross Apply where we have 3 rows coming back, is there a way to tell it to only send...
January 30, 2019 at 6:51 pm
I do like that simplification.
January 30, 2019 at 1:15 pm
That helped a lot.
Here is the solution that is a little closer to what I was trying to achieve
I have 2 tables (old values and new...
January 30, 2019 at 10:21 am
That's fine.But I don't need a list of names (my mistake). I need to use another value in the record to go along with the names in each record. ...
January 29, 2019 at 7:59 pm
That could be.
But if I press the disable rule, I get an error and there is no close button.
August 20, 2018 at 2:29 pm
I did get my query to work using this and I figured out how the calculation worked,
I was confused on the syntax of the 2nd Cross Apply:
August 1, 2018 at 11:44 am
It looks like it works. Just not sure why.
I understand what the cross applys are doing just not sure why a couple of things are for.
July 31, 2018 at 8:52 pm
July 31, 2018 at 4:29 pm
This was just a sample of the actual code which is a bit more complicated and I do convert it to actual dates.
June 22, 2018 at 11:54 pm
Great.I also made a small change that lets me select the range. If @Choice is NULL, it will work as you have it. @Choice is the number of years...
June 21, 2018 at 3:43 pm
You're right. I just marked the latest one. Didn't notice that the answer was right above it.
And yes, I do understand how it works. Was...
June 12, 2018 at 12:15 pm
I forgot I was on 2008. I use both servers.
This gave me what I needed.
June 12, 2018 at 12:10 pm