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...

I understand that what you wrote was an illistration of how IN works. My point is if you actually write a WHERE clause like that, you would use OR...

rambilla4 (8/24/2009)

---

From Log shipping Backup job view history:

Selected row details:

Date8/24/2009 8:45:00 AM

LogJob History (LSBackup_Mydb)

Step ID1

Serversqlvs\ins1

Job NameLSBackup_Mydb

Step NameLog shipping backup log job step.

Duration00:00:00

Sql Severity0

Sql Message ID0

Operator Emailed

Operator Net sent

Operator Paged

Retries Attempted0

Message

2009-08-24...

Not disputing the NOT IN not working if nulls exist in the data.

I'm disputing the explicit code that has been shown. First, whoever wrote should not have used somecol...

Andy DBA (8/24/2009)

---

rja.carnegie (8/24/2009)

---

Wait, isn't that...

arup_kc (8/24/2009)

---

Unfortunately, in this case, you only substitted one form of RBAR for another form of RBAR. The best solution in this case is to find a set-based solution...