<div>
<div class="content wysiwyg-content">
in access i could use the following<br />
<br />
SELECT fi1_FinanceManagers.userid<wbr />, First(fi1_FinanceManagers.<wbr />LastName) AS FirstOfLastName, First(fi1_FinanceManagers.<wbr />FirstName)<wbr /> AS FirstOfFirstName, First(fi1_FinanceManagers.<wbr />Location) AS FirstOfLocation<br />
FROM FinanceManagers<br />
WHERE (((fi1_FinanceManagers.Act<wbr />ive)=1))<br />
GROUP BY fi1_FinanceManagers.userid<wbr /><br />
ORDER BY First(fi1_FinanceManagers.<wbr />LastName),<wbr /> First(fi1_FinanceManagers.<wbr />FirstName)<wbr />;<br />
<br />
how do i return 1 name for each id without using first()
</div>
</div>


in access i could use the following

SELECT fi1_FinanceManagers.userid, First(fi1_FinanceManagers.LastName) AS FirstOfLastName, First(fi1_FinanceManagers.FirstName) AS FirstOfFirstName, First(fi1_FinanceManagers.Location) AS FirstOfLocation
FROM FinanceManagers
WHERE (((fi1_FinanceManagers.Active)=1))
GROUP BY fi1_FinanceManagers.userid
ORDER BY First(fi1_FinanceManagers.LastName), First(fi1_FinanceManagers.FirstName);

how do i return 1 name for each id without using first()

first function for mssql

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.