Garadin (10/29/2008)

---

Due to the nature...

I believe that is true Seth, well pointed out. Thank you for helping me explain and thank you for your help.

Although, the only thing I'm also concerned about is the...

Garadin (10/28/2008)

---

Oooh. Do me! Do me! (New solution a few posts back.) Despite the cursor, I'd wager that it'd run *fairly* quick. Unless I screwed...

smunson (10/28/2008)

---

Dan,

.....

Let me know if you can test this against other patterns and see if it works. The reason I can't be sure of performance is because I...

AnzioBake (10/28/2008)

---

The above change produces the following results

RowIDRowKeyLocaleCode

11enA

21enA

51enC

71enA

101enA

121zhA

131zhA

141zhA

201enD

Note

the first row in the table is removed RowId= 0

Rows 12, 13, 14 are all in the result set as required

Am I...

It should include both...

smunson (10/27/2008)

---

I continue to think that a complete statement of the problem coming from the OP has yet to occur. There is no written description of the EXACT...

Hello Anzio, I apologize for not getting back to you...

Garadin (10/22/2008)

---

Sorry for not getting back with you Dan. Lost the primary hard drive in my dev machine yesterday, so it was an all day affair getting the thing...

AnzioBake (10/22/2008)

---

I had some trouble logging on so read the other posts after my reply

I had to make a change but now I am not sure if the result set...

Jeff Moden (10/21/2008)

---

I swear I've done this problem on this forum before... :hehe:

Dan, in the GIF file example, please tell me why RowID 10 is NOT considered to be a...

smunson (10/21/2008)

---

Dan,

Not to rain on your quest here, but I don't think you've actually provided a complete statement of the problem. I know that it's very clear to...

AnzioBake (10/21/2008)

---

/Quote

SELECT 14,'1','en','A' UNION ALL --/second(2) batch of A

SELECT 15,'3','en','A' UNION ALL --/second(2) batch of A

SELECT 16,'3','de','A' UNION ALL --/second(2) batch of A

SELECT 18,'1','en','A' UNION ALL --/second(2) batch of A...

Garadin (10/20/2008)

---

My apologies for all the semi correct attempts, had I taken the time to read all the posts I glossed over from a couple days ago, I'd have seen...

Garadin (10/20/2008)

---

Ok, I just discovered something interesting. The reason it wasn't working before is because the @LastDupe variable inside that CASE statement does not get properly evaluated for the...