Select by Max(predictiondate) and by Days Difference in a single Sql transaction

Can you please also share with us output of

SELECT @@VERSION

?

This is what Erland is after. I will probably not try to answer your question, I let Erland help you.

---

For every expert, there is an equal and opposite expert. - Becker's Law





My blog



My TechNet articles