SQL Server 2008 R2: StreamInsight changes at RTM: Access to grouping keys via explicit typing

Posted by Greg Low on SQL Blog See other posts from SQL Blog or by Greg Low
Published on Sat, 08 May 2010 03:20:00 GMT Indexed on 2010/05/08 3:39 UTC
Read the original article Hit count: 374

Filed under:
One of the problems that existed in the CTP3 edition of StreamInsight was an error that occurred if you tried to access the grouping key from within your projection expression. That was a real issue as you always need access to the key. It's a bit like using a GROUP BY in TSQL and then not including the columns you're grouping by in the SELECT clause. You'd see the results but not be able to know which results are which. Look at the following code: var laneSpeeds = from e in vehicleSpeeds group e...(read more)

© SQL Blog or respective owner