I'm not an Oracle guy either, but did you mean this?

update testtab

set obd = b.ob_oblig,

vrd = b.ob_vchrd

from (select sum(ob_oblig) as ob_oblig,

...

That's interesting. I was told my Microsoft that when installed on Windows 2000, you need to license virtual CPUs. When installed on Windows 2003, you need to license...

I think your error message got cut off from your post. Would you please repost your error?

Thanks.

Are SQL Server and SQL Agent currently starting as LocalSystem?

Are you making this change from the server itself or from your workstation? Since the error message is...

I haven't, but I have worked with SQL Anywhere. There's no reason why they shouldn't be able to coexist.

I wouldn't do it, just because I don't like to install...

How much free disk space do you have? You will need some free disk in order to shrink the database.

sp_rename

Would it be possible to change the clustering strategy on your view? If you can build a unqiue clustered index which respons better to your updates/inserts, you can create...

Would it be possible to change the clustering strategy on your view? If you can build a unqiue clustered index which respons better to your updates/inserts, you can create...

Another alternative would be to put all of the data in one varchar(8000) column, but add a second int column to distinguish the types of data. Thus, data of...

Another alternative would be to put all of the data in one varchar(8000) column, but add a second int column to distinguish the types of data. Thus, data of...

I'm sorry, but I can't see why mdaniel's query shouldn't work. I disagree with Calvin that it would require a unique key in this case, composite or otherwise.