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!

New Oops, didn't mean to filter on ordernum
But in any case, it turns out my query was correct, and it was just taking far too long. I worked around the issue by requiring that you select a start date for an on-screen report, and warning the user that doing a printable report without a start date could take an extremely long time.

Are TRANSFORM and PIVOT available in MySQL? I'm not familiar with them.
===

Implicitly condoning stupidity since 2001.
New Oops, no they're not.
Teach me to flail out the shortcuts. Wow, no transform, no subselects...tell me again why you're using MySQL? >:)

Many fears are born of stupidity and ignorance -
Which you should be feeding with rumour and generalisation.
BOfH, 2002 "Episode" 10
New It was there when I was hired
===

Implicitly condoning stupidity since 2001.
     How would you do this? - (drewk) - (11)
         Kludgy, but without subselects I end up using TRANSFORMs - (tseliot) - (3)
             Oops, didn't mean to filter on ordernum - (drewk) - (2)
                 Oops, no they're not. - (tseliot) - (1)
                     It was there when I was hired -NT - (drewk)
         counts? - (tablizer) - (6)
             Sybase, Oracle, Postgres, MSSQL all allow temp tables. - (admin) - (5)
                 I hear they are slower than equiv run-on SQL statements -NT - (tablizer) - (4)
                     Depends on the complexity of the operation... - (ChrisR) - (3)
                         Not the only reason... - (Simon_Jester) - (1)
                             Other considerations... - (ChrisR)
                         Not much larger - (tablizer)

Just a little peril?
106 ms