| |
| |
| |
|
Page: 1 2 3
Comments:
<0> hey moz
<1> hi Darken|
<0> hi
<2> How can I easily increase an integer value by UPDATE?
<1> update tablename set column = column + incrememnt
<2> thanks
<1> np
<3> woot 4 days 300 miles from work
<4> im pushing like 48 hours of working straight :P
<4> then my boss called and said he wanted me to do a report of all the problems ive had with the systems over the last 2 days. the problem is they are old and slow numnuts.
<5> or because you made them ****ty
<5> instead of focusing on design you were memorizing the bible ;)
<4> my job is to clean up other peoples messes. I make crappy things perfect
<3> lol
<3> 2 weeks of app rollouts and hardware failures, im ready for a break
<5> what about anal bleeding?
<3> ive had none of that
<6> how to compare 2 strings in sql?
<7> where 'string' = 'string' ?
<6> mmm
<6> is this valid? SELECT (SomeThing = '+'), Other FROM MyTable?
<7> no
<7> @ learnsql
<8> learnsql = http://sqlzoo.net/ http://sqlcourse.com http://sqlcourse2.com ,this is my way of telling you that you make no sense
<6> hehe
<7> select something, other from table where something = '+' is probably what you want
<6> nonon
<6> i want to get the result comparison of (SomeThing = '+')
<6> i would get something like: true, 4; false, 9; true, 10; etc...
<7> case
<7> sql doesnt really have boolean, although some database support it
<6> mine does i think :p
<7> or an inline if (iif)
<6> SELECT CASE WHEN (SomeThing = '+') THEN "True" ELSE "False" END, Other FROM MyTable?
<6> will that work?
<6> (it returns a string i know)
<6> and it is '' :p not ""
<6> but well
<5> pega
<5> select case something when '+' then plus when 'something' then something
<6> thanks
<9> hello there good evening
<10> I have a table (in DB2) listing time clock records for employees. Fields: Name, Time (as an int, eg. 20051231115959), and a PayType field that's either 1, 4, or 5
<10> I need a query to make a list of each employee (one row each) with the PayType from their most recent punch
<10> and I can't figure out how to do it with MAX()
<10> anyone have any ideas?
<10> I can think of an ***-complicated way with a subquery but I figure there must be a better way
<9> i say that you lay out all the possible scenarios and make queries and compare them :)
<10> I only have one possibility and I'm trying it now, not sure it will even work 8/
<10> can I use aggregate functions in a where clause?
<10> like WHERE time = max(time)?
<11> you use "having"
<10> oh neat, forgot about having
<11> wtf i am supposed to asleep
<11> s/asleep/be asleep
<11> hell you all. i am going to bed
<10> k hell you all, thanks
<10> err you too
<10> err k, anothe rquestion, can you mix having and where?
<10> or can you throw normal where stuff into a having?
<11> sure
<11> god dammit!
<10> http://sql-servers.com/nopaste/?show=138
<5> having lets you filter grouped stuff, where lets you filter each record
<10> it's complaining that an expression isn't valid in my SELECT
<5> no
<5> put the 2nd filter in the where
<10> k
<5> yo bob
<5> aren't you from casino?
<10> http://sql-servers.com/nopaste/?show=138
<10> yah
<10> err
<5> you pasted the same thing
<10> oops misspaste
<5> so did you get promoted and stuff?
<5> you need to group by titcod also
<10> nah
<10> stilldoing scheduling
<10> no paste is acting funky on me
<10> not giving me an url after I paste
<5> anywya
<10> http://sql-servers.com/nopaste/?show=139
<5> put the 2nd filter from having into where
<1> its called ur address bar moron
<1> lmao
<5> and you need to group by all fields unless you aggregate them
<1> ITS NOT HIDING FROM U
<10> it's called I KNOW it wasn't submitting properly
<5> arrakizzzz
<10> since I did it four times after #138 andi tjust now gave me 139 kthx
<1> quaiiiinnt
<5> dude
<1> hi my name is bob and i am learning how to clickie buttons
<5> you can't do that
<5> SELECT tiempn, MAX(tirtim) as pTime, titcod FROM clocfile00.cktimefl WHERE
<5> tisec3 = '0SOBM0' GROUP BY tiempn HAVING MAX(tirtim) = tirtim
<1> what?
<5> bob
<1> thats his name - try not to wear it out or make fun of it
<5> max(tirtim) = tirtim?
<1> lol
<10> yah, tirtim is time of punch
<5> dude
<10> trying to restrict it just the PayCode (titcod) from the very latest punch
<5> just think about it
<5> aimity
<5> select top 1 tirtim, titcod from table order by tirtim desc
<10> for all employees?
<5> no
<5> i thought you just need 1
<10> no, I need a list of every employee 8/
<10> and their code from the latest punch
<5> so just do
<5> select empid, max(time) from table group by empid
<5> what's the problem?
<10> k running
<10> slooooowly (big table)
<10> oh ****
<5> need index0rs
<5> is this ms access?
<10> because I just did it for the entire casino of 3,000 people
<10> no, db2
<10> instead of just my dept
<10> oops
<10> and yah, I don't think any of their **** is indexed
<10> since my newly restricted query is taking just as long
<10> awesome
<5> 3000 people should be less then a second :)
<10> 2.5 million records
<5> dude
<5> still man
<5> put some indexes
<10> hahaha
<5> although max() i dunno
<10> not my db
<5> see if there are indexes on the time field
<10> in fact I shouldn't be in it whatsoever
<10> the only access I have to their db is through OLE/ODBC
<10> I found a backdoor in our time editing software that gave me table/field names
<10> and just started playing from there
<5> oh
<5> you are haxing sorta?
<10> basically
<10> low rent hack
<5> how
<10> well I wont exactly be winning any awards, but
<10> we have kronos installed
<10> it's a front end for our green screen time sheet editor
<10> but I hate it so I just use green screen, and found that I could back out of one of the menus
Return to
#sql
or
Go to some related
logs:
source:current gov of nyc
#vmware
#winxp
#openbsd
#windows
#politics
clubseventeen pass
get heighest depth flash 8
is viotek psu any good?
#politics
|
|