| |
| |
| |
|
Page: 1 2 3 4
Comments:
<0> i remember the days when you weren't here
<1> then they wised up to #oracle's mentality.
<0> good times
<0> maybe we should go back to those times, eh?
<0> keep quiet
<1> yeah but no one ever got help, and the iq average was 50 points lower
<1> but feel free to help Odyss3us with his RDF issue
<1> since you are ohhh so helpful
<2> Jarett__ is a hippy
<2> :p
<3> well **** Jarett__ then
<3> are you that ultra militant christian bible freak Jarett__?
<3> i keep forgetting who that one is..
<1> im not militant
<3> ah okay, it is you
<1> Since i know the hippies will end up killing themselves
<4> any informatica developers on?>
<1> Darken is one.. he is Mr Wizard ;)
<1> hows the baby ShrikeX ?
<4> hahah doing good Jarett__
<4> its fun being a dad
<1> how old?
<4> 2 weeks today
<1> Cool
<4> my wife is a trooper
<1> time for the first photo session
<4> she lets me sleep at night
<4> haha no ****
<4> we took a pic with my 3 mp camera
<4> and printed a glossy 8x10
<4> and it looks like ****
<4> :(
<4> but its what we got
<1> lol
<4> Im gonna give it to my mom for her bday tomorrow
<4> gonna get a frame and mat it
<1> want me to get names of good infant photogs in your area?
<4> yeah thatd be cool
<4> west chester ohio 45069
<1> how far from dayton?
<4> bout an hour
<4> much closer to cincy
<1> geez almost no one fromt hat area in any of my photog groups
<1> dayton www.positiveimagesonline.com cleveland workofheartphoto.com
<1> those are the 2 i would use if i didnt shoot my own
<4> coo
<4> thanks
<4> hey you ever hear back about cognos?
<1> no
<1> p***ed on the contact info and all that to our VP dev
<4> ah
<1> but i think we have too much time vested in BO
<1> bad move
<4> Im gonna be hiring an awesome datawarehouse architect
<4> Im so excited
<1> our vp wants to hire one, but he keeps saying "dba/db architect"
<4> I hate that
<1> im like dude, we need an architect with a clue about development, not dba
<1> theres a differene
<4> makes it sound like you need a guy who can install sound cards in linux
<4> and swap partitions
<1> he is an MS guy int he past so he has no clue
<1> no one with sql server as their background seems to
<4> instead of designing dimensional buses and interviewing the biz
<1> yep
<4> Im going to the kimball cl*** in long beach in april
<4> its gonna be fun
<4> sending one of my guys to his etl cl***
<3> esl?
<3> oh
<4> not english second language
<3> :P
<4> extract transform and load
<1> im headed to sans 2006 in 2 weeks
<4> sweet
<1> 10 days of hacker 3l33tness
<4> I was supposed to goto del mar this week
<4> but the biz dropped thre ball
<5> hi
<5> i have UPDATE Inventory SET OnHand=I.OnHand - P.Quantity FROM POSItems P, Inventory I WHERE P.UPC=I.UPC the problem is, if there are same upc twice in positems table, only one is deducted from inventory table. how do i fix that? using sql express 2005
<6> kew, group by ... and sum
<5> zoul: thanks
<5> i am getting syntax error UPDATE Inventory SET OnHand=I.OnHand - SUM(P.Quantity) FROM POSItems P, Inventory I WHERE P.UPC=I.UPC GROUP BY P.UPC
<6> what dbms?
<5> sql server express
<6> *shrug*
<5> error is: Incorrect syntax near the keyword 'GROUP'
<6> update inventory set onhand = i.onhand - sum(p.quantity) from positems p inner join inventory i on p.upc = i.upc group by p.upc, p.onhand
<5> same error, i get Incorrect syntax near the keyword 'GROUP'
<6> read the docs for update ... see what the syntax is ...
<5> i am, thanks
<7> In a DB2 stored proc how can I p*** in a VARCHAR parameter? when I do CREATE PROCEDURE myproc(in_itemlist AS VARCHAR(100)) it doesn't compile and I get a message that there is an error in parameter 11. There is only one parameter so I'm not sure what it's talking about.
<6> cubert ... error level/number 11 ... in parameter? ... just a bad way of saying it? :)
<7> duh... I don't need AS in there :P
<8> anyone know of an easy way to increment a number via a update ?
<4> what database?
<8> it's mysql
<9> SET anumber = anumber + 1
<8> oh simple enough
<8> errored the first time i tried
<8> thanks :)
<9> npx
<5> update positems set quantity = sum(quantity) group by upc i am getting error: Incorrect syntax near the keyword 'group'
<10> yes, i wonder why
<11> heh
<11> that query doesnt make much sense
<5> ok, positems table contains 3 rows. two with same upc. each row has a quantity. i am trying to sum quantitys with same upc
<9> heh
<11> kew can you use the paste site to show a before/after snapshot of the table you want to do with this query?
<5> tenfour: ok
<11> i still don't get what you want to do
<11> my brain is throwing the same error your sql interpreter is
<11> hehe
<7> columns in the GROUP BY must also be in the SELECT portion
<7> nm, that doesn't really apply
<7> I've never seen group by used with an UPDATE
<5> ok forget that, please explain this to me. UPDATE Inventory SET OnHand=OnHand-SUM(P.Quantity) FROM Inventory I INNER JOIN POSItems P ON I.UPC=P.UPC GROUP BY P.UPC i get error Incorrect syntax near the keyword 'GROUP'.
<5> tenfour: you arent at winprog anymore?
<11> nah
<5> this is driving me crazy..
<12> Using acces: SELECT * FROM tblForum WHERE ID=" & id & " AND SvarID=" & id & " ORDER BY Dato DESC why wont that return any data? when I know the criteria is good
<7> are ID or SvarID text?
<12> no
<12> both number
<11> Kulvis did you try performing the query manually?
<11> see what the actual query is being generated
<11> otherwise it doesnt help this chan much
<12> yeah, I did
<12> nothing
<11> so what is the actual query
<12> but when removing SvarID, it returns some data, but not all
<12> SELECT * FROM tblForum WHERE ID=4 AND SvarID=4 ORDER BY Dato DESC
<11> i dunno... look at the table of data and see for yourself
<11> just remember the db engine doesnt make mistakes
<12> I have. Cant figure it out ;)
<11> are you really new to sql maybe? in other words, is there a chance you don't understand how WHERE works?
<13> whats the quickest way to move stored procedures from one db to another?
<13> sql server 2005
<14> script them
<7> Is anyone here familiar with using the ILE C debugger for debugging stored procedures on an AS/400?
<7> the documentation doesn't match the screens I'm seeing
<6> look for the docs for the version your using, heh ...
<6> ibm changes **** with each version ...
<7> the ILE C compiler docs don't say anything about debugging stored procedures with it
<6> :)
<7> but according to this other doc it's what I'm supposed to use
<7> I just can't make it make sense :P
<10> tried google groups ?
Return to
#sql
or
Go to some related
logs:
#linux-noob
#computers
jennifer lopezes ass
mirc proxies
#freebsd
#beginner
#opengl
whtismyip
dante client offered no acceptable authenticationmethod
and she called me an ugly american
|
|