from the shallow end of the gene pool 😎

RBarryYoung (4/2/2009)

---

Chris...

I don't think the original query does what you think it should. Try this, but comment out the INSERT line first and run only the SELECT:

INSERT INTO ExtraContact (ExtraValueID, ContactID)

SELECT...

What does this return, Karl?

SELECT e.ExtraValueID, e.ContactID

FROM ExtraContact e

INNER JOIN Contact c ON c.ContactID = e.ContactID AND c.Email IS NOT NULL

WHERE e.ExtraValueID = 98203

Hello

Can you please post the table create script for table ExtraContact?

This code generates some sample data; 250,000 rows of six data columns plus an id column which holds the correct order of the data set as described so far by...

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) <= ISNULL(al.col2,9)

AND...

No such person has responded to this thread.

jsanborn (4/2/2009)

---

The values always increment across the row such that, when the rows are in order, the values in all columns also increment top to bottom. There are random cells...

jsanborn (4/1/2009)

---

Anyone know how to sort this:

ID Col1 Col2 Col3

1 3 4 ...

Good grief, it's the White House window...

142 posts and 10 months on essentially the same query...

-- Query 1

SELECT s.Id, s.Name, c.*

FROM school s

INNER JOIN courses c

ON c.SchoolId = s.Id

WHERE EXISTS (SELECT 1 FROM courses WHERE SchoolId = s.Id AND [Name] = 'maths')

...

Andrew Winch (3/31/2009)

---

Chris,

Very interesting.

So what you are saying is that even with the complexity of the CASE added to the query, the number of scans needed by the UNION ALL...

Flo's already written it for you, Allan. Do you know how to do an UPDATE...FROM...?

rajeevgupta40 (3/30/2009)

---

sum (quantity) from product table -sum(quantity)from order table.

so i unable to understand how query to select record with left total quantity in product table group by

productID,productname,suppliername, unitprice.

hope this explaination...