Hello MS Access Expert,
I am learning how to migrate MS Access objects using SSMA into SQL Server 2019.
I was not able to Migrate the following query using the SSMA wizard and I am curious why.
I am able to create the same View manually in SQL Server using the below code.
Thank you
I am learning how to migrate MS Access objects using SSMA into SQL Server 2019.
I was not able to Migrate the following query using the SSMA wizard and I am curious why.
Code:
SELECT Invoice.InvoiceNo, [Quantity]*[UP] AS Total, Month([Invoice].Date) AS [Month], Invoice.Date
FROM Invoice INNER JOIN InvoiceSub ON Invoice.InvoiceNo = InvoiceSub.InvoiceNo
WHERE (((Invoice.Date)>#12/31/2021# And (Invoice.Date)<=Now()));
I am able to create the same View manually in SQL Server using the below code.
Code:
SELECT Invoice.InvoiceNo
,[Quantity]*[UP] AS Total
,Month([Invoice].[Date]) AS [Month]
,Invoice.[Date]
FROM Invoice
INNER JOIN InvoiceSub ON Invoice.InvoiceNo = InvoiceSub.InvoiceNo
WHERE (((Invoice.[Date])>'12/31/2021'
AND (Invoice.[Date])<=GETDATE()))
Thank you