This is the first time I am hearing that the SSMS changes the syntax of a query.

Yes, there was a mistake on the script. I had two ON in the...

What tool are you using?

Did you try running it in Sql Server management Studio?

Glad to be of help

Just like Sarah Wagner posted, you should try updating the Alias.

Try this and please give us a feed back.

Update WLI

set WLI.linPartNum = 'ST'

from webOaLineItems as WLI

INNER JOIN webOaHeader as wH

on...

I did not understand properly. Which table are you updating and what columns?

Ah... Dawn of the dead.... We are all going to be stars in a slash and burn movie... Yea, I always wanted to be a star...

Kind of difficult, but you can try using this trick. (I am not sure if it is accurate or not)

Use the profiler to check for Compile/recompile for the SPID from...

First error message is that you have to register the name of the server when connecting. (Not using . or [local] )

Second, check and see if the Port 1433 is...

LOL @Lynn... That is one advantage of living in the Caribean. It is Sunny and bright.... Even in the middle of Winter, it is 23 degree Minimum 😎

That is me..... I live in the Caribbean 😎

NotManyPoints (2/4/2009)

---

Maybe the OP who was asking when to use it, wants to use it. Maybe we have all helped some teenager figure out how to crack the school...

I report to the CTO. But will take orders from CFO... He deals with money, You keep him happy, everything is good.... 😛

I think out of the 1 million users in this site, maybe a dozen of them might be "THE DBA". I am not. I have no clue about CLR's.

That pork chop look delicious.. 😛

I wont ask for a Shirt since I am not in US or UK and there are quite a few of the regulars here who...

Why not create it as a Scheduled Job?