IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Databases Forum / Yep, took forever to run.
Post #258,171
by ChrisR
6/8/06 2:00:51 PM
Reply
New Yep, took forever to run.
But I did end up figuring out a SS solution using the min function (in non-SQL-standard sort of fashion).

SELECT *\nFROM\n   drug d\n   LEFT OUTER JOIN formulary f ON (f.drugid = d.drugid)\nWHERE\n   ((f.formularyid IS NULL) OR\n    (f.formularyid = (\n       SELECT MIN(forumularyid)\n       FROM formulary x\n       WHERE (x.drugid = d.drugid))))
Post #258,187
by drewk
Picture of drewk
6/8/06 2:40:14 PM
Reply
New Nothing non-standard about that
In fact, that's the solution I'd like to think I'd have come up with if I'd worked on it long enough.
===

Purveyor of Doc Hope's [link|http://DocHope.com|fresh-baked dog biscuits and pet treats].
[link|http://DocHope.com|http://DocHope.com]
     Left Outer Join question - (ChrisR) - (20) - June 7, 2006, 10:26:29 PM EDT
         One approach - (ben_tilly) - (6) - June 8, 2006, 01:13:51 PM EDT
             Some variation on MIN... - (ChrisR) - (3) - June 8, 2006, 11:10:15 AM EDT
                 It probably will not optimize - (ben_tilly) - (2) - June 8, 2006, 01:27:27 PM EDT
                     Yep, took forever to run. - (ChrisR) - (1) - June 8, 2006, 02:00:51 PM EDT
                         Nothing non-standard about that - (drewk) - June 8, 2006, 02:40:14 PM EDT
             Pre indentation - (ChrisR) - (1) - June 8, 2006, 02:02:57 PM EDT
                 Bug, indentation can be lost during edits (new thread) - (ben_tilly) - June 8, 2006, 02:18:49 PM EDT
         Does SQL Server support "DISTINCT ON"? - (drewk) - (12) - June 8, 2006, 08:55:49 AM EDT
             That is really what I need! - (ChrisR) - June 8, 2006, 10:56:50 AM EDT
             The more readable version is invalid (at least in Oracle) - (ben_tilly) - (10) - June 8, 2006, 01:12:25 PM EDT
                 Hmm, both Postgres and MySQL support the same non-standard? - (drewk) - (9) - June 8, 2006, 01:49:01 PM EDT
                     Can you please help me find mine? - (folkert) - June 8, 2006, 02:04:49 PM EDT
                     That is a MySQL shortcut - (ben_tilly) - (7) - June 8, 2006, 02:14:38 PM EDT
                         Not surprising - (drewk) - (2) - June 8, 2006, 02:42:46 PM EDT
                             Or you didn't double-check enough - (ben_tilly) - (1) - June 8, 2006, 02:50:14 PM EDT
                                 Also possible - (drewk) - June 8, 2006, 04:17:32 PM EDT
                         I've encountered that problem. - (static) - (3) - June 8, 2006, 08:48:27 PM EDT
                             Justifiable arrogance in many cases - (ben_tilly) - (2) - June 8, 2006, 09:18:47 PM EDT
                                 Oh I have little doubt about that. - (static) - (1) - June 8, 2006, 09:35:59 PM EDT
                                     Oracle is picky but... - (ben_tilly) - June 8, 2006, 10:03:53 PM EDT

True, there's a part of the horse's anatomy involved, but it's not the mouth...
69 ms