same starcast - different movie - this the thread you were looking for...?!?!

As people above have pointed out - you should always use fully qualified names as best practice anyway...

"dbName.dbo.tblName"

Having said that, I don't understand why you're creating tables through stored procedures...

please do not cross post - follow the thread here

Here's one way that I could think of - this is not tested and you'll have to work on it, but here're the steps:

1) Select into your "Project01tmp" table the...

Here's one example from BOL...

USE pubs
GO
SELECT length = DATALENGTH(pub_name), pub_name
FROM publishers
ORDER BY pub_name
GO

And just in case you want to find what the max length for the specified column in...

Sridhar - could you please provide more information...

1) post the 2 procedures that you're using.

2) you say the first one works - if you use QA to connect to the...

I read this "study" too...

The benefits of red wine have been touted for a long time now...for me, nirvana's an evening of wine, bread & cheese.......with either a great...

whatever happened to the restrained sangfroid that the Brits are famous for ?! Must be the influence of those people across the channel!!!!

NO NO D.Burrows - YOU are on the pedestal - I put you there (along with several others I'm sure...) - now you just need to make sure you stay...

john - why don't you post the ddl & sample rows from your 2 tables...can't test this but if you try something like this, it should work...

SELECT A.ID, B.ID,...

An alternative certainly - but not quite the elegant minimalistic solution that I've come to expect from you...

just goes to show that a pedestal is a very precarious place to...

John - if what you've posted is the full extent of your procedure, why not use a left outer join instead ?! why use a cursor at all ?!

edited -...

Milind - I lost the link but this was one of the solutions posted on another site for a similar error...see if implementing these 2 suggestions help!!!

"Mke sure that you...

Olivia - could you please post your update statement as well as some sample rows from your table...

Also, when you test this in QA does it work w/out errors ?!

maybe a user-defined variable name in code ?!?!?!?!

Rajesh - could you please post your procedure for someone to look at ?!