I would like to create a view in MS SQL Server to return the results of multiple select statements. When I tried to create the view only the first select statement was included. I am trying to make it so that the view can be returned in an Excel spreadsheet. I tried Union All and that did not work. Can anyone recommend a solution?