« first day (303 days earlier)      last day (4558 days later) » 

matt wilkie
matt wilkie
5:31 AM
The faq says "Database Administrators - Stack Exchange is for database professionals who wish to improve their database skills and learn from others in the community. ". Where should one go to ask DB questions if they're not a professional, just a person trying to muck their way through some basic oracle sql? thanks.
 
gbn
gbn
@mattwilkie You can ask here. It will be moved to SO if judged. The line can be tricky sometimes
 
matt wilkie
matt wilkie
I'm trying to figure out how to IF..THEN, e.g. the equivalent of python if column1='1': print 'one'; elif column1='2': print 'two'
 
gbn
gbn
Just search for CASE and SQL
4
A: TSQL and case when with multiple whens?

gbnChange to a "searched" CASE expression. You have a "simple" CASE expression above CASE WHEN ProductLine IN ('R', 'M', ...) THEN 'Road' ELSE 'Not for sale' END From the MSDN link above: Simple CASE expression: CASE input_expression WHEN when_expression THEN result_expression [ .....

or
2
A: Where should I put the IF blocks in this SQL command

gbnNowhere. You use the CASE expression for "inline IF" SELECT Shift.ShiftID, Line.Line, ( SELECT SUM(DATEDIFF(MINUTE, CASE WHEN ManPowerUsage.FromDT >= Shift.FromDT THEN ManPowerUsage.FromDT ELSE Shift.FromDT ...

 
matt wilkie
matt wilkie
6:01 AM
thanks. finally figured out what was stumping us: the trailing END AS "thing" must be in double quotes. This one, dba.stackexchange.com/questions/665/…, gave an example that was close enough to ours to give the final clue.
I appreciate your time. I hope you always get the same when you need it :)
 
 
1 hour later…
Jack Douglas
Jack Douglas
7:13 AM
@mattwilkie "thing" only needs to be in double-quotes it it contains special chars (like a space)
which is best avoided if possible. if not then be aware that "thing" is case-sensitive whereas thing is not
 
 
9 hours later…
Nick
Nick
4:37 PM
We've all been wasting our money, gentlefolk.
 
DTest
DTest
not all of us..
 
gbn
gbn
I read that the first time around
And written by a developer.
I agree Postgres is enterprise class though
 
DTest
DTest
so if postgres is...what's th e reason to spend 'crazed-monkey-sex-monopoly' on the other two ?
for most applications, i mean...
 
gbn
gbn
And most apps can run on the free Oracle or SS Express
 
DTest
DTest
4:53 PM
true, though building an app on a DBMS that, if growth exceeds the free version means I'll have to spend booku-bucks...Gah, I'm jaded. I work at a small company that can't afford it :)
 
gbn
gbn
5:19 PM
Do I really have to do this to find out of my MySQL db is too big on disk?
 

« first day (303 days earlier)      last day (4558 days later) »