And here is another good reason for existence check.

Because inner SP depends on #table it should terminate execution immediately if outer SP failed to create #table or inner SP got...

Try to execute

SELECT DATALENGTH(Content), IsDownMaint

FROM dbo.ContentManagement

WHERE ContentID = @ContentID

Probably it's the size of ntext thing what gives you hard time.

Because you've got PK on the column, no...

Does it happen often?

Man, you should rethink you approach to database design.

Changing schema must be a big event everybody...

simon.letts (1/10/2008)

---

Thanks for all your help guys. Matt, your script did the job fine!!!

However we are currently testing against a limited set of rows so I will insist we...

But when I tried to call a stored procedure to created the #temp table, that table name was not visible to subsequent statements within the same query. I can't...

At least 2 of us described reasons for...

Jeremy,

there is no any point in wrapping each statement in a begin tran/commit block because they are transactions anyway.

And I would guess that was a typo.

I really doubt real tables...

I mean executing all 3 statements in one go but without wrapping it in a procedure.

Just as you pasted it here.

What happens if you execute those inserts in a batch?

I believe "spooky" was about

SELECT * FROM SYSOBJECTS

WHERE name = '#MyTempTable'

And I have played a lot with applications used connection spooling recent years. No problems discovered.

But I do existence...

In "Tables" tab right click, select "Link to Tables", in File Types select "ODBC Databases()" and follow instructions of the master.

Lynn, wrong because it returns biggest OrderID, not OrderId for the latest order,

In that test database you used it's just happened that OrderDate and OrdeID correlate, that's why your query...

In MS Excel go to Data -> Import External Data -> New Database Query.

Follow instructions in the wizard to create a query to your database.

Lynn's code gives you absolutely wrong idea.

For your question Sergiy, assume that in case of duplicate...

I understand you need 1 record per customer.

You did not...