SQL query errors

[btaber]

I am converting my program from a ms access backend to a ms sql server backedn (msde) and a buch of queries are not working. This is the query:

SELECT FIRST(DelLoc.Loc) AS Loc, FIRST(DelLoc.Des) AS Des, Count(*) AS TotItems FROM (AddItems INNER JOIN SM ON AddItems.Man = SM.ID) INNER JOIN DelLoc ON AddItems.AddItemsDel = DelLoc.Loc WHERE AddItems.Printed=0 AND (SM.DateIn >= '05/28/2004' AND SM.DateIn <= '05/28/2004') GROUP BY DelLoc.Loc

I get:
[Microsoft][ODBC SQL Server Driver][SQL Server]'FIRST' is not a recognized function name.

If there a equilivent function? I can't use min or max because it does not give me what I need.

B

 

[tb]

Not familiar with access syntax or functions ...
what if you add an ORDER BY ??

I had a look at these..
(

http://www.w3schools.com/sql/sql_functions.asp)

(

http://www.w3schools.com/sql/func_first.asp)

I was standing in the park, wondering why frisbees got bigger as they came closer... then it hit me!

 

[btaber]

Thanks for the reply, but I ended up doing it with 2 queries. Thanks though

 

[zemp]

Look into the TOP keyword for SQL Server SQL syntax. It might give you what you need.

SELECT TOP 1 <field>....

zemp