No doubt of that.

But like i said before, even if change the index and the logical reads decrease about 50%, the time is the same.

And if i use the...

Just for testing i tried your suggestion, but the time it's almost the same, so in this case, at least with this amount of rows the only difference that i...

Found a solution/workaround

If the complete query takes no time, just mix the two querys:

SELECT pf ,

Data ,

Descr

FROM dbo.PFAuxiliar PFA1 INNER JOIN (

SELECT ROW_NUMBER() OVER (PARTITION BY pf ORDER BY...

@Gazareth

Yes it's MAX, this is a aux table with some comments to every pf at another table.

At this point i need to return every row, it's kind of...

Thanks for all the replies.

I solved the problem in the SSMS GUI, Activity Monitor, Processes tab, filter the TempDB, and then selected the process and Kill 🙂

THanks

Thanks for the quick reply.

How can i do that?

Just to put the things in perspective i have my login, the same login that created the sp in the production...

Me and the PIVOT function... :doze:

Thanks works great.

@JeeTree

Thanks for the info and for the links.

@sean Lange

The output in the sample it's the content of the @Third table.

I'll try to put the problem in another perspective.

Assuming...

To literal...

When i say next row, i mean all the rows, not necessary the next id...

In this case, i have 5 + 10 + 100 = 115, and i have...

Oh... Bad habits, someone helping, then we forget to think...:ermm:

Reversing the order, its obvious that if the date exists it will find it before the Row Num. 😀

Thanks

Thanks

But it doesn't work, the final result of that query is:

Grp 1 - 2014/09/14 - Comment 3

Grp 2 - 2014/09/19 - Comment 5 / Should be - 2014/09/14 -...

Nice tip, I'll have that in mind in the future.

Normally my approach it's building a working solution, like the cursor version heavy/slow, and then working my way out to optimizing...

Hehehe, i just forgot to save the @Percentage value for each row, or at least when the first insert statement doesnt run... But nice to pointing that out. 🙂

Thanks for...

Hehehe

The sample code with a working cursor version of the situation:

GO

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

DROP TABLE #TesteTable

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

DROP TABLE #TesteTableFinal

CREATE TABLE...

OK

I'll try, i have stored in a temp table information about items that must be sent to the factory to production, several joins and calculations to get to this point.

For...