>> Update by chunck... almost same thing I proposed, but you'd have to drop the actual table once the update is over... not a big problem. <<

Really the issue is...

Are you querying a REMOTE server? .. I mean @ServerName <> LOCAL

OR use NULLIF

SELECT  value1 AS 'VALUE1', 

 value2/NULLIF(value1,0) 'VALUE2', 

 value3 AS 'VALUE3',  

 value2/NULLIF(value3,0) 'VALUE4'

FROM dbo.tblvalues VL

WHERE VL.ID = @ID

Ok back from lunch.

1. >>I can't use a predefined stored proc because the program might be used on any table in any db on any server, with a variable set...

Tough question to answer without the necessary nitty gritty details but here is what I think.

Because Batch update is not being used I would assume that some parameterizing is happening under...

SAP = Systems Analysis and Program Development

If all the above is true then that name should be an OXYMORON

What I am trying to say is that the process can be more complex than doing just a union all. If it is just a matter of purely recording what...

Because of the architecture is unknown ... as of this momment

It was not defined (yet) how does multiple record changes is going to be...

OR if you want BOTH , which is usually the case  

then execute the insert twice (one for each table of course )

Are you trying to make people guess what you want?

Can you be a bit more explicit with examples and data?

select distrinct fld1, fld2

from tablex

-- or

select fld1,fld2

from tablex

group by fld1,...

Sorry about the bad news but it is not freeware anymore

Though not too expensive either ...

some how the OFFLINE status is definetly being kept in master I can't figure out a possible scenario but you should look at the steps you are taking very carefully....

Well I am not Joe Celko but I can tell you that a calculated column is not STORED in the table it is just a comodity for implementation!

Reality is...

Good can you tell them to change the ?????

Wow Thanks!

It is good to know that other people are having the same problem so you keep the sanity