I found a workaround by redoing the join but I still don't understand what is causing the problem in the first update query I posted.

this works but I double the...

Happy to help... how do you include the adovbs.inc file exactly? I haven't worked for a while in asp but I could surely use that info eventually...

The problem comes from ASP :

every Constants must be converted to their respective value.

ex : cmdStoredProc2.CommandType = adcmdStoredProc

== : cmdStoredProc2.CommandType = 4

this should solve your problem. ...

This seems to be what you are looking for.

http://www.sqlservercentral.com/scripts/contributions/1212.asp

forget that post.. that one is for foreign keys 🙁

You can try this one for starters (may need to modify it a bit)

http://www.sqlservercentral.com/scripts/contributions/445.asp

can u send the code where the line accurs.. this doesn't help me much to pinpoint the problem.

I've heard of tree representation but never of diagrams.

But this can get you started :

exec sp_depends 'SP_name'

It's on the same line as I thaught. I would try my first solution and if it doesn't work then I would suggest you post the data definition of...

I don't think an if is the answer here (because he seems to want to join on a value from the main view.. so it doesn't seem to be a...

I don't think it's possible. I have come across some similar query with a udf that wasn't allowed by MS design (and for good reason).

I think you may...

I agree but I was referring to something I saw on this board... I would not use a UDF in this case either :-).

Thanx for the performance pointer frank. But can you explain to me why your version is faster than the one I posted?

Update YourTable set f1 = 'UserInput' ... where PkCol1 = ? and PkCol2 = ? and PkCol3 = ? and PkCol4 = ?

The only thing I can think of for...

Please don't use cursors when you can use a set based solution. This will run so much faster on the production system :

Update P set P.cStock = P.CStock -...