Mark Townsend wrote:
> Mark Townsend wrote:
>
>>
>> SQLServer doesn't have many of these equivalent capabilities in the
>> SQL engine, so SQLServer users tend to go to the OLAP engine in
>> SQLServer for equivalents.
>>
>
> I will note in passing that SQLServer 2005 does now implement the
> partition by clause, and some of the ranking capabilities, bringing them
> more inline with the relevant SQL BI standards in this area.
Jonathan Gennick's newest edition of the SQL Pocket Guide will have a
new chapter on OLAP. I didn't review the final version with SQL Server
2005 lastest edits but it will be an interesting comparison when it hits
the shelves this spring.
Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Received on Sun Feb 26 2006 - 20:05:28 CST
