Re: Dynamic date range for each row?
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Wed, 30 Jan 2008 22:23:03 +0000 (UTC)
Gert-Jan Strik (sorry@xxxxxxxxxxxxxxxxxxxxx) writes:
According to SQL Server 2005's Books Online, aggregate window functions
only support partitioning by a column. IOW, AFAIK SQL Server does not
(yet?) support PRECEDING or CURRENT ROW as windowing selectors.
Yep. There is a request on ORDER BY for aggregates on Connect:
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=254387
There is also one for RANGE and ROWS
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=254392
There are also a whole more requests for enhancements to the OVER clause,
most of them taken from the ANSI standard. You view a list on:
https://connect.microsoft.com/SQLServer/feedback/SearchResults.aspx?SearchQuery=%22OVER+clause+enhancement+request%22
Would this come in SQL 2008 (it does not seem so), SQL 2008 would be
really hot.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- Dynamic date range for each row?
- From: lee.richmond
- Re: Dynamic date range for each row?
- From: jefftyzzer
- Re: Dynamic date range for each row?
- From: Gert-Jan Strik
- Dynamic date range for each row?
- Prev by Date: Re: Avg() not including 0's
- Next by Date: Re: Inserting multiple records into two tables...with a twist
- Previous by thread: Re: Dynamic date range for each row?
- Next by thread: detach database file from local SQL Server Express instance by C#?
- Index(es):
Relevant Pages
|
