MSSQL 2000 and higher offers a useful "WITH TIES" statement that can be inserted into SELECT TOP queries, ensuring that the "top" includes ties. From the SQL documentation (http://msdn.microsoft.com/en-us/ library/aa259187%28SQL.80%29.aspx):
WITH TIES Specifies that additional rows be returned from the base result set with the same value in the ORDER BY columns appearing as the last of the TOP n (PERCENT) rows. TOP ...WITH TIES can only be specified if an ORDER BY clause is specified. Is there any equivalent of this in NHibernate (in HQL or otherwise)? Thanks! - b -- 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.
