So we proceed to execute an alter view over the first view:
ALTERVIEWdbo.[vi_invoices_received_by]ASSELECT
ConfirmedReceivedByas[Receivedby],
COUNT(InvoiceID)as[#ofInvoices],
CustomerIDFROMSales.InvoicesGROUPBYConfirmedReceivedBy, CustomerID;GOSo we should now be able to see the updated column names on the second view, right?
but if you execute the view again, you will obtain the same results as before:
Read on to see what’s gone wrong and how you can fix it.