![]() |
|
Porsche, and the Porsche crest are registered trademarks of Dr. Ing. h.c. F. Porsche AG.
This site is not affiliated with Porsche in any way. Its only purpose is to provide an online forum for car enthusiasts. All other trademarks are property of their respective owners. |
|
![]() |
SirAndy |
![]() ![]()
Post
#1
|
Resident German ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Group: Admin Posts: 42,234 Joined: 21-January 03 From: Oakland, Kalifornia Member No.: 179 Region Association: Northern California ![]() |
it's time for another SQL question ...
here's the problem: i have a table with event log information. it has a unique id for each entry (primary key), a user id, timestamp and other info. getting the info out of the table is easy except for one particular way. what i need is a page where i list all the last actions taken by any user per day. meaning, if users xyz created 30 logentries today, i only want to show the latest for any given day. so, the list should contain exactly ONE entry for each distinct user per day, showing his/her latest action ... something like this, except, the query below doesn't work ... (IMG:style_emoticons/default/rolleyes.gif) CODE SELECT * FROM tbl_EventLog WHERE iID IN ( SELECT DISTINCT el.iUserID, dummy.iID FROM tbl_EventLog as el INNER JOIN tbl_EventLog as dummy ON dummy.iUserID = el.iUserID WHERE (el.dtCreated >= '3/26/2007 0:00:01 AM') ) anyone? (IMG:style_emoticons/default/confused24.gif) Andy |
![]() ![]() |
drewvw |
![]()
Post
#2
|
new england car guy ![]() ![]() ![]() Group: Members Posts: 1,631 Joined: 24-February 06 From: Boston, MA Member No.: 5,630 Region Association: North East States ![]() |
Not sure what DB you are using, but any thoughts on dropping that into a stored proc?
that way you can abstract the looping to the DB layer and return a single result set. Performance would probably be better as well. |
SirAndy |
![]()
Post
#3
|
Resident German ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Group: Admin Posts: 42,234 Joined: 21-January 03 From: Oakland, Kalifornia Member No.: 179 Region Association: Northern California ![]() |
Not sure what DB you are using, but any thoughts on dropping that into a stored proc? that way you can abstract the looping to the DB layer and return a single result set. Performance would probably be better as well. yeah, i could. MS-SQL 8 Server. problem is, the server app is HUGE and was entirely done in ASP without a single stored procedure. it's all inline ASP queries. if i start using stored procedures now, i'm afraid i'll confuse all the other programmers even more than they already are. we're talking hundreds of thousands of lines of code ... (IMG:style_emoticons/default/rolleyes.gif) Andy |
drewvw |
![]()
Post
#4
|
new england car guy ![]() ![]() ![]() Group: Members Posts: 1,631 Joined: 24-February 06 From: Boston, MA Member No.: 5,630 Region Association: North East States ![]() |
yeah, i could. MS-SQL 8 Server. problem is, the server app is HUGE and was entirely done in ASP without a single stored procedure. it's all inline ASP queries. if i start using stored procedures now, i'm afraid i'll confuse all the other programmers even more than they already are. we're talking hundreds of thousands of lines of code ... (IMG:style_emoticons/default/rolleyes.gif) Andy That's a really good point. A lot of the legacy ASP code where I work is a mix of overly complex stored procs and inline queries. Its a mess for others to figure out (READ: me the last 2 months). Do we have any true DBAs in the club or just programmers who dabble in DB? |
![]() ![]() |
![]() |
Lo-Fi Version | Time is now: 3rd July 2025 - 05:46 AM |
All rights reserved 914World.com © since 2002 |
914World.com is the fastest growing online 914 community! We have it all, classifieds, events, forums, vendors, parts, autocross, racing, technical articles, events calendar, newsletter, restoration, gallery, archives, history and more for your Porsche 914 ... |