I got nothing to offer !

Can we see the full procedure??

I don't think you'll find anything really fast in that query .

Oops.. I forgot the rest of the changes to the system tables !!

Thanx Gopi!

Your version of the query is pretty much an inner join in disguise.  Try this in case it works ?!?!

update hdtd

 set hdtd.TechnicalDescription = stg.TechnicalDescription

 from stg_HelpDetailsTechDesc stg

 Left join HelpDetails hd on...

Change the schema from sys. to dbo.

Expanding on this... you could create 2 other tables for the extended information on the customer.

Another way of doing vertical partitioning .

We already had this discussion here and on many other forums.  Nobody has been able to prove that using "1","*" or a single column had an impact on performance.  The...

It might be because  you are using old a new sql syntax.

try putting joins for all tables (even for the cross joins).  That should be fix your error.

For that I'd suggest my version... by maybe you should turn it into a function so it'd be easier to access.

Do you need that based solely on the name or on the columns used (and their order)?

Now that I think of it, what don't they do both ?

What would actually be much better and IMHO easier or as simple to code, would be to simply link to the right page and to the bookmark of the post...

How is that gonna avoid the server validating the sp??

thanx