Path: csiph.com!weretis.net!feeder8.news.weretis.net!eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail From: Anton Shepelev Newsgroups: comp.databases.ms-sqlserver Subject: Re: Custom window functions Date: Fri, 26 May 2023 22:55:28 +0300 Organization: A noiseless patient Spider Lines: 13 Message-ID: <20230526225528.c6b442024923652f59b029be@gmail.moc> References: <20230522123254.38c0b664930a7bc595f60a3a@g{oogle}mail.com> <20230525183854.3b73cd327e64ae145fe48c5b@g{oogle}mail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Injection-Info: dont-email.me; posting-host="4642feab05d3f9162ec6d95aba671bde"; logging-data="89570"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18dwnlCBpcqm4bpKKYphiu4mj7Qo1o0m4I=" Cancel-Lock: sha1:7C7oox4Vb8ewTs5ocTAnwyRvR8U= X-Newsreader: Sylpheed 3.7.0 (GTK+ 2.24.30; i686-pc-mingw32) Xref: csiph.com comp.databases.ms-sqlserver:2218 Erland Sommarskog: > An MVP colleague was kind to point me to > https://learn.microsoft.com/en-us/dotnet/api/microsoft.sqlserver.server.sqluserdefinedaggregateattribute.isinvarianttoorder > which suggest that there is something hiding here. It being "reserved for future use", the hidden thing is the latent potential for arbitrary time-series analysis via cusom aggreage functions! -- () ascii ribbon campaign -- against html e-mail /\ www.asciiribbon.org -- against proprietary attachments