[dba-SQLServer] I found this

jwcolby jwcolby at colbyconsulting.com
Fri Sep 17 13:28:31 CDT 2010


UPDATE TABLEA SET
FIELD1 = (SELECT TABLEB.FIELD1 FROM TABLEB WHERE TABLEB.ID = TABLEA.ID),
FIELD2= (SELECT TABLEB.FIELD2 FROM TABLEB WHERE TABLEB.ID = TABLEA.ID)
	
It seems darned ugly but I can see the logic.  However I have about 16 fields to update for (in some 
cases) a subset of 2 million records in a 65 million record table.

It seems like this is going to be very inefficient.

-- 
John W. Colby
www.ColbyConsulting.com



More information about the dba-SQLServer mailing list