How would I find this?
- I found this scenerio that I found intriguing. . .EVENTEventIDETypeETime
n
Write a query which returns:
Sequence#, EventID, EType, ETime (Sequence# is 1 for the 1st event, 2 for the 2nd, etc.)
You can assume that no two events happen at exactly the same time.
-
Cant be possible in a single query in SQL 2000, you have to use loop or a temp table.
Kindest Regards,Amit Lohia
-
Take a look at these and choose the method that suits your purpose.
http://support.microsoft.com/default.aspx/kb/186133
http://databasejournal.com/features/mssql/article.php/10894_2244821_1
http://www.sqlteam.com/item.asp?ItemID=1491
http://vyaskn.tripod.com/programming_faq.htm#q17
http://www.aspfaq.com/show.asp?id=2427
--------------------
Colt 45 - the original point and click interface
-
nice
Kindest Regards,Amit Lohia
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply