I am working on migrating customer's MS access database to
SQL Server, but I don't know much about those two.
I have many problems to migrate access queries to SQL Server.
There's a question about "Select first" sentence like below.
SELECT ITEM_NAME, CUSTOMER, First(MATERIAL_CO) AS MATERIAL_CO
GROUP BY ITEM_NAME, CUSTOMER
This sentence has no "order by" clause and MATERIAL_CO is not
with an index. What kind of MATERIAL_CO data is fetched when
this sentence is done?
I don't understand much of "first" function of access, but in this
case it seems to be no need of "first" function for me.