Originally posted by oraclesmith
View Post
Sql server update statment syntax is a bit goofy: I think it should be like
update table t2 set nolines = t3.numlines from (select id, count(*) numlines from table t1 group by id) t3 where t2.id=t3.id
which might work...I haven't done T-SQL in a loooong time.
Leave a comment: