How to get all events of Hopping window to perform calculation?

Question

Hi,

I am working of one application where I am getting data from different sources for the same time.

I am using hopping window to get the events and want to perform calculation on that events at once.

EX: Below is the sample illustration for one hopping window,

Let’s say one hopping window having 5 events

Time	Field1	Field2	…	FieldN
00:00:01	123	235	..	235
00:00:02	123	235	..	235
00:00:03	123	235	..	235
00:00:04	123	235	..	235
00:00:05	123	235	..	235

How can I write extension method for that Window, so that I can get all the 5 values of Field1 to N at once and apply my calculation.

Thanks In Advance.

Answer 1

That would be a user defined operator (UDO). See http://msdn.microsoft.com/en-us/library/ee842720(v=sql.111).aspx.

---

DevBiker (aka J Sawyer)
Microsoft MVP - Sql Server (StreamInsight)

---

---

If I answered your question, please mark as answer.
If my post was helpful, please mark as helpful.

Answer 2

Thanks for you response.

I will check UDO.