You'll need something like this

first create a new field that flags the updated rows

then updated the rows that are not flaged as updated.

I keep the rowcount in @MyRowCount because when...

Thanx for the clarification.

One less gotcha to learn :-).

That's what I'm doing in my 2nd message. But I'm still wondering why the first form isn't working. Is it because the grouping messes with the primary key...

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 :-).