hi

thank you very much, it worked just fine

carlos a. cachulo

Matt Miller (3/11/2008)

---

Forget loops. You're in SQL server now, not in procedural code.

update CL

set u_resp=EVALOR

from cl

inner join ...

could help!!

SELECT re.no as NO, sum(re.etotal)as EVALOR from re (nolock) where chdata > getdate() group by re.no

* RETURNS THIS*

NO ...

i started with this

update cl

set u_resp= (SELECT re.no as NO, sum(re.etotal)as EVALOR from re (nolock) where chdata > getdate() group by re.no)

from cl (nolock),re (nolock)

where cl.no = re.no

i.m a newbie at this,

so lets start from the begining, i´ve this two tables CL and RE

In the CL table í´ve this field CL.U_RESP witch needs to by update...

sorry, wrong paste

Msg 102, Level 15, State 1, Line 7

Incorrect syntax near 'EVALOR'.

hello

it retuns " Invalid column name 'evalor'."