home bbs files messages ]

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