Looking to the things like that, it looks very easy...

But it's not handling the 50% interval duration, neither it's capable of it, for example if i have 1 day...

Volatile yes...

Offset?! What do you mean by offset row?!

Yes i need.

I'm currently using/testing in the 2008 version, but i need that the code works in the 2005 version too...

Just posted in this section because i thought that...

Thanks for the replies...

This chunk of code it's a requirement inside a bigger sp, the table it's a table that contains some fields a start date, duration (days), and several...

Made some tests and the loop version its equally slow...

So do anyone knows how I can speed up this?

Thanks

Thanks for the tips.

Always learning...

And it's working with your help!

Like i wrote i used the vars to test if everything was working, and it isn't, so probably i would added...

The extra "lines", vars and everything was for testing purposes, trial and error... And looks like these lines were the responsible for the problems... 🙁

But anyway, thanks for the info...

@Erin Ramsay

If i had the Identity in the History table, that was the way to go... but i don't have, when i created this table i set the date and...

@sean League

The main problem here it's I'm not seeing how to iteract with each row to compare the values... In the Row N i need to check the...

GO

IF OBJECT_ID('TempDB..#OrginalTable','U') IS NOT NULL

DROP TABLE #OrginalTable

IF OBJECT_ID('TempDB..#HistoryTable','U') IS NOT NULL

DROP TABLE #HistoryTable

CREATE TABLE #OrginalTable(

ID INT IDENTITY(1,1) PRIMARY KEY CLUSTERED,

A CHAR(1),

B...

Thanks

@sean Lange

I know the nullif, but to use that function i need to write every column... :crazy:

@steve-2 Jones - SSC Editor

I'll create some sample data... The...

:blush:

End of the day of friday, hard week... dumb questions... :satisfied:

Now it's obvious that i need to sum the values... 😀

Thanks

Hi

I have to reply with text, in this machine i don't have any sql server installed.

So if i run the above code i get something like this:

Num Name ...

Thanks

I was using the CROSS APPLY, but to test i was using the GETDATE that returns date and time so the ITVF doesn't returned anything... :Whistling:

The all procedure now takes...