| |
| |
| |
|
Page: 1 2 3 4 5 6
Comments:
<0> notten: Yeah, that would work.
<1> Halo_Four: do you have any examples?
<2> haha ... it wasn't giving me 112006 cause of 1/1/2006 ... duh, too ****ing early in the morning
<2> dd was never being set ... so when I returned mm & dd & yy ... I was getting mm & "" & yy
<3> \heh
<4> ****it
<4> damn you flexible
<5> psix
<6> Hey all, I'
<6> er
<6> Hey all, I'm using MSSQL and trying to pull a list of products, but group them when 3 fields are the same
<6> And total these quantities
<6> So like, SELECT f1, f2, f3, sum(qty) from products group by f1, f2, f3
<6> or somesuch, but group by doesn't seem to be accomplishing what I'm looking for
<6> do i need to use distinct or some other method?
<2> ken-, try grouping properly ... ;)
<6> that might help, do you have any pointers? :P
<4> !seen _dren_
<4> seen _dren_
<7> _dren_ was last on IRC channel #sql 156 days, 14 hours, 28 minutes ago.
<8> yes, articulate what it IS you are trying to accomplish
<4> how many times i told that guy not to disappear :)
<4> seen loss
<7> loss was last on IRC channel #sql 299 days, 9 hours, 26 minutes ago.
<6> i have a large list of products, with 3 fields such as datecode, batchnumber, etc but lets just say f1, f2, f3, and I want to group the products that have identical f1, f2 and f3 fields, and sum their quantities
<6> only group if all 3 are equal
<0> 3 are equal to what?
<6> as in 2 products with identical f1, f2 and f3
<8> f1=f2=f3?
<0> If you're talking about having '1', '1', '1' and '1', '1', '1' group together, but '1', '1', '2' group separately, GROUP BY does that
<8> then the query you were using is right
<6> no i mean, that one line item has the same f1 as another, and also the same f2's and the same f3's
<8> yes
<0> oy vay
<6> well i'm using group by and outputting the results and they aren't combining
<0> Then the values aren't identical
<8> then the values aren't the same between f1, f2 and f3
<4> heh
<6> i think because when I try to use group by f1, f2, f3, its telling me taht all my fields i'm selectingh aren't in the group by
<6> i'm selecting like 10 fields but want to group just those 3 and its giving me an error
<0> You can't. You either group by it, or you aggregate it.
<4> do a max()
<6> max() on every field i'm not grouping?
<8> no
<8> don't listen to quant
<0> Use the appropriate aggregate.
<4> hehe
<6> can you give me an example? hehe
<4> what does the 3rd field represent?
<0> Holy****.
<6> PK
<4> wow
<6> its proprietary code
<0> Please, where a special hat so that I can weed you out better in interviews.
<8> ken, you'll need a subquery
<4> don't listen to df
<4> listen to your heart
<6> lol I do have job security believe it or not, as noobish as i may be
<6> i admit i'm not experienced at least :)
<8> you must give a helluva blowjob
<4> that's not being modest
<6> i'm searching BOL and not finding any examples that are really helping, can anyone point me in the right direction?
<3> lol
<4> it's either ban or help
<0> Well, the rule is, when using GROUP BY, you either group or aggregate.
<8> woohoo, pouring like a mother ****er here
<9> Color me jealous. We haven't seen rain in a month.
<2> I haven't seen rain in 6 years
<10> ?
<6> ok i think i'm starting to get it now
<8> lots of lightning, real wrath of god type stuff
<2> dfworking hah
<8> i think its just to punish the jews
<8> cause they need it
<2> hey now ...
<2> the christians and the muslims need it just as badly
<11> rain?
<2> but the jews do need it more ...
<2> hallowd the wrath of god ...
<8> i meant the jews need punishment
<8> cause, well, they're jews and all
<2> dfworking don't you think the 'need' to pick up a penny and save a penny is enough punishment? heh ... you think they do it cause they have too? lol ... that was gods funny way of saying "muahahaha"
<4> moz is gay
<8> and jewish
<4> he'd kill for a penny
<8> but only if he can bend over to pick it up
<3> heh
<4> need to send lightning
<4> although, feening for cock is a punishement on it's own
<3> feening?
<8> wtf is feening
<3> i have no idea wth feening is
<4> fiend is feening
<3> i thought fiend was a noun
<3> wasnt aware it could also be a verb
<3> rofl
<4> lol
<4> feening is a verb
<8> Quant, you type like you have a cock in your mouth
<3> http://www.urbandictionary.com/define.php?term=feening&r=f
<8> articulation is poor
<4> arrakis: see
<8> jesus
<3> LEARN SOMETHING NEW EVERY DAY
<8> so we can just make **** up and as long as its published on a website, then its valid
<4> everyone knows this word
<4> noobs
<8> apparently not
<4> now you know
<4> now everyone knows
<8> i was at the proctologist today. had a large quant removed. i do feel better now though.
<12> lol
<4> rofl
<4> dude
<4> did you know the word "feening"?
<8> of course not, its slang, not a word
<8> and new slang
<8> i'm old and never leave the house
<4> it's nto new
<3> its pretty new
<3> in terms of slang
<6> i always used fiending not feening
<3> and its also not widely used
<3> :P
<3> the fact that urban has only 3 entries and no sounds
<4> texas is too far :)
<3> and they all look like druggies
<3> that made the comment
<8> ok, lets just establish that it is a commonly used term amongst the white street trash, ok?
<3> id say hippie who went through the 60's
<3> but just recently finished college and found teh intarweb
<4> listen to any of the biggie songs
<3> wtf is a "biggie" song?
<3> i listen to
<4> "she be feening for that semen.." type of stuff
<3> alternative rock
<3> ewww
<4> rofl
<3> i dont listen to that type of crap
<4> alternative
<3> most of my stuff is like
<3> "almost" playable at any occ***ion
<4> "check my vital signz, everythingz alright"
<3> i'd be emberrased if somebody walked in or by my office and sopmebody was singing
<3> "SHE BE FEENING FOR THAT SEMEN
<4> rofl
<4> Notorious B.I.G.?
<13> fiending is the right word
<3> lets see whats on my playlist
Return to
#sql
or
Go to some related
logs:
#debian
#nhl
#gentoo
#stocks
#online
#politics
Application.HintColor delphi
c sharp dword word
#firebird
flash no-antialias
|
|