I am using Microsoft SQL Server 2005. I get the following error without the ORDER:
Incorrect syntax near the keyword 'GROUP'.
Juason
Last Activity: Jun 26 '06, 02:56 PM
Joined: May 10 '06
Location:
-
That gives me the following error :
The ORDER BY clause is invalid in views, inline functions, derived tables, and subqueries, unless TOP is also specified.
The ActionLog table contains every single thing that happens in our process. What I'd like to do, is select a single LinkId, and find all the SNs associated with it in their most current states. Most current meaning, newest date-wise. Unfortunately my...Leave a comment:
-
I put the '-' there manually when I copied it into this post, just to illustrate which ones I didn't want returned :P...Leave a comment:
-
Help needed on confusing Select Query please.
Greetings,
I am currently trying to organize some data in a way that is straightforward to parse in my web application. Here is the query:
select SN, Date, ActionDefID, Actiondef.SeqNu m, Actiondef.SubSe qNum
from dbo.ActionLog
join dbo.ActionDef on dbo.ActionLog.A ctionDefID = ActionDef.ID_Ac tionDef
join dbo.serials on dbo.ActionLog.S _Number = dbo.serials.ID_ Serials
WHERE LinkID = 1002...
No activity results to display
Leave a comment: