Create Complex view in SQL Server

Published --