Help converting query from access to sql 2000

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Help converting query from access to sql 2000

Author

Topic

smorty44
Yak Posting Veteran

93 Posts

Posted - 2007-08-10 : 09:34:58

This query from access does not work in sql server 2000. How do I write this in sql to run?

SELECT First(tri_ProcMast.ddesc) AS FirstOfddesc, tri_ProcMast.proccd
FROM tri_ProcMast
GROUP BY tri_ProcMast.proccd;

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-08-10 : 09:44:14

[code]
SELECT ~~First~~ min(tri_ProcMast.ddesc) AS FirstOfddesc, tri_ProcMast.proccd
FROM tri_ProcMast
GROUP BY tri_ProcMast.proccd;
[/code]

KH
[spoiler]Time is always against us[/spoiler]

smorty44
Yak Posting Veteran

93 Posts

Posted - 2007-08-10 : 09:48:31

That worked Perfectly! Thank you so much for your quick response!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources