| |
| |
| |
|
Page: 1 2 3
Comments:
<0> i use mssql, how is it possible that i get in SiteID few times the same number ?
<1> HMS-w : you need to ask a more coherent question than that...
<1> oh, and next time you paste something, please use table aliases
<0> ok
<0> amm the Group by dosent work =\
<0> i have no idea y
<1> "doesn't work" is not sufficient information
<0> i used group by and i get the some vals more then one time
<1> using the paste site, paste an example of the rows you get which you consider 'bad'
<1> in fact, no need... this is a case of user stupidity/error (pick one)
<1> you are grouping by three values, but only displaying one of them
<1> therefore i would 'expect' there to be duplicates of that 'one' value
<0> amm but i cant remove them =\
<0> the qeury wont work
<1> either add rank and wordid to the select side, or remove them from the group by
<1> next time you say "won't work", you get a kb...
<0> wordID was in the select i removed it coz i dont need it there.. but if i remove it from the group by i get the following error
<1> HMS-w : well?
<1> HMS-w : ok, i'm bored with you now...
<0> Column name 'new..._Ranks.Rank' is invalid in the order by clause because it is not contained in the either an aggregate function
<0> or the group by caluse
<0> clause
<1> ok... and your point is what?
<1> that doesn't invalidate my comments above
<1> [15:03:53] <1> in fact, no need... this is a case of user stupidity/error (pick one)
<1> [15:04:07] <1> you are grouping by three values, but only displaying one of them
<1> [15:04:27] <1> therefore i would 'expect' there to be duplicates of that 'one' value
<0> ok then besides of adding them to the output what can i do ?
<1> that is the cause of your 'problem' - how you solve it depends on what you ACTUALLY want/need to do with the data...
<0> ok
<1> if you remove wordid and rank from the group by, and remove the order by, you'll get unique valies of siteid
<1> values
<1> oh, and change the 'having' to 'where'
<0> but if i want to keep the order by ?
<1> why?
<0> coz i need the results ordered by the ranking
<1> why?
<2> cuz cuz cuz cuz
<2> cuz i can like type liek cuz
<2> i guess ishould remmeber to bring my water bottles with me this time :-/
<0> i have a list of sites and their ranks and i want to show all the sites ordered by thier ranks
<1> that's not what your join implies about your schema
<1> nor your naming conventions
<2> omg r u implying that im implying something with my shcma?
<2> ok random commentaries are over . i go bibi now
<0> well thats only a small part of it
<1> the ranks appear to apply to files within a site, not to the site as a whole
<0> i have 3 tables
<0> 1 of wordID, words
<1> then paste the schema for the tables, plus some sample data to the paste site
<0> ok
<0> sec
<3> What am i doing wrong? http://sql-servers.com/nopaste/?show=114
<0> http://sql-servers.com/nopaste/?show=116
<0> aryx: whats the error?
<4> aryx : you`re pasting no-sql code to the sql paste site
<4> aryx : that`s what you`re doing wrong
<0> hehe
<0> YuppieScm
<0> can u help me pls :)
<5> ...
<6> ....
<5> .....
<4> awww.... sweet
<4> oh, moz? it's " 'nads" - short for "gonads"
<5> YuppieScm: yeah?
<5> whats with everyone recently wanting to correct my spelling all the time now ? :)
<4> because your spelling has become worse than ever
<5> no worse then before
<7> I dont think its any worse
<7> and whats wrong with him saying nads?
<4> 'nads
<5> nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads n
<5> ads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads nads
<4> apparently nothing...
<8> I have a program that generates raw text files every so often; is there a way to script something to add that to an SQL database? A command line perhaps?
<5> [sVG]: you have text files ... and you want them imported into an 'SQL' database?
<5> be more specific ...
<8> yessir.. specific how?
<5> 'SQL database' ... as in which one?
<5> 'text files' as in what format? ('raw' is not a format)
<8> well, whichever database I specify I suppose, what kind of info do you want?
<4> [sVG] : which vendor?
<8> and text, a basic raw text file I don't know how else to describe it :|
<5> do you have a dbms selected yet?
<8> nope
<8> or maybe I do, whats dbms?
<5> [sVG]: comma-delimited, tab delimited-, pipe delimited, XML, etc
<5> database management system ...
<5> SQL Server, Oracle, MS Access, MySQL, PostgreSQL, etc ... those are dbms's
<8> mysql
<5> we don't support that here ...
<5> hahah ...
<8> sorry I didn't notice
<5> and I'M the prick of the channel that everyone supposedly hates? :)
<4> yup
<7> I thought I was?
<8> it's ok :p
<5> CoJoNEs: I got told off by Senz the other day ... said everyone hates me ... lol ;)
<5> oh and, apparently he's "someone special" ... used to have +v here ... lost it for some reason ... yet, i've no idea who the **** he is still
<8> I'll look into an alternative to mysql then and get back.
<7> wonder what everyone thinks of me then
<7> MoZ I do hate you though
<4> senz is an op in #visualbasic
<5> CoJoNEs: yeah, when he was telling me that ****, I was like ... what about coj and shrike ... they're horrible! :)
<5> YuppieScm: and that means what in #sql?
<7> hah
<5> and #visualbasic is full of even more arrogant jack***es then #sql
<4> nuffink - just thought i'd mention
<4> i was feeling left out...
<5> and he thinks telling me I'm a prick for spouting out 'rtfm' all the time?
<5> YuppieScm: your never left out ...
<5> we just don't talk to you much
<4> MoZ : you're
<7> haha
<7> I had that almost typed in
<4> some people have no sense of humour
<5> YuppieScm: apparently, your the one lacking it ...
<5> both me and coj thought that was funny
<7> it sure was funny
<9> what's up with all the hatred...
<5> mu hat's not red
<9> gosh i will turn off "auto-join"... brb
<5> now that was uncalled for
<5> YuppieScm: spell check that, and I'm gonna beat you senseless ;p
<4> well, i thought that was funny... seems i was the only one
<9> YuppieScm:: try to kick me out one more time and see if i rejoin :) i won't...
<5> YuppieScm: all that matters usually ... personal entertainment supercedes m*** entertainment
<5> you lied!
<4> hahahahaha
<9> wtf...
<9> this stupid Invision script is acting funny.. brb
<4> no, to be fair, he said that if I did it, he wouldn't come back
<4> damn
<4> i was just about to kick him again too
<5> duh, haha
<5> i wonder if d2d can even dance ...
<4> maybe we should start shooting at his feet
<9> hell with this. i am switching to xchat. or something...
<10> anyone used sqlserver express?
<11> can't say your nickname is inaccurate :P
<9> wilco:: don't expect too much from people who uses "0" for "o"'s
<11> says d2d_w 0 rk
<9> oh yeah
<7> hah
<12> <+MoZ> and he thinks telling me I'm a prick for spouting out 'rtfm' all the time? <- dont you wish that were the case. that would be an easy way out of just simply being a senseless moron :p
<12> outties
<5> hahaha
<5> yep, I'm a senseless moron ...
Return to
#sql
or
Go to some related
logs:
NIC windowsxp
#politics
#beginner
#freebsd
#heroin
#politics
#windows
HOW TO DRAW A JOYSTICK + 3DMAX
#heroin
Safecom SWART2-54125
|
|