jsanborn (4/2/2009)

---

Since this was posted for a community of database professionals, I didn't think a great deal of detailed explanation was needed just like I didn't think it necessary to...

GSquared, feel free to increase the 9 to int(max), bigint(max) or anything else.

I just chose 9 because I felt like this 🙂

Hi arr.nagaraj,

I told the reason already: If order doesnt matter, then 10,11 means the same as 11,10.

So I allow to store...

Bob, I don't get your sorting.

You are comparing row1,col1 against row2,col2

But I really think that what you should do instead is

(rule 1) compare rowx,coly against rowx,colz (each column against...

Chris Morris (4/2/2009)

---

Christian Buettner (4/2/2009)

---

Not sure what this is all about, but is this something you would expect?

SELECT *

, (SELECT COUNT(*) FROM b

WHERE ISNULL(col1,0) <= ISNULL(al.col1,9)

AND ISNULL(col2,0) <=...

Looks like it doesnt(unless I made a mistake):

declare @u2bobnoxious table (ID int, Col1...

Not sure what this is all about, but is this something you would expect?

SELECT *

, (SELECT COUNT(*) FROM b

WHERE ISNULL(col1,0) <= ISNULL(al.col1,9)

AND ISNULL(col2,0) <= ISNULL(al.col2,9)

AND ISNULL(col3,0) <=...

You can either wrap the TRUNCATE in a stored procedure and call that stored procedure instead, or you can use the solution from Perry:

Perry (2/15/2006)

---

However, you could switch to calling...

Hi arr.nagaraj,

why do you think it should be allowed?

If the two columns store the possible combinations of fruit that are sold in a bag, then the order surely doesn't...

Just another option from a logical standpoint (ignoring performance considerations which I doubt to play a role for this type of query, unless it's a monstrous school federation with millions...

These two statements are semantically the same.

You probably wanted to write this instead:

insert into t3(n1,n2) values (10,11);

insert into t3(n1,n2) values (11,10);

Another...

Not sure about this, but it sounds odd to me that a user regularly updates up to 10 million rows.

Do you have some more details on your table design and...

That was a very nice explanation, thank you.

I just wanted to make sure I did not miss anything and will NOT start a long discussion;-)

Could someone please explain why "Applies data changes to subscribers" is wrong?

Thanks!

RBarryYoung (12/31/2008)

---

Christian Buettner (12/29/2008)

---

RBarryYoung (12/29/2008)

---

Still waiting for your response to my question:

RBarryYoung (12/28/2008)

---

Christian Buettner (12/28/2008)

---

I might be nitpicking...