Re: Can I do this using SQL?
Date: Sun, 12 Feb 2006 11:30:38 +0100
Troels Arvin wrote:
You could add some info:
Starting with SQL Server 2005 Microsoft supports a limited subset of SQL:2003 OLAP functions, too.
RANK, DENSE_RANK, ROW_NUMBER OLAP aggregates, but a window definition is not supported, it defaults to: ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING e.g. SUM(x) OVER (PARTITION BY y)
Dieter Received on Sun Feb 12 2006 - 11:30:38 CET