Oops, no they're not.

1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #102,103 by tseliot 5/15/03 1:09:48 PM Reply	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
Post #102,127 by drewk 5/15/03 2:55:58 PM Reply	It was there when I was hired === Implicitly condoning stupidity since 2001.

How would you do this? - (drewk) - (11) - May 13, 2003, 09:54:30 PM EDT

Kludgy, but without subselects I end up using TRANSFORMs - (tseliot) - (3) - May 13, 2003, 09:01:45 PM EDT

Oops, didn't mean to filter on ordernum - (drewk) - (2) - May 13, 2003, 09:53:00 PM EDT

Oops, no they're not. - (tseliot) - (1) - May 15, 2003, 01:09:48 PM EDT

It was there when I was hired -NT - (drewk) - May 15, 2003, 02:55:58 PM EDT

counts? - (tablizer) - (6) - May 18, 2003, 01:56:15 AM EDT

Sybase, Oracle, Postgres, MSSQL all allow temp tables. - (admin) - (5) - May 18, 2003, 08:48:25 AM EDT

I hear they are slower than equiv run-on SQL statements -NT - (tablizer) - (4) - May 20, 2003, 09:45:56 PM EDT

Depends on the complexity of the operation... - (ChrisR) - (3) - May 21, 2003, 01:23:22 AM EDT

Not the only reason... - (Simon_Jester) - (1) - May 21, 2003, 11:29:25 AM EDT

Other considerations... - (ChrisR) - May 21, 2003, 01:07:06 PM EDT

Not much larger - (tablizer) - May 22, 2003, 01:54:37 AM EDT

No LRPD for you, one year!
145 ms