IWETHEY v. 0.3.0
|
TODO
1,095 registered users | 0
active users
| 0 LpH |
Statistics
Login
|
Create New User
Welcome to IWETHEY!
IWETHEY Home
/
IWETHEY Board
/
Databases Forum
Now viewing page 18 of 25
[
Prev
]
1
...
14
15
16
...
25
[
Next
]
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
SQL/Server / SQLAGENT / Running by hand
- (
broomberg
)
- (12)
- May 13, 2003, 04:39:33 PM EDT
One possible hint
- (
kmself
)
- (8)
- May 13, 2003, 10:39:11 PM EDT
Don't see how it applies
- (
broomberg
)
- May 13, 2003, 11:27:42 PM EDT
Works
- (
broomberg
)
- (6)
- May 14, 2003, 10:09:07 AM EDT
OK, too
- (
kmself
)
- (5)
- May 14, 2003, 07:05:20 PM EDT
OT: how is DOMAIN\\USER kind of login supported in SAMBA
- (
Arkadiy
)
- (4)
- May 15, 2003, 05:30:34 PM EDT
RTFM
- (
deSitter
)
- (3)
- May 15, 2003, 10:16:03 PM EDT
Consider winbind.
-NT
- (
pwhysall
)
- May 16, 2003, 02:55:36 AM EDT
Client. Client. Client. Damn it.
-NT
- (
Arkadiy
)
- (1)
- May 16, 2003, 12:56:46 PM EDT
As Petah said...
- (
tseliot
)
- May 16, 2003, 01:04:58 PM EDT
sp_start_job may do the trick
- (
ChrisR
)
- (2)
- May 13, 2003, 11:14:52 PM EDT
Thanks
- (
broomberg
)
- (1)
- May 13, 2003, 11:30:19 PM EDT
Probably the best way...
- (
ChrisR
)
- May 14, 2003, 01:12:24 AM EDT
not to be a total whiner about mysql and firebird
- (
boxley
)
- (3)
- May 7, 2003, 11:03:19 PM EDT
MySQL
- (
JayMehaffey
)
- May 7, 2003, 11:59:03 PM EDT
For a Firebird Workbench...
- (
altmann
)
- (1)
- May 8, 2003, 03:55:11 AM EDT
Thanks I am downloading it
- (
orion
)
- May 9, 2003, 11:36:01 PM EDT
Is this schema screwed up, or is it just me?
- (
drewk
)
- (16)
- May 7, 2003, 09:50:41 AM EDT
Your new schema looks good.
- (
jbrabeck
)
- (2)
- May 7, 2003, 10:31:20 AM EDT
I guess what I'm looking for is ...
- (
drewk
)
- (1)
- May 7, 2003, 10:46:26 AM EDT
Guessing
- (
jbrabeck
)
- May 7, 2003, 10:57:34 AM EDT
Dependent Foreign Keys
- (
ChrisR
)
- (10)
- May 7, 2003, 10:58:46 AM EDT
Can't happen, each county is unique
- (
drewk
)
- (9)
- May 7, 2003, 11:05:16 AM EDT
Still a function of integrity
- (
ChrisR
)
- (8)
- May 7, 2003, 11:15:42 AM EDT
Don't even need a lookup table
- (
drewk
)
- (7)
- May 7, 2003, 11:18:53 AM EDT
Maybe it's just me
- (
tseliot
)
- (6)
- May 7, 2003, 11:46:48 AM EDT
Agreed.
- (
admin
)
- (5)
- May 7, 2003, 11:51:52 AM EDT
That's how I've already set it up
- (
drewk
)
- (4)
- May 7, 2003, 12:35:35 PM EDT
It's not a matter of speed.
- (
admin
)
- (3)
- May 7, 2003, 12:41:23 PM EDT
Generally I agree
- (
drewk
)
- (2)
- May 7, 2003, 12:43:59 PM EDT
Even so.
- (
admin
)
- May 7, 2003, 02:35:22 PM EDT
I agree with Malraux on this one
- (
tablizer
)
- May 22, 2003, 02:00:35 AM EDT
Thoughts...
- (
Simon_Jester
)
- (1)
- May 10, 2003, 11:56:00 AM EDT
You've about got it
- (
drewk
)
- May 12, 2003, 07:35:55 AM EDT
MySQL boasts it can compete with the big guys
- (
orion
)
- (3)
- April 11, 2003, 11:55:18 AM EDT
SSDD
- (
ChrisR
)
- (2)
- April 11, 2003, 12:06:42 PM EDT
Why that's a good idea
- (
drewk
)
- (1)
- April 11, 2003, 12:14:46 PM EDT
That's fine but that's not the current direction.
- (
ChrisR
)
- April 11, 2003, 12:30:26 PM EDT
'nother Access question.
- (
acagle
)
- (23)
- March 26, 2003, 12:36:51 PM EST
Tools->Relationships
- (
bepatient
)
- March 26, 2003, 12:52:54 PM EST
Try this
- (
jbrabeck
)
- (17)
- March 26, 2003, 02:03:59 PM EST
Perfect! Thanks!
-NT
- (
acagle
)
- March 26, 2003, 03:56:33 PM EST
Ooh...I like that...
- (
bepatient
)
- (15)
- March 26, 2003, 04:15:29 PM EST
Guess I aint as bad as I thought!
- (
jbrabeck
)
- (14)
- March 26, 2003, 04:42:38 PM EST
Been a while since I used Access, but.
- (
mmoffitt
)
- (10)
- March 26, 2003, 07:56:15 PM EST
Case statement
- (
orion
)
- (9)
- March 26, 2003, 08:32:46 PM EST
Not that one.
- (
mmoffitt
)
- (8)
- March 26, 2003, 08:35:00 PM EST
SQL construct
- (
ChrisR
)
- (7)
- March 26, 2003, 09:03:39 PM EST
Still there but only for two options
-NT
- (
tseliot
)
- March 26, 2003, 09:06:14 PM EST
Yeah, I was thinking Access had a TSQL-like Case statement.
- (
mmoffitt
)
- (5)
- March 26, 2003, 09:06:36 PM EST
IIRC the queries do support it.
- (
ChrisR
)
- March 26, 2003, 09:16:09 PM EST
Yes Access has a Case statement
- (
jbrabeck
)
- (3)
- March 26, 2003, 09:16:46 PM EST
Yeah, I remember IIF in Access.
- (
mmoffitt
)
- (2)
- March 26, 2003, 09:25:51 PM EST
DECODE would do it, if Access has it, that is.
- (
Meerkat
)
- (1)
- March 27, 2003, 03:00:36 AM EST
IIF, Case and Switch. No Decode
- (
jbrabeck
)
- March 27, 2003, 08:20:11 AM EST
Yes you are.
- (
tseliot
)
- (2)
- March 26, 2003, 09:08:02 PM EST
Agree, but...
- (
jbrabeck
)
- (1)
- March 26, 2003, 09:21:29 PM EST
Then you have one of four choices
- (
tseliot
)
- March 28, 2003, 04:34:34 PM EST
Okay, here's another one:
- (
acagle
)
- (1)
- March 27, 2003, 12:47:38 PM EST
="A" & Chr(13) & Chr(10) & "B"
- (
ChrisR
)
- March 27, 2003, 12:58:28 PM EST
Does the Tab key have any special meaning to it?
- (
acagle
)
- (1)
- March 28, 2003, 03:59:19 PM EST
Check the properties
- (
jbrabeck
)
- March 29, 2003, 08:10:39 AM EST
SAB-DB review
- (
broomberg
)
- (5)
- March 23, 2003, 11:36:15 PM EST
theres a reason they call it SAP
- (
boxley
)
- March 23, 2003, 11:50:06 PM EST
Filesystem?
- (
kmself
)
- (1)
- March 24, 2003, 03:34:33 PM EST
Nah, CPU
- (
broomberg
)
- March 24, 2003, 07:14:44 PM EST
What do you mean by "another Interbase"? Just wondering...
-NT
- (
CRConrad
)
- (1)
- March 24, 2003, 05:34:49 PM EST
"another Interbase"
- (
broomberg
)
- March 24, 2003, 07:12:12 PM EST
any SAP folks about?
- (
boxley
)
- (7)
- March 5, 2003, 10:50:06 PM EST
That would be Karsten.
-NT
- (
admin
)
- (3)
- March 5, 2003, 10:57:37 PM EST
Thought he was SAS.
-NT
- (
Yendor
)
- (2)
- March 5, 2003, 11:12:27 PM EST
Oh, jeez. You're right. Never mind.
-NT
- (
admin
)
- March 5, 2003, 11:18:58 PM EST
He might give you SAS but he's no SAP
-NT
- (
boxley
)
- March 5, 2003, 11:20:50 PM EST
not yet
- (
SpiceWare
)
- March 6, 2003, 03:00:27 PM EST
I'm a sap, does that count?
-NT
- (
mmoffitt
)
- March 7, 2003, 04:27:43 PM EST
That wouldn't be a bad idea.
- (
bepatient
)
- March 7, 2003, 04:35:31 PM EST
Access legacy database.
- (
acagle
)
- (21)
- Feb. 25, 2003, 01:21:21 PM EST
WAG
- (
drewk
)
- (15)
- Feb. 25, 2003, 01:24:31 PM EST
WAG ==
- (
folkert
)
- (11)
- Feb. 25, 2003, 01:35:51 PM EST
Wild Ass Guess
-NT
- (
drewk
)
- (6)
- Feb. 25, 2003, 01:38:35 PM EST
Ah, a SWAG!
-NT
- (
a6l6e6x
)
- Feb. 25, 2003, 01:49:21 PM EST
I know you are but what am I??? >:~P
-NT
- (
folkert
)
- (4)
- Feb. 25, 2003, 01:49:38 PM EST
LRPD sayeth: "Oh, Dad! We're ALL Devo!"
-NT
- (
drewk
)
- (3)
- Feb. 25, 2003, 01:59:36 PM EST
And again: "They are the Eggmen."
-NT
- (
drewk
)
- (2)
- Feb. 25, 2003, 02:00:26 PM EST
I'd like to thank the Academy...
-NT
- (
folkert
)
- (1)
- Feb. 25, 2003, 04:12:21 PM EST
Best thing since sliced SPAM!
-NT
- (
inthane-chan
)
- Feb. 25, 2003, 04:18:20 PM EST
== Worthy Attempts, Greg :)
-NT
- (
Meerkat
)
- (3)
- Feb. 26, 2003, 05:15:52 AM EST
== Wow, Absolutely GREAT!
-NT
- (
folkert
)
- (2)
- Feb. 26, 2003, 08:39:44 AM EST
== Whee, A Game!
-NT
- (
drewk
)
- (1)
- Feb. 26, 2003, 08:45:50 AM EST
== What A Goober!
-NT
- (
folkert
)
- Feb. 26, 2003, 08:53:00 AM EST
WAG
- (
acagle
)
- (2)
- Feb. 25, 2003, 01:36:18 PM EST
Try to import the data into a new DB?
-NT
- (
drewk
)
- (1)
- Feb. 25, 2003, 01:38:59 PM EST
(Bingo)
-NT
- (
acagle
)
- Feb. 25, 2003, 01:39:51 PM EST
Well, never mind.
- (
acagle
)
- Feb. 25, 2003, 01:39:23 PM EST
Real solution
- (
JayMehaffey
)
- (3)
- Feb. 25, 2003, 08:55:06 PM EST
Confirmed
- (
orion
)
- (2)
- Feb. 26, 2003, 08:28:50 PM EST
I tried that, but. . . .
- (
acagle
)
- (1)
- Feb. 27, 2003, 03:01:19 PM EST
Do you have the Admin password?
- (
orion
)
- Feb. 27, 2003, 11:47:38 PM EST
Anybody here using SQL Server?
- (
marlowe
)
- Feb. 20, 2003, 05:19:38 PM EST
Now viewing page 18 of 25
[
Prev
]
1
...
14
15
16
...
25
[
Next
]
i
we
they
.org
30%!! My God!! How did you survive the ordeal?!?
576 ms