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