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

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Databases Forum / Ahh, ok
Post #118,740
by drewk
Picture of drewk
9/24/03 5:56:04 PM
9/25/03 12:02:00 PM
Reply
New Ahh, ok
In the misty recesses of my memory I seem to recall seeing that if you deined the calculation twice in the same query it had to execute the query twice, and that aliasing it and referring to the alias was better. But now I'm thinking that involved HAVING clauses.

[Edit]: And BTW I was reading the code closely, the explanation not so much. So I missed that. Though since you didn't notice until you went back a third time, I'll say it wasn't that obvious anyway. :-P
===

Implicitly condoning stupidity since 2001.
Collapse Edited by drewk Sept. 25, 2003, 12:02:00 PM EDT
Ahh, ok
In the misty recesses of my memory I seem to recall seeing that if you deined the calculation twice in the same query it had to execute the query twice, and that aliasing it and referring to the alias was better. But now I'm thinking that involved HAVING clauses.
===

Implicitly condoning stupidity since 2001.
Collapse All History
     group-by on calculated columns not direct - (tablizer) - (17) - Sept. 24, 2003, 02:30:32 PM EDT
         The other way to do it... - (ChrisR) - (16) - Sept. 24, 2003, 02:37:56 PM EDT
             Another way to put it, is... - (CRConrad) - (4) - Sept. 24, 2003, 03:52:43 PM EDT
                 Don't think that was the problem - (drewk) - (2) - Sept. 24, 2003, 04:02:22 PM EDT
                     Same thing; a calculation IS a "virtual column". - (CRConrad) - (1) - Sept. 24, 2003, 05:58:54 PM EDT
                         Ahh, ok - (drewk) - Sept. 25, 2003, 12:02:00 PM EDT
                 I got wrong alias format - (ChrisR) - Sept. 24, 2003, 04:11:50 PM EDT
             Hmmmm. Thot I tried that - (tablizer) - (10) - Sept. 24, 2003, 06:21:24 PM EDT
                 The proviso being.... - (ChrisR) - (9) - Sept. 24, 2003, 09:26:56 PM EDT
                     That is less of a pain if you build the query dynamically - (ben_tilly) - (8) - Sept. 25, 2003, 12:12:59 AM EDT
                         Or, if you do it manually, good ol' copy-and-paste. -NT - (CRConrad) - Sept. 25, 2003, 04:55:01 AM EDT
                         That would presume Dynamic SQL - (ChrisR) - (6) - Sept. 25, 2003, 09:38:51 AM EDT
                             I think Ben meant, and Bryce would use, a programming... - (CRConrad) - (5) - Sept. 25, 2003, 10:00:12 AM EDT
                                 Right, that or... - (ben_tilly) - (4) - Sept. 25, 2003, 10:32:22 AM EDT
                                     Or, get rid of SQL - (tablizer) - (3) - Sept. 25, 2003, 11:51:28 AM EDT
                                         update - (tablizer) - (2) - Sept. 26, 2003, 01:48:39 PM EDT
                                             The other alternative is... - (ChrisR) - (1) - Sept. 26, 2003, 02:15:20 PM EDT
                                                 I asked for a view to be created, but was immed. rejected - (tablizer) - Sept. 26, 2003, 09:40:12 PM EDT

Debian is Sex.
47 ms