@SQLFRNDZ (5/28/2015)
Thank you ! That's what I thought too and could not find a way to do in SQL server. We end up with a trigger to do the insert to the newtable
They're called "indexed views" in "Books Online".
--Jeff Moden
Change is inevitable... Change for the better is not.