Turns out my last attempt was actually almost right. I caught a couple of mistakes because I had actual data to work with. Here's the slightly...

Nope. The only way...

You've been asked several times to create the scripts and yet you still continue down the path of providing something less. If you can't follow instructions, or just...

Avoiding what was asked for isn't going to get you anywhere... That last post only makes things ever so slightly more clear, but does not illuminate a solution....

matfurrier (7/11/2014)

---

friends,

I'm grateful for all the help.

However, all the scripts that I have tried here are returning me the same result.

I still do not understand why the...

That LEFT OUTER JOIN really needs to be an INNER JOIN, and will become one anyway due to the WHERE clause. However, this otherwise appears to do what...

matfurrier (7/11/2014)

---

For me, the last transaction is not defined by date but by purchase order number.

The order with the highest number is the last created.

The numeric sequence of...

Thanks for the update. I was truly scratching my head on this until you explained what you did with it.

matfurrier (7/11/2014)

---

I need to show the last transaction of purchase of all items (Itemid).

This, separated by company (Dimension3_).

Each purchase order (PL.Purchid) generates a transaction in stock (I.TransrefId).

What...

One thing I noticed right away was that the "slow" one has two "Nested Loop" icons, while the "fast" one does not, and includes parallelism. Taking advantage of...

Whether or not you're in over your heads on the upgrade is a question I can't answer, but... that said, doing it without a DBA just doesn't sound like...

mai.quangvinh (7/10/2014)

---

Hi sgmunson and friends,

Your approach is ok, but I have a request that how to move the last row in your query to the first row position. Actually this...

I'm at a loss to understand, as his query...

Glad I could help, and thanks for the update.

Doesn't that depend on the cursor? They aren't always evil, ... they're just often not necessary... However, that said, I'm still waiting on the OP...