Forums before death by AOL, social media and spammers... "We can't have nice things"
|    comp.databases.ms-sqlserver    |    Notorious Rube Goldberg contraption    |    19,505 messages    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
|    Message 19,457 of 19,505    |
|    Erland Sommarskog to Erland Sommarskog    |
|    Re: Custom window functions    |
|    26 May 23 21:00:34    |
      From: esquel@sommarskog.se              Erland Sommarskog (esquel@sommarskog.se) writes:       > However, I need to add a caveat here: The fact that this runs might       > be a bug. I seem to recall that there is something about CLR       > aggregates and ordering. That is, if this runs but produces an       > incorrect result, this is not good. Then again, my aggregate is       > supposed to return an ordered result, and it seems to do with my       > test query. But that may be due to chance.       >       > I will need to bring this up with some people at Microsoft.       >              An MVP colleague was kind to point me to       https://learn.microsoft.com/en-       us/dotnet/api/microsoft.sqlserver.server.sqluserdefinedaggregateattribute.is       invarianttoorder?view=sqlclient-server-dotnet-1.0       which suggest that there is something hiding here.              --- SoupGate-Win32 v1.05        * Origin: you cannot sedate... all the things you hate (1:229/2)    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
(c) 1994, bbs@darkrealms.ca