twin.devil (12/23/2015)

---

if you mean that number of rows to be fetched of a single date. it would look something like this. You can give a parameter how many rows should...

Thanks, you guys are good at this.

Peter Brinkhaus (12/23/2015)

---

Not very dynamic, but here's an attempt. How many rows do you expect for the lowest two dates?

SELECT

ca.n, t.cl_t, t.cl_a,

CASE...

twin.devil (12/23/2015)

---

Well its not about the OFFSET what you have shown in your desired output u need to get CurrentRow and two previous rows data for each 3 dates running...

USE [tempdb]

GO

IF OBJECT_ID('[tempdb].dbo.tb_a', 'U') IS NOT NULL DROP...

Just seen your link!! Will reformat. Thanks.

Hi

Well the 10 rows constraint is supposed to help in 'batching', i.e. We focus on the sums of up to 10 rows for each row in the table. But let...

Okay here is an example

The column cl_a has values (1,2,3,4,5,6)

And for simplicity let's say the total rows to be fetched when computing the sums is only 3 and not 10...

Thanks, but the solution provided by Drew is scalable, which is what I wanted. Thanks any way

Thanks A LOT!! This is exactly what I was looking for!

Thanks again 🙂

Hello,

I have a similar problem. The difference is the number of sums returned is variable, i.e. it is determined by an input parameter.

How do I code this?