You could insert the results into the same temporary table, then use SELECT DISTINCT if you want a true union result set instead of UNION ALL.

--Jonathan

SELECT Qn_Id, Qn_Set, Qn_No

FROM Questions q

WHERE Qn_Id =

(SELECT TOP 1 Qn_Id

FROM Questions

WHERE Qn_Set = q.Qn_Set

ORDER BY NEWID())

ORDER BY Qn_Set

--Jonathan

quote:

---

However, if the stored procedure is being called by an application, it is safe to assume that login identity is being provided....

quote:

---

Here is a script my company uses regularly to clean up large logs. The last statement is to ensure the size...

quote:

---

It is a privilege to see so much confusion.

---

My thought exactly. OP was...

quote:

---

Jonathan, you are right in the need for order when using TOP. The problem is that the full query runs in...

quote:

---

If I already have the vendor numbers in a permanent table, why would I need to put them in a temporary table?

...

quote:

---

GuardData: I am getting

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <=...

quote:

---

quote:

---

...One does not drop a database by deleting it from sysdatabases or an updatable...

UPDATE Master SET Om_Note =

(SELECT TOP 1 SUBSTRING(Txt_Notes,1,60)

FROM OrderNotes

WHERE OrderID = Master.OrderID AND Type_Cd = 9

ORDER BY NoteID)

--Jonathan

Edited by - jonathan on 09/30/2003 09:02:21 AM

Edited...

quote:

---

I checked the lightweight pooling and it's not on.

---

Then I guessed wrong.