Thanks guys, my bad! I did some testing enclosing it in parenthesis and messed up when posting. Unfortunately this isn't the problem. NHibernate still doesn't recognize OVER and PARTITION as reserved words.
I also think I messed up with adding a column alias, so the "correct" formula (that stil causes an exception) is: ROW_NUMBER() OVER (PARTITION BY AgreementId ORDER BY EffectiveDate DESC) --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
