Or you could use the attached code (couldn't post it directly, again).

Yes, you are permitted to yell. I'm glad we were able to help you find the problem. Sometimes it just takes another set of eyes. Typical Forest...

Why?

Again, look at the error message. It is not complaining about the temporary table:

Msg 4701, Level 16, State 1, Procedure SP_REFRESH_CHEMPAX_COSTS, Line 30

Cannot find the object "CHEMPAX_COSTS" because it...

Sample Data? Expected Results?

I don't think the problem is your temporary table, look at your error message again:

Msg 4701, Level 16, State 1, Procedure SP_REFRESH_CHEMPAX_COSTS, Line 30

Cannot find the object "CHEMPAX_COSTS" because it...

Looks like he's been on. Changed his name to Express12. Like that will keep him off peoples radar! 😉

virgilrucsandescu (8/24/2009)

---

Hi,

Is there any other (better) way of optimizing a

SELECT f1 FROM t1 WHERE f1 NOT IN (SELECT f2 FROM t2)

except the classical :

SELECT f1 FROM t1 WHERE NOT...

Not sure what yhe problem is. What would help is the DDL for the tables (CREATE TABLE statements), sample data for the tables, and expected results based on the...

GSquared (8/24/2009)

---

Lynn Pettis (8/22/2009)

---

You are right, to a point. ...

Views are extremely useful. What it means is that instead of doing

SELECT

Col1,

Col2

FROM

dbo.MyView;

where the returned result...

Additional Info from BOL (Books Online) with regard to CREATE VIEW:

Note:

The ORDER BY clause is used only to determine the rows that are returned by the TOP clause...

Cross database queries, you will need to grant them access to underlying tables in the other database.

I don't think granting just public access to the other database will work. ...

jdhouse (8/24/2009)

---

ALTER VIEW [dbo].[vFrmMainCboMessageItem]

AS

SELECT TOP (100) PERCENT itemId, messageTypeId, sequence, description, required

FROM dbo.messageItem

WHERE (messageTypeId...

Be sure to test. I vaguely remember running into this and going across databases I had to grant access to the tables in...