Brandie Tarvin (7/26/2010)

---

lionwelp (7/26/2010)

---

It is a matter of priority, first and foremost is it the lowest Status, second is highest druk_nr (there is also a date/time, but i guess that's...

The status is the lowest, but the druk_nr is NOT the highest. And if you want the highest druk_nr (5) and the lowest status (1) in the same result set,...

Brandie Tarvin (7/1/2010)

---

What is vvers_dat supposed to be? I'm running your code on my sandbox and I can't do the data insert because that column disallows NULLs and has no...

Brandie Tarvin (7/1/2010)

---

Honestly, I think you're overly complicating things. You don't need the function, if I'm reading your code correctly. You can just do a CASE statement in the JOIN...

Eugene Elutin (7/1/2010)

---

Cool!. There is a small difference between most RECENT and most ACTIVE status, is'n it? What defines "the most ACTIVE status"? Is it highest Volgorde value in your...

Mike01 (7/1/2010)

---

again, I don't know what you are expecting for results. I can keep posting tables of what I think you expect, but if you don't tell me, I...

Mike01 (7/1/2010)

---

I still don't understand what you are looking for for results. Is it

ISBN Status

30955619911373

30955619911363

30955619911343

30955619911333

30955619911323

30955619911313

30955619911306

because that is the highest status the...

Eugene Elutin (7/1/2010)

---

Do you want the most recent status to display? Which column defines that it is a most recent status? vvers_dat or creatie__dat or something else?

...

My apologies about being too restrictive about my question.

I'll start with the 2 table definitions :

First the Titel_BB table :

CREATE TABLE [dbo].[titel_bb](

[druk_nr] [int] NOT NULL,

[vvers_dat] [datetime] NOT NULL,

[status] [smallint]...