August 14, 2015 at 12:47 pm
Alvin,
Thank you for the tip.
The multiple records returned are always the same in each case. One row contains 2080 (factor) and 1 (percent) while the other contains 1640 (factor) and .60 (percent). When this happens we will always need the row with the 2080 (factor).
August 14, 2015 at 12:59 pm
Hello,
It is implied that if there are two occurrences of the same [Name] element then one will have the AnnualizingFactor of 2080.
Correct. When two occurrences with the same name element appear one row always has 2080. The other 1640.
Now it is also not guaranteed that the 2080 will have the PercentFullTime value of 1.
Every record containing 2080 has the PercentFullTime value of 1.
August 14, 2015 at 1:03 pm
tjs8984 (8/14/2015)
Hello,It is implied that if there are two occurrences of the same [Name] element then one will have the AnnualizingFactor of 2080.
Correct. When two occurrences with the same name element appear one row always has 2080. The other 1640.
Now it is also not guaranteed that the 2080 will have the PercentFullTime value of 1.
Every record containing 2080 has the PercentFullTime value of 1.
Thanks you for clarifying this and the good news is that all the solutions provided so far will then work perfectly.
😎
August 14, 2015 at 1:26 pm
I hoped to simplify the question when asking and probably should have posted the query in its entirety and the result set. This is my first post so I am certainly learning how to do it the right way.
Thank you all. I appreciate your time. Back to the drawing board for me and with your suggestions I will be in good shape.
Cheers
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply