YB751,

Thank you, Sir. This worked out nicely. Regarding the data type, I figured as much, but couldn't come to terms on a proper solution. I greatly appreciate...

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...

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...

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...

Hi, Alvin,

My apologies for a vaguely wording the initial post. Hopefully this answers your question - Of the multiple employee records returned they always have both 2080 (annualizing...

Hello, All,

Thank you. I am overwhelmed with the expeditious replies. This was just a sample data set to get an idea multiple records that are being retuned. ...