Forum Discussion
Bobaubry
Jun 07, 2024Copper Contributor
Access to Sql Server Migration
I am trying to come up with Access code that will allow a query to migrate to Sql Server. The current Access Sql is:
SELECT Last(tblSecurityPrices.Price) AS LastOfPrice, tblSecurityPrices.Security, Last(tblSecurityPrices.PriceDate) AS LastOfPriceDate
FROM tblSecurityPrices
GROUP BY tblSecurityPrices.Security;
I know very little about Sql Server. Bob
Bobaubry , in Transal-SQL we have the function LAST_VALUE (Transact-SQL) - SQL Server | Microsoft Learn
- olafhelperBronze Contributor
Bobaubry , in Transal-SQL we have the function LAST_VALUE (Transact-SQL) - SQL Server | Microsoft Learn