did you get a response for this? looking to get the same..

sorry that I wasn't clear,

expr1003 is Date

raceno (race number) and event_id are in the order by, if you watch first post, they're named there and you can see example data...

sure thing, the order by is for

ORDER BY expr1003 DESC,

raceno DESC,

event_id DESC

the count1 with a lag() function. since it has to get from the first "1" to the second "1" and so on

I have fixed the insert.

basically what I need to do is to summarize the  count of column "count2" for a every partition, and then subtract it to the field in...

• This reply was modified 4 years, 8 months ago by  Baldie47.

now I understand. sorry for being slow 🙂 I thought you actually wanted the whole package. here it is the DDL for the problem and example data.

CREATE...

• This reply was modified 4 years, 8 months ago by  Baldie47. Reason: fixed the insert

a gif? what are you watching at? I added tables, sample data, screenshots. what is what you need? the problem with data an expected results is there. am I missing...

I adding another image to show what I'm needing:

I need to sum the numbers within the blue boxes and substract them from the red boxes in...

the ddl for the table is actually huge, the table has over 800 fields.

the example is quite simple though, do you think you need more information?

the data is ordered by...

yes, I'm now working on setting it up with ITVF.

I have a small doubt about the query:

ALTER FUNCTION [dbo].[FN_WinnerRunners](@event_id INT, 
@BSPFrom SMALLINT, 
@BSPTo SMALLINT, 
@Win_Lose SMALLINT, 
@RunnersFrom...

can a view receive parameters? no, right? I'm thinking about how would I do it if I need to for bringing all the columns I need, with all the different...

and what do you recommend to do?  I was looking into using a cross apply, but I think it will be the same