So we proceed to execute an alter view over the first view:
ALTER
VIEW
dbo.[vi_invoices_received_by]
AS
SELECT
ConfirmedReceivedByas
[Received
by
],
COUNT
(InvoiceID)
as
[#
of
Invoices],
CustomerIDFROM
Sales.Invoices
GROUP
BY
ConfirmedReceivedBy, CustomerID;
GO
So 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.