IRC Chat Logs - An Archive of EFnet IRC Channels

Session Start: Mon Apr 17 00:00:00 2006
Session Ident: #sql
[00:11] * NyQuil changes topic to 'Google - The best kept secret on the internet'
[01:11] * NyQuil changes topic to 'Google - The best kept secret on the internet'
[01:38] * phyx-_ is now known as Phyx-
[02:11] * NyQuil changes topic to 'Google - The best kept secret on the internet'
[02:32] * cletus is now known as Cletus
[03:11] * NyQuil changes topic to 'Google - The best kept secret on the internet'
[03:17] <prashypug> hello
[03:17] <prashypug> this may seem like a stupid question, but is there any proper way you sho
[03:18] <dfworking> which db
[03:19] <Rossignol> oh hey dfworking
[03:19] <Rossignol> ltns
[03:19] <dfworking> hey
[03:19] <prashypug> just any database
[03:19] <prashypug> like say a atheletes diary for a professional institution
[03:19] <dfworking> you referring to column names or variable names?
[03:20] <prashypug> well row names?
[03:20] <dfworking> um, guess they do shit differently in the southern hemisphere
[03:20] <dfworking> in the northern hemisphere, rows are usually numbers
[03:20] <prashypug> ah ok.
[03:20] <dfworking> i was being ironical
[03:21] <prashypug> well just say like ID, fullname, sname etc?
[03:21] <prashypug> irc sucks for ironical remarks :S
[03:21] <dfworking> well, rules of thumb are: no spaces, no special characters
[03:21] <dfworking> the rest are stylistic opinions
[03:21] <dfworking> i can give you my own
[03:21] <dfworking> but everyone has their own way that is best for them
[03:22] <dfworking> if i have a table, say 'bookmark' (i name my tables singularly), i typica
[03:22] <dfworking> and separate with an underscore
[03:23] <dfworking> bookmark: bm_ID,bm_CreationDate,bm_SomethingElse
[03:23] <dfworking> then camelcase the rest
[03:23] <dfworking> this eliminates any possibility of having ambiguity in a join
[03:24] <dfworking> if you have five tables that have 'ID' as a col
[03:24] <dfworking> ideally you should be using aliases or at least a tablename.columnname fo
[03:24] <Marios_> I use Sybase and i would like to see the code of a stored procedure...how d
[03:25] <prashypug> ah sweet thanks
[03:25] <prashypug> thanks alot
[03:25] <dfworking> Marios_, does sybase have catalog procedures like mssql?
[03:26] <dfworking> try EXEC sp_helptext 'procname' if so
[03:27] <Marios_> I tried that
[03:27] <dfworking> and
[03:27] <Marios_> and it seems I do not have permission...
[03:27] <Marios_> but using a product dbartisan, i can see the code
[03:27] <dfworking> does it work via DSN or a direct db connection?
[03:28] <dfworking> that is, connection string
[03:28] <Marios_> DSN
[03:28] <dfworking> so the user/pass the dsn is setup with has the perms
[03:29] <Marios_> ok I tried in a different Database now...and I get lines of text =53
[03:29] <dfworking> you don't
[03:29] <Marios_> I was using two different DBs
[03:29] <Marios_> now I can dow
[03:29] <Marios_> now I can do sp_helptext but I get the number of lines
[03:30] <dfworking> erm
[03:30] <Marios_> which is not what I want. I want to see the actual code
[03:30] <dfworking> where are you executing that proc
[03:30] <Marios_> Aqua Studio (connecting to a Sybase DB over ODBC)
[03:31] <dfworking> think you'll have to look at their docs then to see how you can simply re
[03:31] <dfworking> seems like it shouldn't be that hard
[03:32] <Marios_> dfworking : I am not sure if I was clear stating what I wanted. I want just
[03:33] <dfworking> i know
[03:33] <dfworking> that returns you a resultset of 'each line of the proc schema'
[03:33] <dfworking> CR delimited
[03:33] <Marios_> I see
[03:33] <dfworking> why aqua can't seem to handle it i don't know
[03:34] <Marios_> is it Aqua Issue though or ODBC driver ?
[03:34] <dfworking> can you EXEC any other procedure in aqua and get the resultset?
[03:38] <Marios_> yes
[03:38] <Marios_> i can get resultset without issue
[03:40] <dfworking> not sure what to tell you then. sp_helptext is the way to get the schema
[03:40] <dfworking> it returns a resultset, where each row is one line in the proc
[03:49] * pushgone is now known as _pusher_
[03:57] <Marios_> I don't understand why is not working...
[03:58] <dfworking> do you have permissions to create your own procs?
[04:00] * StoneCyqh is now known as stonecyqh
[04:04] <Marios_> nope
[04:11] * NyQuil changes topic to 'Google - The best kept secret on the internet'
[04:15] <SicWork> Marios_: try select text from syscomments where id = object_id('mystoredpro
[04:36] <Marios_> yes it works
[04:36] <Marios_> thanks a lot
[05:11] * NyQuil changes topic to 'Google - The best kept secret on the internet'
[05:23] <SicLuDe> np
[06:09] <SicLuDe> quiet morning
[06:11] * NyQuil changes topic to 'Google - The best kept secret on the internet'
[07:11] * NyQuil changes topic to 'Google - The best kept secret on the internet'
[07:33] * dfworking is now known as dfwaway
[07:45] * |climax| is now known as climaxNA
[08:07] <SicLuDe> wow ... i think we have solved all sql problems...
[08:08] <ownwindow> howdy
[08:08] <ownwindow> well this is boring
[08:09] <SicLuDe> lol
[08:11] * NyQuil changes topic to 'Google - The best kept secret on the internet'
[08:11] * SicLuDe burns NyQuil's house down
[08:15] <QmAIlpadi> Im using MSSQL 2005. I have designed a simple report that uses 2 datasets
[08:15] <QmAIlpadi> Ive set up parameters correctly between those 2 sets
[08:16] <QmAIlpadi> but when i want to add maybe (products dataset) and add productid as a pa
[08:17] <QmAIlpadi> its easy in code... it seems very tricky to figure out in the gui
[08:19] <QmAIlpadi> Does anybody understand my explanation of my situation?
[08:24] <phargle> reporting services?
[08:24] <Halo_Four> Doesn't really have anything to do with SQL.
[08:34] <QmAIlpadi> except that its part of the environment
[08:34] <QmAIlpadi> but agreed
[08:43] <ququ> if i have a table of 3 columns with this line only: A 2 25
[08:43] <ququ> how can i make a table from it, in this form:
[08:43] <ququ> A 2
[08:43] <ququ> A 25
[08:43] <ququ> ?
[08:51] <joerod> having some sql trouble... gonna need a little help
[08:52] <joerod> i need to query a table that has an entry of at least one constraint
[08:52] <phargle> you're not making sense alreafy
[08:52] <joerod> for instance i have a grades table with a classid and the grade in that clas
[08:52] <joerod> i need to get all students that are in that classid
[08:52] <joerod> but i also need the other classes
[08:54] <joerod> select all_classids of students where student is at least in classid
[08:54] <joerod> heh, i think that makes sense...
[08:54] <joerod> I am very well versed in sql; but I'm having a little trouble with that
[08:55] <joerod> i suppose that would be some sort of subquery
[08:55] <SicLuDe> that still makes no sense
[08:55] <Halo_Four> I think you've managed to make it even more confusing.
[08:55] <joerod> heh, ok let me try again
[08:56] <SicLuDe> so you want all students that have some classid?
[08:56] * Halo_Four puts on his helmet for this one.
[08:56] <SicLuDe> so exclude the students that dont have classid?
[08:56] <joerod> i need a list of students that are in a specific class
[08:56] <joerod> but they could also be enrolled in other classes so i want those as well
[08:56] <Halo_Four> Sounds like an SQL 101 JOIN to me.
[08:57] <SicLuDe> select * from student wehre class = 4?
[08:57] <joerod> hmm...
[08:57] <SicLuDe> something like that?
[08:57] <joerod> right that would kinda be it
[08:57] <joerod> but they could be in other classes
[08:57] <SicLuDe> and you are very well versed in sql?
[08:57] <joerod> yea, just not to awesome in joins
[08:57] <SicLuDe> ya they can be in other classes also
[08:57] <Halo_Four> What does it matter if they are enrolled in other classes?
[08:57] <Halo_Four> Not awesome in joins ~= never used a join before?
[08:57] <SicLuDe> look at the where condition
[08:58] <SicLuDe> i just said that class = 4
[08:58] <SicLuDe> i didnt say that it cant be anything else
[08:58] <Halo_Four> I'm going to assume that there is a many-to-many relationship table in th
[08:58] <SicLuDe> and there is no join here
[08:58] <SicLuDe> Halo_Four: stop trying to be confusing
[08:58] <joerod> yea, theres a many-to-many in there
[08:58] <SicLuDe> :)
[08:59] <joerod> no, wait...
[08:59] <SicLuDe> how many tables are there?
[08:59] <Halo_Four> I'd love to help, but at this point my eyes are bleeding.
[08:59] <SicLuDe> im guessing one
[08:59] <joerod> heh
[08:59] <SicLuDe> any ohter guesses?
[08:59] <joerod> yea, sorry I think i'm making it more confusing than it has to be
[09:00] <SicLuDe> i think you should not have said that you are very well versed in sql
[09:00] <joerod> there are basically two tables
[09:00] <Halo_Four> In any case this is a simple join.
[09:00] <joerod> students and grades
[09:00] <SicLuDe> ok what about a class table?
[09:00] <SicLuDe> is there a class table?
[09:00] <joerod> no, class info is in the grades table
[09:01] <SicLuDe> the grades table does what? gives a range?
[09:01] <SicLuDe> the class info is in the grades table
[09:01] <SicLuDe> wow
[09:01] <Halo_Four> Sounds like homework.
[09:01] <SicLuDe> Halo_Four: doubtful... i cant think of a class that would give something at
[09:01] <YuppieScm> indeed
[09:02] <YuppieScm> anytime someone asks a question that relates to things like classes/cours
[09:02] <SicLuDe> low level that is... and if htey did.. i doubt someone can butcher it this
[09:02] <YuppieScm> 's a homework question
[09:02] <Halo_Four> Sic: I dunno, he could be in middle school.
[09:02] <SicLuDe> YuppieScm: just read the statement: "the class information is in the grades
[09:03] <SicLuDe> hmm if htey did dbs in middle school.. ya possibly
[09:03] <joerod> lol
[09:03] <joerod> naw, its just a small part of the problem
[09:04] <joerod> just to keep it simple i'll give two tables
[09:04] <joerod> students and grades
[09:04] <joerod> i want all the grades of the students in a specific class
[09:04] <joerod> maybe i'm just having a brain freeze
[09:04] <joerod> I'm sure its not that difficult
[09:05] <joerod> lets say the classid is 31
[09:05] <joerod> well, i want all the grades from students in class 31
[09:05] <joerod> and any other class they may have in that table
[09:05] <joerod> but they have to be at least in class 31
[09:06] <Halo_Four> Funny how the requirements also keep changing.
[09:06] <joerod> well, i explained it wrong last time
[09:06] <SicLuDe> sounds like all the projects i work on
[09:06] <SicLuDe> select studentid, grade from grades where studentid in (select studentid fr
[09:07] <SicLuDe> i wont confuse this with "join"
[09:08] <ThGambler> lol
[09:08] <SicLuDe> and those aliases and wahtnot
[09:08] <SicLuDe> its confusing enough as is :)
[09:11] * NyQuil changes topic to 'Google - The best kept secret on the internet'
[09:13] <joerod> I don't think subqueries work in mysql 4.0.18
[09:13] <Halo_Four> Then you're fucked. Try using a database that isn't ass.
[09:13] <joerod> 10-4
[09:13] <joerod> thx
[09:15] <ThGambler> what are the structures of these tables?
[09:15] <joerod> basically i could do it with just the grades table
[09:16] <joerod> select * from grades where students classid contains 31
[09:16] <joerod> select studentid from grades where studentid in (select studentid from studn
[09:16] <joerod> would be perfect but like i said i don't believe subqueries work in mysql 4.
[09:17] <joerod> for some reason... they don't work...
[09:19] <ThGambler> it can be rewritten. Again, what are the structures of the tables? At lea
[09:23] <joerod> well, grades(classid, studentid, Test1, Test2, Test3, Test4, Test5, DaysAtte
[09:24] <Drk`Angel> select g.* from grades g join students s on s.studentid=g.studentid where
[09:24] <Drk`Angel> Now, go learn sql.
[09:25] <SicLuDe> lol
[09:27] <Drk`Angel> Or whatever, if I could read properly. You get the idea though.
[09:29] <joerod> i get the idea but thats the same things as saying: select * from grades whe
[09:30] <Drk`Angel> The key here is to use a join instead of a subquery since your joke of a
[09:31] <joerod> yea, its 4.0 that didnt'do subquieres
[09:31] <joerod> and 4.1 does
[09:31] <joerod> hmm
[09:31] <joerod> wierd
[09:31] <joerod> thinking about just doing the upgrade
[09:32] <joerod> well, thank for your help guys
[09:33] <joerod> later
[09:49] <joerod> just in case it comes up again the solution was a join using the same table.
[09:49] <joerod> select g.* from grades g join grades s on g.studentid = s.studentid and s.cl
[09:49] <joerod> again, thanks for the help
[09:50] <joerod> kinda like what Drk`Angel was saying
[10:11] * NyQuil changes topic to 'Google - The best kept secret on the internet'
[10:28] <SicLuDe> wow this girl taht i know makes 6.25 an hour
[10:29] <SicLuDe> and her aspiration is to get this other job which will pay her 8.75
[10:30] <uchuff> USD ?
[10:30] <SicLuDe> yes
[10:31] <uchuff> that would suck
[10:31] <SicLuDe> and shes got a kid and shes gonna have another one
[10:31] <SicLuDe> to her thats a lot of money i guess...
[10:31] <SicLuDe> i dont know if i can survive on double that
[10:44] <joerod> well, I suppose that depends on the area she lives and how much she gets in
[10:45] <SicLuDe> i dont know but i just cannot even contemplate that
[10:45] <SicLuDe> like i go out to lunch.. for a cheap lunch and thast like 15 bucks...
[10:45] <SicLuDe> id have to work like 3-4 hours in order to afford that lunch
[10:45] <kexmex> dman
[10:45] <kexmex> that's alot
[10:46] <SicLuDe> ya... nyc
[10:46] <SicLuDe> well i get an expense account so i dont care as much
[10:47] <SicLuDe> but even if i was conserving on the funds.. i dont think i can do a real lu
[10:49] <kexmex> bring your own
[10:49] <SicLuDe> hmmm
[11:00] <SicLuDe> why are people so boring on here today?
[11:01] <EyePulp> easter hangover?
[11:02] <SicLuDe> ...
[11:02] <SicLuDe> hmm
[11:04] <CoJoNEsXx> heh
[11:11] * NyQuil changes topic to 'Google - The best kept secret on the internet'
[11:12] <SicLuDe> damn hotel conection is so unreliable
[11:14] <phargle> damn in-n-out starts people at like $9
[11:15] <SicLuDe> in-n-out?
[11:15] <phargle> i had a teacher in highschool tell me once something lke "$9 might seem lik
[11:15] <SicLuDe> thats a lot if its for like a dept. store
[11:15] <phargle> burger joint
[11:16] <SicLuDe> thats a lot for a burger joint
[11:16] <SicLuDe> where is this?
[11:16] <phargle> CA
[11:17] <ThGambler> nah, burger joints in Pittsburgh pay 8 to 9
[11:17] <phargle> i would imagine a national chain like McD's would stick to minimum wage to
[11:18] <SicLuDe> if i was running it... i would oursource it :)
[11:19] <SicLuDe> for like $.50 an hour
[11:20] <YuppieScm> didn't you hear? McD's has outsourced the order-takers at their drive-thr
[11:21] <SicLuDe> hmm dont know if thats a joke but i can belive that
[11:21] <SicLuDe> i was in philly yestserday.. and at like a 7-11 type store... to order a sa
[11:21] <SicLuDe> pretty cool actually
[11:23] <phargle> sounds pretty cool, cant imagine how it'd work
[11:23] <SicLuDe> y?
[11:24] <SicLuDe> u have a set of sandwiches..
[11:24] <SicLuDe> and u have ur set of meat...
[11:24] <phargle> like rolls, or sliced bread?
[11:24] <SicLuDe> and condomins (spelling) and other topping
[11:24] <SicLuDe> basically you have ur total inventory...
[11:24] <SicLuDe> and you just group them into "breads" "meats", etc
[11:24] <phargle> just trying to figuure how something mechanical can manipulate bread, seper
[11:24] <SicLuDe> the programming and idea behind it is fairly simple
[11:25] <SicLuDe> o no
[11:25] <SicLuDe> it was just for ordering
[11:25] <SicLuDe> there were people doing the actual making of hte sandwiches
[11:25] <phargle> oh ahaha ok :D
[11:25] <SicLuDe> but i can see in the near future...
[11:25] <SicLuDe> "robo burger"
[11:25] <SicLuDe> :)
[11:26] <SicLuDe> just imagine the costs u would cut...
[11:26] <SicLuDe> :)
[11:26] <phargle> like a Blimpy or Subway with no people
[11:26] <SicLuDe> ya
[11:26] <SicLuDe> i can already see the movie... "robo burger gone crazy..."
[11:32] <Nineth> sql server: select top @top * from #temp where id not in (select top 1 id fr
[11:32] <Nineth> why I cant use variable in this ?
[11:32] <SicLuDe> cause you cant
[11:32] <SicLuDe> just how it is
[11:33] <Nineth> how to implement this ?
[11:33] <SicLuDe> you can do it dynamically
[11:33] <SicLuDe> or u can do rowcount
[11:33] <SicLuDe> you can do:
[11:33] <SicLuDe> set rowcount = @top
[11:33] <SicLuDe> select....
[11:33] <SicLuDe> set rowcount = 0
[11:33] <Nineth> Oh... okey.
[11:33] <SicLuDe> or you can do: set @sql = 'select top ' + cast(@top as varchar) + ' * from
[11:34] <SicLuDe> exec sp_executesql @sql
[11:34] <SicLuDe> the rowcount approach doesnt always work
[11:34] <SicLuDe> especially with subqueries and all that
[11:34] <Nineth> oh.
[11:34] <SicLuDe> well it might work for ur particular case
[11:34] <SicLuDe> but theres cases where it will not work
[11:34] <SicLuDe> or mght give unexpected results
[11:35] <SicLuDe> rowcount would be a better approach (performance wise)
[11:35] <Nineth> Yes, but i have subqueries.
[11:35] <SicLuDe> the dynamic quries will be a better approach maintainibily wise
[11:35] <SicLuDe> ya i cant spell
[11:35] <Halo_Four> SQL Server 2005 lets you do that.
[11:36] <Halo_Four> SELECT TOP (@n) * FROM Table1
[11:36] <SicLuDe> well since it doesnt work for him im guessin its 2000 but i dindt know 2005
[11:36] <SicLuDe> about time
[11:36] <Halo_Four> nod
[11:36] <SicLuDe> dont see why it couldnt be done before
[11:36] <Halo_Four> It could be done before, they just didn't do it.
[11:36] <SicLuDe> ok dont see why they didnt do it before :)
[11:37] <Halo_Four> They don't generally add new features to existing products.
[11:37] <SicLuDe> when it was released i mean
[11:37] <SicLuDe> if i was developing it i would figure that would be something i would like
[11:38] <guest2> yeah sicLude, I dunno why they bother with cobol when SQL server was just ov
[11:38] <Halo_Four> Sure, but they probably had other things which took precedence.
[11:38] <SicLuDe> you have to figure that any paging queries will want to dynmaiclaly change
[11:38] <Halo_Four> windowing functions are more appropriate for paging.
[11:38] <SicLuDe> what?
[11:39] <Halo_Four> ROW_NUMBER()
[11:39] <SicLuDe> windowing functions?
[11:39] <guest2> sicLude, heheh funny you should mention the dynamic paging thing, mySQL was
[11:39] <Halo_Four> Yes, part of the SQL2003 standard. SQL2005 implemented them.
[11:39] <SicLuDe> ok
[11:39] <SicLuDe> well 2000 didnt have them :)
[11:39] <guest2> SQLserver wasn't built specifically for websites...mySQL was
[11:39] <SicLuDe> guest2: even for thick clients.. you still need paging
[11:40] <guest2> heheh
[11:40] <SicLuDe> Halo_Four: thats good to know about 2k5 hough...
[11:40] <SicLuDe> though
[11:40] <guest2> I like that term "thick clients"...I find most of my clients to be a bit th
[11:40] <SicLuDe> lol
[11:40] <SicLuDe> its the code word we use to describe all the people aorund us ;)
[11:40] <Halo_Four> WITH PagedData AS (SELECT ROW_NUMBER() OVER (ORDER BY ID) AS rownum, * FR
[11:41] <SicLuDe> Halo_Four: whats the performance on that?
[11:41] <Halo_Four> If the ORDER BY column is indexed, quite fast.
[11:41] <SicLuDe> i mean.. i know they have recursive queries in 2005 also but the performanc
[11:41] <Halo_Four> A couple percentages points above a clustered index range scan.
[11:42] <SicLuDe> hmm cool
[11:42] <Halo_Four> I'm not sure why windowing functions themselves can't be used in the WHER
[11:42] <SicLuDe> row_number() is a windowing function?
[11:42] <Halo_Four> yes
[11:42] <SicLuDe> sorry never heard that terminology before
[11:43] <Halo_Four> http://en.wikipedia.org/wiki/Select_(SQL)#ROW_NUMBER.28.29_window_functio
[11:43] <Halo_Four> The big 3 now support 'em.
[11:44] <Halo_Four> Their samples also show the same basic thing, using them in a subquery, s
[11:44] <SicLuDe> is that part of sql2003 standard?
[11:44] <SicLuDe> o u said that
[11:47] <SicLuDe> damn i guess i need to get rid of that totally awesome and cool stored proc
[11:47] <Halo_Four> I just wish they let you specify a column in a parameter or something.
[11:48] <Halo_Four> That way the paging order could be easily specified.
[11:48] <SicLuDe> well i guess u still hav eto resort to dynamic sql
[11:48] <SicLuDe> :)
[11:49] <Halo_Four> nod
[11:49] <SicLuDe> although... u can just have a lot of if thens :)
[11:49] <SicLuDe> and cover all the diff columns that way
[11:50] <Halo_Four> At least the common table expression syntax makes subqueries bearable.
[11:50] <SicLuDe> eh i never thought subqueries were unbearable in 2000
[11:50] <SicLuDe> :)
[11:50] <SicLuDe> the way i look at it.. if its made too easy.. then im replacable :)
[11:51] <SicLuDe> some idiot who can move a mouse can come and take over my job
[11:51] <SicLuDe> basically what happened in the 90s ... any idiot who can move a mouse and w
[11:51] <data_art> Database: MS SQL Server 2005 Express; Question: How do I fix the problem o
[11:52] <SicLuDe> data_art: disconnect
[11:52] <SicLuDe> ?
[11:53] <data_art> hmm...did that. should I reboot?
[11:54] <CoJoNEsXx> sure, reboot
[11:54] <data_art> thanks. back in a bit
[11:55] <SicLuDe> lol
[11:55] <SicLuDe> make sure u are on a production machine
[11:55] <data_art> that's SO mean :-(
[11:56] <CoJoNEsXx> heh
[11:57] <SicLuDe> lol
[11:58] <SicLuDe> CoJoNEs: u made the poor guy reboot a production machine
[11:58] <SicLuDe> his company is probaby losing thousands right now
[11:58] <[Wizzer]> guys, need some help
[11:58] <CoJoNEsXx> heh
[11:58] <CoJoNEsXx> Wizzer, reboot.
[11:59] <[Wizzer]> I have 3 columns: maker, model and type
[11:59] <[Wizzer]> I need to select those makers who sell PC, but not Laptops
[12:00] <SicLuDe> select makers where type != 'laptop' and type = 'PC'
[12:00] <SicLuDe> ?
[12:00] <SicLuDe> i dont know..
[12:00] <SicLuDe> wahts the pk?
[12:00] <CoJoNEsXx> can I make up an answer too?
[12:01] <[Wizzer]> problem is that some of makers do sell PC also
[12:01] <SicLuDe> select a.makers from blah where type = 'pc' and maker not in (select maker
[12:01] <[Wizzer]> so I need to remove makers group that have laptop
[12:01] <SicLuDe> so u want everyone who makes PC ?
[12:01] <CoJoNEsXx> SicLuDes query would work
[12:01] <SicLuDe> ok try the second query
[12:01] <[Wizzer]> sec please
[12:02] <SicLuDe> for some reason i dont wnat to do joins today
[12:02] <SicLuDe> i seem to be prefering IN
[12:02] <SicLuDe> :)
[12:02] <CoJoNEsXx> yeah i was just thinking I would have done a self join on that
[12:02] <SicLuDe> normally i would
[12:02] <CoJoNEsXx> but whatever, its not my app
[12:02] <SicLuDe> i guess im just not in the mood :)
[12:02] <SicLuDe> eh if its a decent enough db it will optimize :)
[12:02] <[Wizzer]> .........
[12:02] <[Wizzer]> select DISTINCT a.maker from Product as a where type = 'pc' and maker not
[12:02] <[Wizzer]> thanks =)
[12:03] <SicLuDe> sure
[12:03] <SicLuDe> come again
[12:03] <SicLuDe> next time you might get a join if you are lucky
[12:03] <[Wizzer]> damn it, was dealing with inner joins :|
[12:03] <SicLuDe> they work too
[12:03] <CoJoNEsXx> that should work fine
[12:04] <[Wizzer]> yeah, thanks again! =)
[12:04] <SicLuDe> select a.maker from blah a inner join blah b on a.model != b.model where a.
[12:04] <SicLuDe> something like that
[12:05] <SicLuDe> or not..
[12:05] <SicLuDe> who knows
[12:05] <SicLuDe> do it by hand
[12:05] <SicLuDe> have a monkey sit there and return the results each time someone wants it
[12:06] <CoJoNEsXx> heh
[12:06] <SicLuDe> or just reboot:)
[12:06] <[Wizzer]> hmm
[12:06] <CoJoNEsXx> exactly
[12:07] <[Wizzer]> so helping is a monkey sitting for you?
[12:07] <SicLuDe> huh?
[12:07] <[Wizzer]> I asked for help, and you helped me, I thanked you
[12:08] <SicLuDe> [15:07:35] <[Wizzer]> so helping is a monkey sitting for you?
[12:08] <SicLuDe> i dont get it
[12:08] * SicLuDe confused
[12:08] <[Wizzer]> >>have a monkey sit there and return the results each time someone w
[12:08] <SicLuDe> yep
[12:08] <SicLuDe> thats what all the smart dbas do
[12:08] <[Wizzer]> oh =)
[12:09] <[Wizzer]> sorry
[12:09] <SicLuDe> MoZ is actually my monkey
[12:09] <SicLuDe> we call him "oracle"
[12:09] <[Wizzer]> aha, ok, no problems. Sorry :)
[12:09] <[Wizzer]> Thanks again =)
[12:09] <SicLuDe> np
[12:10] <SicLuDe> dont forget to reboot ur production machine atleast once a day
[12:10] <[Wizzer]> Why so?
[12:10] <[Wizzer]> Memory leaks?
[12:10] <SicLuDe> well if its always up then they will think the dba is not needed
[12:10] <SicLuDe> (i was joking)
[12:10] <[Wizzer]> :))
[12:11] * NyQuil changes topic to 'Google - The best kept secret on the internet'
[12:11] <[Wizzer]> I'm new to sql, just learning.
[12:11] <[Wizzer]> trying to get higher rating at www.sql-ex.ru
[12:12] <[Wizzer]> There are some topics
[12:12] <[Wizzer]> and databases - you do live queries
[12:12] <[Wizzer]> and see if it is correct
[12:12] <[Wizzer]> DML is also avail
[12:14] <SicLuDe> huh?
[12:14] <[Wizzer]> ?
[12:14] <SicLuDe> u want us to look at it?
[12:15] <[Wizzer]> as you wish :) maybe you'll be able to beat that guy, ranked as mister fir
[12:16] <[Wizzer]> top photoes are also avail.
[12:16] <SicLuDe> lol
[12:16] <[Wizzer]> photos*
[12:16] <[Wizzer]> =)(
[12:16] <SicLuDe> i want to be mister first place
[12:16] <[Wizzer]> I like that place, cause you can practice against real database with real
[12:16] <[Wizzer]> =) so try it
[12:18] <SicLuDe> cool
[12:18] <SicLuDe> i guess its a good place to learn
[12:18] <[Wizzer]> ahh, need some sleep. ok guys. see you tomorrow :)
[12:18] <SicLuDe> l8r
[12:23] * _pusher_ is now known as pushgone
[12:43] * Cletus is now known as cletus
[12:56] * stonecyqh is now known as StoneCyqh
[13:11] * NyQuil changes topic to 'Google - The best kept secret on the internet'
[13:24] <SicLuDe> wow i go away for an hour and noone has yet to say anything
[13:33] <SicLuDe> oracle sucks
[13:34] <SicLuDe> i cant get an execution plan without creating a damn table?
[13:46] <CoJoNEsXx> yes
[13:46] <CoJoNEsXx> explain plan
[13:46] <SicLuDe> just like that?
[13:46] <SicLuDe> that didnt work
[13:46] <SicLuDe> from what i read.. explain plan requires a table
[13:46] <SicLuDe> to put the explaination into
[13:48] <CoJoNEsXx> go into sqlplus
[13:48] <CoJoNEsXx> set autotrace on
[13:49] <CoJoNEsXx> write your statement
[13:49] <CoJoNEsXx> SicLuDe, try this
[13:49] <CoJoNEsXx> http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:111012
[13:49] <NyQuil> http://tinyurl.com/kanpk
[13:49] <CoJoNEsXx> for some more options
[13:52] <frankrizz> I am trying to run a query in oracle where it returns all the results whe
[13:52] <frankrizz> http://sql-servers.com/nopaste/?show=551
[13:52] <Halo_Four> What's with the subselect?
[13:52] <frankrizz> I have gotten this before and am thinking perhaps there is a gotcha that
[13:52] <Halo_Four> The subselect requires an alias and the tables used within the subselect
[13:53] <Halo_Four> But you should probably just use a normal join.
[13:54] <frankrizz> instead of using a subquery?
[13:54] <Halo_Four> yes.
[13:54] <frankrizz> i'll try that
[13:56] <Halo_Four> The subquery in the FROM clause completely changes the schema you have to
[14:03] <frankrizz> its mostly working now, but i have many orders with the same product numb
[14:05] <frankrizz> i think thats why I was trying to do a subquery so I could group them all
[14:07] <Halo_Four> You were using the subquery to accomplish the join and then filtering aft
[14:07] <frankrizz> http://sql-servers.com/nopaste/?show=552
[14:07] <frankrizz> i changed it to that
[14:08] <frankrizz> but it only shows instances where on any given order more than 500 dollar
[14:08] <frankrizz> opposed to over a bunch of orders over 500 dollars worth a specfic produc
[14:09] <Halo_Four> Um, the first query, had you matched the schema, would have done the same
[14:11] * NyQuil changes topic to 'Google - The best kept secret on the internet'
[14:11] <CoJoNEsXx> without knowing what your data looks like, I assume the query you wrote i
[14:12] <Halo_Four> Ain't homework fun?
[14:12] <frankrizz> the query works
[14:13] <CoJoNEsXx> I sense a 'but' coming
[14:13] <frankrizz> haha
[14:13] <frankrizz> it works, but i guess im not telling it to do the right thing
[14:14] <frankrizz> because it working doesnt result in the right answer
[14:14] <Halo_Four> Communicating with the server about as well as you are communication with
[14:14] <Halo_Four> But we generally don't assist with homework.
[14:14] <CoJoNEsXx> put on the site the output, and what you want the output to look like and
[14:18] <frankrizz> http://sql-servers.com/nopaste/?show=553
[14:19] <Halo_Four> What's wrong with the output?
[14:19] <frankrizz> the problem is that it does not indclude the 2,5, and 5 orders
[14:20] <frankrizz> or the orders that did not include over 500 dollars in product
[14:21] <Halo_Four> Because you told it not to
[14:21] <Halo_Four> "products.price*unit > 500"
[14:21] <MoZ> haha
[14:22] <MoZ> I've been corresponding with this recruiter chick for a new job position ... fo
[14:22] <CoJoNEsXx> and you found out shes a stripper at your favorite strip club?
[14:22] <MoZ> she finally today tells me the job description ... and then tells me she feels
[14:23] <MoZ> her initial email was "can I have a copy of your resume for future openings", t
[14:23] <MoZ> the $50/hr had my intriqued, so I had to keep corresponding with her ...
[14:23] <Halo_Four> Recruiters are always full of shit.
[14:23] <MoZ> the job description states they want a 2+ year experienced .net developer, who
[14:23] <MoZ> how you become an expert in C#/.NET in two years is beyond me ...
[14:23] <Jarett_> yeah you arent any of those
[14:23] <frankrizz> i get that, but thats why I was trying to use a subquery, so I could add
[14:24] <MoZ> but I've dealt with enough certified and diploma'd .net developers to know I kn
[14:24] <Halo_Four> frankrizz: Um, no, that's not what the subquery would do
[14:24] <frankrizz> ok
[14:24] <Halo_Four> If you want to filter then filter, otherwise don't filter.
[14:24] <MoZ> sadly, I don't know that much .net ... self admittedly ... though I understand
[14:25] <frankrizz> what could I use then? im not really asking for the answer, just how to g
[14:25] <Halo_Four> Don't even know what you're trying to do. You want to filter but you wan
[14:26] <MoZ> Halo_Four: heh
[14:26] <MoZ> frankrizz: whats the question?
[14:26] <Halo_Four> The initial "question" was why was this not working: http://sql-servers.c
[14:27] <Halo_Four> Answer being that the subquery used to perform the join changes the schem
[14:28] <frankrizz> I have another query that shows me the total amount ordered of a certain
[14:28] <frankrizz> which I thought I was asking it before, but I was obviously wrong
[14:28] <Halo_Four> Ask your professor about GROUP BY and HAVING clauses
[14:29] <Halo_Four> And learn SQL92 INNER JOIN syntax
[14:29] <frankrizz> group by didnt work as it said it was not a group by statement, but I wil
[14:29] <MoZ> select product, count(orders), price from products p left join orders o on p.pr
[14:30] <MoZ> poorly syntaxed, so you get to figure out the right way ;)
[14:30] <MoZ> Halo_Four: how would having help in this situation, unless I misunderstood the
[14:30] <CoJoNEsXx> heh
[14:30] <frankrizz> haha, thanks
[14:31] <Halo_Four> MoZ: I think he's looking to sum up the orders and show only those with a
[14:31] <Halo_Four> But shit, who can tell.
[14:31] <MoZ> Halo_Four: ahh, I thought he wanted to show the orders where the price was >
[14:31] <Halo_Four> You'd think that given the SQL he pasted.
[14:31] <MoZ> but yeah, summing the total number of orders for a product is easy ...
[14:31] <MoZ> I didn't look at his sql ...
[14:32] <MoZ> cause if I did, I'd most likely be compelled to /kick him ...
[14:32] <CoJoNEsXx> consider yourself lucky..
[14:32] <Halo_Four> Damnit, friend bailed tonight, no wings for me :(
[14:32] <frankrizz> haha, thanks
[14:32] <MoZ> wow ...
[14:32] <MoZ> that query is horrible ...
[14:32] <frankrizz> i had queries to add up the total amount of each order as well as the tot
[14:33] <frankrizz> i take no offense, im new
[14:34] <data_art> how do I forward my development server output to my laptop?
[14:34] <MoZ> data_art: by asking a better question
[14:34] <CoJoNEsXx> heh
[14:35] <data_art> sorry...
[14:35] <data_art> I'm trying to see the output on my development web server via wifi on my l
[14:35] <data_art> but it says "connection refused"
[14:35] <MoZ> still not the best question you could ask
[14:35] <CoJoNEsXx> what does that have to do with sql?
[14:36] <data_art> I'm trying to connect to the SQL Server database using this method
[14:37] <MoZ> data_art: seriously ...
[14:37] <MoZ> think about your issue ...
[14:37] <MoZ> then ask a question that relates to it ...
[14:37] <MoZ> in your question
[14:37] <MoZ> be sure to include ...
[14:37] <MoZ> a subject, a verb and a noun
[14:38] <kexmex> MOZ
[14:38] <MoZ> example, "I have an SQL Server on a remote machine, when I attempt to connect t
[14:38] <MoZ> kexmex: ?
[14:38] <kexmex> just testing :)
[14:39] * MoZ changes topic to 'CoJoNEs ballsack, the least used thing on the planet'
[14:40] <CoJoNEsXx> *sigh*
[14:40] <CoJoNEsXx> that vhost is homo
[14:41] <CoJoNEsXx> oh yay! a pm from the fruit
[14:41] <Halo_Four> He's going to tell you that he can unban himself and then kick you
[14:41] <Halo_Four> I was here for the drama last time.
[14:42] <CoJoNEsXx> he can unban himself and kick me? sure.. ok
[14:42] <Halo_Four> That's what Yuppie said
[14:42] <Halo_Four> <shrug />
[14:46] * Quant|Out is now known as Quant
[14:53] <YuppieScm> indeed
[14:53] <YuppieScm> and then, there i was, kicked
[14:54] <YuppieScm> much like that, except NyQuil did it, iirc
[14:55] <CoJoNEsXx> ah, someone was on the bot
[14:55] <YuppieScm> i could check my logs, but cba atm
[14:55] <guest2> oh gawd, you guys had beeter get better bots soon
[14:55] <guest2> or you'll be ip spoofed to death
[14:56] <guest2> but hey, maybe you dig that kind of scroll
[14:56] <CoJoNEsXx> oh gawd I hate listening to you guest2
[14:58] <YuppieScm> found it - seems like i could be arsed after all
[14:59] <YuppieScm> it was nyquil that kicked me at kexmex's behest
[15:00] <CoJoNEsXx> heh
[15:00] <CoJoNEsXx> NyQuil is a whore, dont worry about ti
[15:04] <YuppieScm> CoJoNEsXx : I *never* worry about ti
[15:04] <Darken|> ti over charges
[15:04] <Darken|> those bastards
[15:05] <CoJoNEsXx> damn right
[15:05] * CoJoNEsXx stabs em in the eye with Quants tiny penis
[15:09] <GuntherX> "i thought 7-up was just another night in the dormitory, until I discovere
[15:19] <Nickslate> I have a very large mssql database that has a field that contains html, t
[15:19] <GuntherX> Nickslate : yes. it's called 'writing some code'
[15:21] <GuntherX> Nickslate : doesn't need to be in sql - in fact it'll be much easier in pe
[15:21] <Nickslate> Is there a way to write SQL code and execute it externally? I use access
[15:21] <GuntherX> ffs
[15:21] <Nickslate> Well I tried to write it in ASP but failed.
[15:22] <GuntherX> i'm so going to ignore you for the rest of the evening
[15:22] <d2d_h0me> did you guys notice that humans are fucked up?
[15:23] <d2d_h0me> stupid jury duty makes me think so negatively about everything in this wor
[15:23] <d2d_h0me> we suck
[15:24] <d2d_h0me> should've acted like a retard not to get picked as a juror.
[15:26] <MoZ> haha
[15:26] <MoZ> just took a test on proveit.com ... for .NET programming in C#
[15:26] <MoZ> half the questions were bogus ...
[15:26] <MoZ> some of them had nothing to do with C# ...
[15:27] <MoZ> like ... 'which of the following looping statements is/are new to the C Family
[15:27] <MoZ> but how does that have anything to do with C#? and since when is C# part of the
[15:28] <Halo_Four> The # is supposed to be short for C++++ :)
[15:28] <MoZ> haha
[15:28] <Halo_Four> And I'll take a wild guess that the answer was "foreach"
[15:28] <MoZ> being as I gave the answer, your right! :)
[15:28] <MoZ> otions were "for, while, do, foreach"
[15:29] <d2d_h0me> MoZ:: which one did you take?
[15:29] <MoZ> d2d_h0me: .NET programming in C# ... or whatever it's called ...
[15:29] <MoZ> why?
[15:29] <d2d_h0me> hmm. just curious..
[15:29] <d2d_h0me> seems like it's not free?
[15:29] <MoZ> got 28 of 36 correct
[15:29] <MoZ> d2d_h0me: companies who are interviewing, have you test first ...
[15:29] <MoZ> so yeah, no ... it's not free ;)
[15:30] <d2d_h0me> gosh... that sucks
[15:30] <MoZ> I didn't pay for it ... the company I'm submitting my resume to did ...
[15:30] <d2d_h0me> Such BS: "Prove It! gives you the power to identify and select the most ta
[15:30] <Halo_Four> hehe
[15:30] <MoZ> the ones I got wrong ... were most likely the ones that had nothing to do with
[15:30] <Halo_Four> Yay, now they know whether or not you can take a test.
[15:30] <d2d_h0me> if the company wants someone who they THINK are qualifed, then they shoudl
[15:31] <d2d_h0me> s/force/help
[15:31] <MoZ> like for examples ... all attributes require you to have ... comment, get/set,
[15:31] <MoZ> the only pluasible option was 'comment' ... since VS.Net bitches when you don't
[15:31] <d2d_h0me> eh? VS bitches? when there is no comment?
[15:31] <Halo_Four> hm, neither of those answers makes sense.
[15:32] <MoZ> yeah
[15:32] <MoZ> it gives a warning ...
[15:32] <Halo_Four> You don't have to comment anything, unless you enable XML documenting
[15:32] <d2d_h0me> oh i see. i have never wrote anything without comments...
[15:32] <d2d_h0me> oh i see..
[15:32] <Halo_Four> I almost never use comments.
[15:32] <d2d_h0me> let me give it a try
[15:32] <d2d_h0me> Halo_Four:: i envy you...
[15:33] <d2d_h0me> taht's one of the things i would like to achieve in my programs.
[15:33] <d2d_h0me> a source code that doesn't need comments..
[15:33] <Halo_Four> I write verbose code, though.
[15:33] <d2d_h0me> hmmm not good :)
[15:33] <Halo_Four> I comment stuff if what I'm doing isn't clear.
[15:33] <d2d_h0me> yeah. that's true. but i would like to write in a way that, i don't neeed
[15:34] <Halo_Four> Don't use single letter variable names, that's a start ;)
[15:34] <d2d_h0me> yupz. and following conventions.
[15:34] <d2d_h0me> i am such a convention freak.
[15:34] <d2d_h0me> whenever i try to learn a new language, the first thing i usually look for
[15:34] <MoZ> haha
[15:34] <MoZ> I have one convention
[15:34] <MoZ> and I use it in all my code
[15:35] <MoZ> it's called a 'code style' ...
[15:35] <d2d_h0me> and that is?
[15:35] <MoZ> fuck generally consumable converionts ...
[15:35] <_jetair> anyone used gentoo/freebsd
[15:35] <MoZ> their always ugly ... and harder to code in
[15:35] <Halo_Four> I like it to look really fucking clean. Nothing pissed me off more than
[15:35] <MoZ> _jetair: whats that gotta do with sql?
[15:35] <d2d_h0me> _jetair:: yes i have used gentoo and it's a bitch to setu up
[15:35] * MoZ rubs his gentoo workstation
[15:35] * MoZ pimp slaps d2d_h0me
[15:35] <Jarett_> why do you classify gentoo with freebsd?
[15:35] <MoZ> it is not hard to setup ...
[15:35] <_jetair> i wanna vmare image
[15:36] <MoZ> _jetair: again, what does any of this have to do with SQL?
[15:36] <_jetair> yes it is jarett
[15:36] * d2d_h0me stumbles away
[15:36] <MoZ> VMWare has 'appliances' ... go download one
[15:36] <_jetair> it is combine gentoo and feebsd
[15:36] <MoZ> gentoo != freebsd ... in ANY way
[15:36] <Jarett_> "yes it is" is not a valid answer
[15:36] <MoZ> what combines gentoo and freebsd?
[15:36] <Jarett_> stupid people
[15:36] <d2d_h0me> _jetair:: you can compare Darwin to FreeBSD but not to Gentoo
[15:36] <Jarett_> like _jetair
[15:36] <MoZ> gentoo is linux
[15:36] <MoZ> FreeBSD is BSD ...
[15:37] <_jetair> yes
[15:37] <MoZ> they are similiar in that they are both 'unixes' ...
[15:37] <d2d_h0me> comparing Gentoo to FreeBSD is to compare Jarett_ to _jetair
[15:37] <_jetair> but it is present
[15:37] <_jetair> gentoo/fbsd
[15:37] <MoZ> _jetair: what is present?
[15:37] <_jetair> pz dont debate
[15:37] <Halo_Four> It's called Google. Heard of it?
[15:37] <Jarett_> i think we are talking to someone who doesnt speak english.. or who is a do
[15:37] <d2d_h0me> what happened to the topic...
[15:37] <Halo_Four> In any case, #sql ain't the channel for this.
[15:38] <d2d_h0me> Gotta change the topic BACK to Google: The best thing ever happaned to the
[15:38] <MoZ> Halo_Four: yeah, I hated the winform 'added coded'
[15:38] <Halo_Four> MoZ: VS2005 cleaned that all up beautifully.
[15:38] <MoZ> d2d_h0me: it was "Google - The best kept secret on the internet" ... dumb ass ;
[15:38] <d2d_h0me> oh yeah.. ma bad
[15:38] * d2d_h0me googles it up
[15:38] <MoZ> Halo_Four: yeah, by splitting the winform into two files ... lol
[15:39] <Halo_Four> MoZ: Of course, but it achieves the goal :)
[15:39] * NyQuil changes topic to 'CoJoNEs ballsack, the least used thing on the planet'
[15:39] <MoZ> yeah
[15:39] <MoZ> now, who thinks that an 80% score on the proveit.com test is good enough to get
[15:39] <Halo_Four> hehe
[15:39] <MoZ> cause seriously, what ever idiot takes that test and gets a 100% ... does not k
[15:40] <_jetair> http://gentoo.osuosl.org/experimental/x86/freebsd/
[15:40] <MoZ> the questions were grammatically incorrect, making them hard, if not impossible
[15:40] <d2d_h0me> it's either one doesn't know shit, or one is smart enough to put him/herse
[15:40] <MoZ> _jetair: I'm gonna ask this one more time ...
[15:40] <MoZ> then I'm going to annally rape you
[15:41] <MoZ> WHAT THE FUCK DOES THIS HAVE TO DO WITH SQL ...
[15:41] <MoZ> and ...as a side note ...
[15:41] <MoZ> Gentoo and FreeBSD are not the same thing ...
[15:41] <MoZ> if anything, it's a dual boot image with gentoo and freebsd on it ...
[15:41] <_jetair> so what is this ?
[15:41] <_jetair> ok
[15:41] <MoZ> _jetair: this is not #Vmware or #Gentoo or #FreeBSD
[15:41] <Jarett_> no its a freebsd build by a gentoo.org developer
[15:41] <MoZ> stop asking
[15:41] <Drk`Angel> It may have some freaky weaky binary compatability thing going on, kinda
[15:41] <Jarett_> pretty stupid
[15:41] <_jetair> ok
[15:42] * d2d_h0me is now known as d2d_f0od
[15:43] <Jarett_> _jetair, http://chaz6.com/static/files/vmware/DesktopBSD%201.0.rar get th
[15:43] <Jarett_> and use the official supported package manager. not some emerge hacked crap
[15:44] <_jetair> jarett thx
[15:44] * _jetair nods
[15:45] <guest2> heheh ip spoofing makes it to IRC
[15:46] <guest2> you guys better shut off the auto-op feature
[15:46] <MoZ> hrm, apparently 80% is good enough to get a phone screening ... lol
[15:51] <_jetair> can i say something? MOZ
[15:52] <MoZ> _jetair: depends ... is it going to be a retarded comment
[15:52] <MoZ> ?
[15:52] <_jetair> Gentoo/FreeBSD is a FreeBSD-based Gentoo distribution
[15:52] <_jetair> thats all
[15:52] <Jarett_> _jetair no it isnt a gentoo distribution at all
[15:52] <_jetair> sorry
[15:53] <MoZ> _jetair: one more stupid comment, and your gone for good
[15:53] <Jarett_> some putz idiots from the forums of gentoo want to make fbsd worse than it
[15:54] <wasabi_> What does any of that have to do with #sql?
[15:54] <Halo_Four> I'm going to go join #freebsd and #gentoo and ask SQL questions.
[15:54] <Jarett_> make sure they are mysql questions :P
[15:55] <_jetair> really iam happy with you all
[15:55] <MoZ> Jarett_: haha, he's more then likely going to get valid responses then ... ;)
[15:55] <Halo_Four> hm, I'll have to scour the net for the dumbest shit about MySQL I've ever
[15:55] <_jetair> :)
[15:56] <MoZ> Halo_Four: just ask about the 2/31 date issue ;)
[15:57] <Halo_Four> Do you think Gentoo/BSD will let me install on 2/31st?
[15:57] <MoZ> it's a valid date in mysql ... why not ;)
[16:03] <robertfla> for mysql is there a way of retreiving file directories via a query
[16:04] <CoJoNEs> for #sql is there a way to read the rules?
[16:04] <wasabi_> robertfla: read the rules
[16:05] <robertfla> #rules
[16:07] <MoZ> I'm gonna laugh my ass off if the rule bot is down ;)
[16:07] <CoJoNEs> heh
[16:08] <wasabi_> Naw, it's up.
[16:08] <CoJoNEs> heh
[16:08] <wasabi_> Checked before I told him to.
[16:08] <CoJoNEs> woulda been funny though
[16:09] * MoZ changes topic to 'If you want fair, we can start charging at the door.'
[16:10] <MoZ> 2
[16:10] <phargle> you can't handle the fair
[16:11] * phargle does a bad nicholson
[16:14] <frankrizz> moz, i rewrote the query from before
[16:14] <frankrizz> and it works, i didnt end up using what you suggested, but it made me thi
[16:15] <CoJoNEs> yay! MoZ made someone think and do the right thing
[16:15] <CoJoNEs> the circle of #sql is complete
[16:15] <frankrizz> haha
[16:49] <Jarett_> everyone goto http://www.foodnetwork.com and vote for guy
[16:52] <CoJoNEs> heh
[17:04] <Quant> heh
[17:05] <Quant> jarett: Ok did
[17:09] * NyQuil changes topic to 'If you want fair, we can start charging at the door.'
[17:10] <Andy298> got an issue with usernames. i'm making a system which automatically will c
[17:12] <CoJoNEs> why would mysql only support 16 chars in a field?
[17:12] <Andy298> CoJoNEs: for a username it does! :S
[17:12] <Jarett_> Andy298, truncate out all odd characters and make a keyword for domains
[17:12] <Jarett_> remove all 0 O 1 I
[17:13] <Quant> lol what?
[17:13] <Jarett_> then go from there
[17:13] <Quant> that's nasty
[17:13] <CoJoNEs> oh, you mean an acutual username field?
[17:13] <Quant> how about modify that php shit they wrote
[17:13] <Quant> to accept more than 16
[17:13] <Quant> it's all open sores right?
[17:13] <CoJoNEs> I wouldnt give them an actual sql login unless they need it
[17:13] <Andy298> Quant: im making my own PHP system to auto create users, but i am under the
[17:14] <Quant> real mysql users or you have a table with userS?
[17:14] <Jarett_> coJoNEs for stuff like cpanel + phpmysql...
[17:14] <Jarett_> they need a mysql login
[17:14] <CoJoNEs> that makes sense
[17:14] <Quant> jarett: are you an undercover mysql user or somtehing?
[17:14] <Andy298> real mysql users
[17:14] <CoJoNEs> MySQL usernames can be up to a maximum of 16 characters long. This limit is
[17:15] <Jarett_> Quant, need to know how something works in order to convince people not to
[17:15] <Quant> heh
[17:15] <Quant> jarett: you know too much :)
[17:15] <Jarett_> i probably know more about the internals of it than the typical powruser
[17:15] <Jarett_> but reducing down domains is just basics :P
[17:15] <Quant> where is it's heart located?
[17:15] <Jarett_> in its storage engine
[17:15] <Jarett_> since its just a whored up interface to the engine.. which they dont even w
[17:16] <Andy298> Jarett_: it needs to be a usable name i can expect a customer to remember!
[17:16] <Jarett_> Andy298, and?
[17:16] <SicWork> Quant: check out this massive paperweight i just bought
[17:16] <Andy298> it will be used to log into a custom control panel as well as for their mys
[17:16] <SicWork> http://www.amazon.com/gp/product/0070120579/sr=8-1/qid=1145318388/ref=pd_bb
[17:16] <Jarett_> then truncate it down to 10 characters and append a number to it
[17:16] <Quant> sic: i know those by heart :)
[17:17] <Quant> Triangle!!
[17:17] <Quant> Head and Shoulders!!!!!!
[17:17] <SicWork> well help me write this thing then :)
[17:17] <Andy298> Jarett_: how would you suggest i append a number? and ensure that the numbe
[17:17] <Jarett_> with a very simple table
[17:17] <Quant> sic: i know how they supposto look on the graph but not the algo's to recogni
[17:17] <Quant> Sic: i realyl like RSI + FAst Stochastics + OBV + MACD
[17:17] <SicWork> well ur useless
[17:18] <Jarett_> Andy298, your company really should hire someone wih more of a clue
[17:18] <Quant> i think you need a neural net
[17:18] <Jarett_> or buy an off the shelf package to do this like cpanel
[17:18] <SicWork> Quant: im gonna write a program to figure it out and ill tell yo uwhat u sh
[17:18] <Quant> Sic: lets do something with MS ANalysis services
[17:18] <SicWork> Quant: kinda along hte lines im going towards :)
[17:18] <Quant> Sic: you wanna datamine?
[17:18] <Andy298> Jarett_: cpanel doesn't work with windows - we are only after some basic fe
[17:19] <Jarett_> Andy298, plus if you are taking creditcards, you need to have alot more lo
[17:19] <Jarett_> windows? how quaint
[17:19] <Quant> hey stop using my shit :)
[17:19] <Jarett_> i give you 2 weeks of being alive
[17:20] <Andy298> lol
[17:20] <Jarett_> you will be hacked the moment your site hits google
[17:20] <Andy298> you think?
[17:20] <CoJoNEs> id put money on getting hacked
[17:21] <Andy298> hmmm ok
[17:21] <Andy298> anyway this number? LOL
[17:21] <Jarett_> whats your company name? we can have it listed on the events market
[17:21] <Andy298> nothing online yet!
[17:21] <Andy298> hmm why am i getting so much abuse
[17:21] <Jarett_> my bet is hack+2weeks+100%
[17:21] <Quant> because it's after work hours
[17:21] <Quant> you get abused during this time
[17:21] <Jarett_> and its not #mysql
[17:21] <CoJoNEs> cause you are way above your head
[17:23] <Andy298> ok
[17:23] <Jarett_> there are hundreds of webhoster control panels out there...
[17:23] <Jarett_> all written by people way smarter
[17:24] <Andy298> for windows? that integrate well with apache, mysql, mail server + ftp + DN
[17:24] <Andy298> i think not
[17:24] <Jarett_> dont use windows dude
[17:24] <Jarett_> is this on XP?
[17:24] <CoJoNEs> why would you use apache + mysql on windows?
[17:24] <Jarett_> since he read an article on LAMPP
[17:25] <Jarett_> and loaded up something stupif like XAMPP
[17:25] <Andy298> all manually installed actually
[17:25] <Jarett_> wow how wonderful
[17:25] <Andy298> yes
[17:25] <Jarett_> are you hosting this in your home?
[17:25] <CoJoNEs> even better
[17:25] <Andy298> for the time yes
[17:26] <Jarett_> lol
[17:26] <Andy298> brb
[17:26] <Jarett_> you do realize that according to the PCI (payment card industry) requiremen
[17:27] <Jarett_> since you are hosting it at home...
[17:27] <Jarett_> i doubt they would like that
[17:27] <CoJoNEs> does mysql still lose data under high load?
[17:27] <Jarett_> ohhh are you IRCing from your windows "webhosting server"?
[17:29] <Jarett_> this is very funny... but i feel bad for your future customers. use one
[17:30] <CoJoNEs> having an open mysql port on your windows box is more scary then funny
[17:32] <Jarett_> lol yeah
[17:35] <Jarett_> at least the moron enabled pop before smtp
[17:35] <Jarett_> dont think he realized it though
[17:38] <Jarett_> Andy298, how do you plan on hosting DNS when your ISP dont give you SOA? w
[17:48] <Andy298> who said ANYTHING about credit cards? so that doesn't worry me
[17:48] <Andy298> webserver.home.local wont work on the web will it.....
[17:48] <Andy298> ah well things seem to be going ok (up to now)
[17:48] <Andy298> until one of you hack it for "fun"
[17:50] <Jarett_> Andy298, you have your mysql exposed to the web
[17:50] <Jarett_> on an alwayson ip address
[17:50] <Jarett_> my guess is someone already hacked it
[17:51] <Halo_Four> No DB should be exposed to the public Internet, ever.
[17:51] <Halo_Four> That's just bad mojo.
[17:51] <Andy298> you 3306 should be blocked?
[17:51] <Andy298> denying remote access to the database server
[17:51] <Jarett_> are you selling the right for people to access mysql remotely?
[17:51] <CoJoNEs> it shoudlnt be listening on your public ip address at all
[17:52] <Andy298> Jarett_: im not selling anything
[17:52] <Jarett_> on a server it should only listen on 127.0.0.1 and take local connections
[17:52] <Andy298> CoJoNEs: it is listening on loopback
[17:52] <Jarett_> 3306/tcp open mysql
[17:53] <Jarett_> just like ftp, smtp, 53/tcp (which should only ever be udp on normal server
[17:53] <CoJoNEs> its listening on your public ip, I promise
[17:54] <Jarett_> Andy298, bind-address=127.0.0.1 is commented out by default on windows
[17:54] <Jarett_> go check
[17:55] <Andy298> i don't even see the line in my.cnf :S
[17:55] <Andy298> but im sure in mysqladmin it was set
[17:57] * CJB2K998 is now known as CJB2K686
[17:57] <Dark_> can someone help me with http://sql-servers.com/nopaste/?show=554 ... its giv
[17:58] <CoJoNEs> cause you have two chandb's in your query
[17:58] <Jarett_> dark_ if you reference tables one place, reference them everywhere
[17:58] <CoJoNEs> and it nees to knwo which one
[18:00] <CoJoNEs> and its bad practice to use like 'Dark_'
[18:01] <Dark_> what would be better practice ? and how can i solve this ?
[18:01] <Andy298> is it still showing as open now?
[18:02] <Jarett_> no
[18:02] <Andy298> so thats a step in the correct direction?
[18:02] <Jarett_> hows that xp firewall working for you? :P
[18:02] <Jarett_> no
[18:03] <Andy298> don't use it! :)
[18:03] <Dark_> um ?
[18:03] <CoJoNEs> now thats good thinking.
[18:04] <Andy298> anyway - i cam in here with...
[18:04] <Andy298> it will be used to log into a custom control panel as well as for their mys
[18:04] <Andy298> Jarett_: how would you suggest i append a number? and ensure that the numbe
[18:04] <Dark_> well im new so if there are alternatives .. or if u can point me in the direc
[18:04] <Jarett_> who needs a controlpanel and why?
[18:04] <Andy298> Jarett_: to manage their hosting features!
[18:05] <Andy298> FTP, mail, DNS, Vhosts, SQL
[18:05] <Jarett_> who?
[18:05] <Andy298> "them" people who are using the server
[18:05] <Andy298> companies, friends and so on
[18:05] <Jarett_> hopefully they arent paying :P
[18:05] <Andy298> of course not
[18:05] <Jarett_> good cause you would be in for a serious amount of problems :P
[18:06] <Andy298> it's an educational project for me to set up and for mates to use
[18:06] <Andy298> Jarett_: problems?
[18:06] <Jarett_> dont use windows
[18:06] <Jarett_> problems? no not for me
[18:06] <Andy298> what problems would there be though?
[18:06] <Jarett_> i am not the one who has to explain to my friends that the server was hacke
[18:07] <Andy298> no worries, i'll put them in your direction! :)
[18:07] <Jarett_> but hey.. you are the Master Creating Server Environments
[18:07] <Jarett_> wind0ws r0cks0rs
[18:07] <Andy298> who said that im the master?
[18:07] <Andy298> if i was - would i be in here?
[18:07] <Halo_Four> If you can't manage to launch a secure Windows server you don't have busi
[18:08] <Andy298> Halo_Four: i don't want a business launching any servers, this is an educat
[18:08] <Jarett_> i could have setup a linux box to do with with powerdns and any controlpane
[18:08] <CoJoNEs> Dark_ using like when you should be using = isn't proper practice
[18:08] <Dark_> ah
[18:09] <Jarett_> or 10 times over if i used one of the over 100 cpanel solutions on the web
[18:09] <Halo_Four> Particularly given that _ is a wildcard for the LIKE operator
[18:09] * NyQuil changes topic to 'If you want fair, we can start charging at the door.'
[18:09] <Dark_> alright so thats half of my question hehe now what is an alternative to my pa
[18:09] <CoJoNEs> very good point Halo_Four, I always forgot that too until it bites me
[18:09] <CoJoNEs> Dark_, I already told you <@CoJoNEs> cause you have two chandb's in y
[18:10] <Dark_> yeh why i cant do it .. how is what im looking for
[18:10] <Andy298> im off now! no hacking please guys :D
[18:11] <CoJoNEs> you need to use an alias Dark
[18:12] <Dark_> k thnx
[18:12] <Halo_Four> UPDATE supports FROM and JOIN clauses
[18:13] <TheGamble> sadly
[19:09] * NyQuil changes topic to 'If you want fair, we can start charging at the door.'
[19:11] <KNAVER> Is there any reason why in vs.net/sql 2005, i cant delete a table? I get an
[19:12] <TheGamble> does the table have a DELETE trigger?
[19:12] <KNAVER> nope, no triggers
[19:12] <TheGamble> that was quick; are you sure?
[19:12] <KNAVER> I dont know how to use triggers
[19:12] <KNAVER> And i built this whole database.
[19:13] <TheGamble> this error happens on INSERT and UPDATE; don't know why you're getting it
[19:13] <TheGamble> makes no sense.
[19:13] <KNAVER> One of the fields has a decent amount of data (about 1 full page of text). I
[19:13] <KNAVER> Well, im getting it on update as well.
[19:14] <CoJoNEs> what is the statement that causes the error?
[19:14] <KNAVER> Its not a statement. Im in the table view, and i just click the row and hit
[19:15] <KNAVER> "A problem occured attempting to delete row 1. Error Source: .Net SqlClient
[19:15] <TheGamble> heh
[19:15] <CoJoNEs> *sigh*
[19:15] <TheGamble> I don't use those toys, so I don't know
[19:18] <TheGamble> CoJoNEs, you ever see this error on a DELETE ?
[19:18] <CoJoNEs> no
[19:18] <KNAVER> I found a way to delete it... but now im going to try and replicate it
[19:20] <TheGamble> lol
[19:20] <TheGamble> KNAVER, you be sure and send me a repro script so I can tell MS
[19:21] <TheGamble> since this *doesn't* happen
[19:21] <KNAVER> well, thats if i can get it to happen again
[19:21] <KNAVER> Im trying to reproduce, but im unsure what caused the initial problem
[19:21] <KNAVER> Yeah, its now working exactly as i would expect...
[19:22] <TheGamble> perhaps your catch block put bogus text in and the error was actually thr
[19:22] <KNAVER> there was no code... i had no catch block
[19:22] <KNAVER> I had cut/pasted text earlier into the field. It was self-made text in notep
[19:23] <KNAVER> I put it into 2 fields type 'text'. When trying to modify them, it failed.
[19:23] <TheGamble> well if you can repro it, we'll get it to the right ppl
[19:23] <KNAVER> Ill try ;)
[19:23] * KNAVER is now known as Knave_
[19:23] <TheGamble> you knave, you
[19:24] <Knave_> LoL
[19:24] <TheGamble> you stole the tarts....
[19:25] <Knave_> Well got it to happen on an update....
[19:25] <Knave_> but i would have imagined a 'text' type, could hold PAGES of text...
[19:25] <TheGamble> ok
[19:26] <Knave_> i got less than 2 pages in the field...
[19:26] <Knave_> w00t created the error again
[19:27] <TheGamble> on delete?
[19:27] <Knave_> Yup, and update.
[19:27] <TheGamble> can you upload the project somewhere?
[19:27] <rmah> yar
[19:28] <TheGamble> rawr
[19:28] <Knave_> There is nothing to upload...
[19:28] <TheGamble> ?
[19:28] <Knave_> Its all be ing done within the Server Explorer of vs.net within the sql des
[19:28] <Knave_> im just using the gui tools...
[19:28] <TheGamble> ok, can you write up the repro steps?
[19:28] <TheGamble> starting from CREATE TABLE?
[19:29] <Knave_> Uhm, it would probably be easier for me to use camtasia and make a video of
[19:29] <TheGamble> ok, that'll work too; you got somewhere you can upload it?
[19:29] <Knave_> Yeah i got 15mbit at work. And im admin of my servers ;)
[19:29] <Knave_> Sadly i cant get a video made tonight of it.
[19:29] <Knave_> I need to get into the office to use Camtasia..
[19:30] <TheGamble> ok
[19:30] <Knave_> Basically all im doing is cut/pasting about 1 page of text 3x.
[19:30] <Knave_> That causes the initial update issue.
[19:30] <TheGamble> that one is understandable
[19:30] <Knave_> If i then try and just put a normal piece of text "ASDF" then it stores it
[19:31] <Knave_> When i put a page or two of data in, and it accepts it, i try and delete it
[19:32] <TheGamble> ok, so the behavior is: paste, paste, paste...click row....
[19:32] <Knave_> more or less.. yeah...
[19:32] <Knave_> im still having troubles reproducing it down to a science.. which is what im
[19:32] <Knave_> But i thought 'text' type, could hold like tens of pages of data...
[19:32] <Knave_> that is the first thing that throws me off....
[19:33] <TheGamble> does it complain when you hit the Delete key, or when you highlight the r
[19:33] <Knave_> Okay here is it exact.
[19:34] <Knave_> If i overfill it with text, it gives me the initial upload error.
[19:34] <Knave_> oos update.
[19:34] <Halo_Four> TEXT can hold 2GB. It's up to the client to actually permit it, tho.
[19:34] <Knave_> Then i right click on the row, (at the far left where it lets you select eac
[19:34] <Knave_> I then get error.
[19:34] <Knave_> Let me try a few more times, to make sure it does that exactly.
[19:34] <Halo_Four> If you're using something like Enterprise Manager to enter the data then
[19:34] <Knave_> Halo_Four: The vs.net gui im in, is much like Enterprise Manager
[19:34] <TheGamble> right, I'm trying to deduce if he is: paste, paste, paste, click off the
[19:35] <Knave_> TheGamble: I initially create the row, with just like "asdf", "asdf", "asdf"
[19:35] <Halo_Four> You probably can't copy&paste the data in raw then
[19:35] <Knave_> Its when i update it, and overfill it, that is when i get the issue to start
[19:36] <Knave_> The table has the following field types (in order). Primary Unique Key tid -
[19:36] <Knave_> Table name: Tutorials_Content
[19:36] <Knave_> Key tid = identity
[19:37] <TheGamble> put a trace on the box with profiler
[19:37] <Knave_> To get it to delete, i must change the type of view, to "Delete", then Execu
[19:37] <Knave_> Uhm let me see if i can find a profiler
[19:37] <TheGamble> you'll see what it's doing then
[19:37] <TheGamble> my bet is that after the update error, the grid is still in an error stat
[19:38] <TheGamble> gotta run an errand; bbiaw
[19:38] <Knave_> hmm, that might be it...
[19:38] <Knave_> Im going to run the queries in order, because even though its a gui, a query
[19:38] <Knave_> Ill cut/paste them in order, in a notepad
[19:38] <Knave_> in notepad.
[19:38] <Knave_> I just turned on the view that shows the sql.
[19:39] <Knave_> (i cant find the equivalent to "profiler"
[19:46] <Knave_> I have now made a more exact explanation of what is going on.
[20:09] * NyQuil changes topic to 'If you want fair, we can start charging at the door.'
[20:12] <bd_gEIGH> using db2, here's my code: http://sql-servers.com/nopaste/?show=555
[20:12] <bd_gEIGH> I get the following error: SQL0104N An unexpected token "CREATE" was foun
[20:12] <bd_gEIGH> any ideas?
[20:14] <bd_gEIGH> everything works fine when I enter the lines manually
[20:14] <bd_gEIGH> I'm using "db2 -tvf file_name"
[20:16] <bd_gEIGH> anybody here?
[20:16] <CoJoNEss> I dont know db2
[20:16] <CoJoNEss> but if I had to guess I would say it doesnt know when your statement is do
[20:16] <bd_gEIGH> yeah
[20:17] <bd_gEIGH> that's what it seems like but I can't figure it out
[20:17] <bd_gEIGH> thx for the tip...if anybody else has any ideas let me know
[20:18] <Halo_Four> Does DB2 require you to have CREATE TABLE be the first statement in a bat
[20:19] <bd_gEIGH> not that I know if...that's just what I need to do first
[20:19] * Disconnected
[20:19] * Attempting to rejoin channel #sql
[20:19] * Rejoined channel #sql
[20:19] * Topic is 'If you want fair, we can start charging at the door.'
[20:19] * Set by NyQuil!~NyQuil@nr14-66-161-196-46.fuse.net on Mon Apr 17 20:09:20
[20:19] -NyQuil- Welcome to #sql Please read these brief rules or be banned without warning:
[20:19] -NyQuil- 1) Dont ask if you can ask a question, just ask it.
[20:19] -NyQuil- 2) If you ask a database question, and dont say what database youre using (MSSQL,
[20:19] <bd_gEIGH> if your asking in regards to my question
[20:19] -NyQuil- 3) SQL Code should not be pasted in chan, please use http://sql-servers.com/nopast
[20:19] -NyQuil- 4) If we say RTFM, its because you should. For MSSQL check Books Online. Enjoy You
[20:19] -NyQuil- 5) No Homework! No MySQL!
[20:23] <ScoFF> hey guys, question...I have an access sql statement combining two select stat
[20:27] <NetStatic> what's the mssql equivalent of explain?
[20:28] <Halo_Four> Right clicking on the object in Enterprise Manager or Management Studio a
[20:28] <CoJoNEss> union wont shorten a field, it must be something else you are doing
[20:29] <Halo_Four> Could be an Accessism
[20:29] <NetStatic> i need to execute it through a vbscript
[20:29] <Halo_Four> MSSQL has no automatic scripting syntax.
[20:29] <ScoFF> if I add the all word it works fine
[20:29] <Halo_Four> Maybe it drops the Memo back down to Text in order to perform the distinc
[20:30] <NetStatic> sp_help ?
[20:31] <Halo_Four> sp_help and INFORMATION_SCHEMA tables can get you the table schema, sure.
[20:31] <Halo_Four> It's not in a CREATE TABLE format or anything.
[20:31] <NetStatic> yeah, i am just looking to list the columns in a table
[20:31] <Halo_Four> Ah yes, then that'll do it.
[20:32] <ScoFF> I have more than 250 chars in there, it's a memo right now
[20:33] <NetStatic> thnx
[20:39] <CoJoNEss> are both fields in the union memo?
[20:45] <ScoFF> yep
[20:45] <ScoFF> actually, someone helped me to not use a union query, quick fix. the 250 char
[20:46] <phargle> thats some fucked up shit
[20:49] <BlueCafe> could someone explain the notion of satisfaction in database design? or ha
[20:53] <k00> i got 3 nested select statments..they return a 2 rows..then..i nest those 3 sel
[20:59] <k00> Guess you can't use the IN keyword in conjunction with DELETE?
[20:59] <phargle> 3 seperate select statements?
[20:59] <phargle> no unioned or anything?
[21:00] <k00> nope but that dosen't matter
[21:00] <k00> i think what matters is
[21:00] <k00> im select ints ..but trying to delete entire rows
[21:00] <phargle> i uh, no you're wrong.
[21:00] <k00> ok
[21:01] <phargle> why 3 selects?
[21:01] <k00> because i need them.
[21:01] <k00> but, for debugging purposes..i only used one select
[21:01] <k00> and still, 0 rows affected.
[21:01] <phargle> you could probably do it with 1 select, but you can sit and stare at that f
[21:02] <phargle> if you use a union though, you can keep your 3 selects i guess
[21:02] <phargle> maybe
[21:02] <k00> so, it is legal to do DELETE from TBL WHERE [id] IN ( SELECT [ids] FROM tbl )
[21:02] <phargle> or you could do something like ... WHERE [id] IN (select#1) OR [id] in (sel
[21:02] <phargle> Yes.
[21:03] <k00> as i figured. don't know why it wont work
[21:03] <k00> would you mind looking at my sql code?
[21:03] <phargle> too tired atm
[21:04] <k00> It's rather simple
[21:04] <k00> but ok.
[21:05] <k00> CRAP
[21:05] <k00> !!!!!!!!
[21:05] <k00> duh!
[21:05] <k00> wrong table name.
[21:09] * NyQuil changes topic to 'If you want fair, we can start charging at the door.'
[21:51] <d2k> Question: I am trying to find the intersection of two users in a table. I am us
[21:53] <TheGamble> well, EXPLAIN in MySQL has dual use
[21:53] <TheGamble> lol i need to scroll more often
[21:54] <d2k> do I need to use a nested select statement instead?
[21:56] <TheGamble> are you k00?
[21:57] <d2k> no, I'm d2k
[21:57] <d2k> I just posted a few minutes ago
[21:57] <TheGamble> where is your post?
[21:57] <d2k> http://sql-servers.com/nopaste/?show=557
[21:58] <TheGamble> ok, the issue is that your WHERE clause evaluates to False
[21:58] <TheGamble> where User_ID = 1 and User_ID = 2 can never be true for a given row
[21:58] <TheGamble> what's the goal?
[21:59] <d2k> the goal is to find all movies user1 and user2 have rated
[21:59] <TheGamble> all movies rated both by users 1 and 2 ?
[21:59] <d2k> yes
[21:59] <TheGamble> what dbms?
[21:59] <TheGamble> Oracle was it?
[21:59] <d2k> oracle 10.4g
[22:00] <TheGamble> it would be nice if there was a movie relation
[22:00] <d2k> ?
[22:00] <d2k> I do have a movie table
[22:02] <TheGamble> select Movie.moviename from Movie where exists (select * from Rating R1 w
[22:03] <d2k> thank you, TheGamble. Let me try that out
[22:03] <TheGamble> okay
[22:04] <tenfour> bealtine you there?
[22:06] <d2k> thanks TheGamble. it worked =)
[22:06] <TheGamble> :)
[22:07] <d2k> now to apply it to the table... 1 million records, 1000 users, 3800 movies
[22:07] <TheGamble> you want all permutations?
[22:07] <d2k> no.. I think I can figure that out
[22:07] <TheGamble> that's brutal, tho
[22:08] <d2k> I'm trying to figure out similarities between users
[22:09] * NyQuil changes topic to 'If you want fair, we can start charging at the door.'
[22:10] <TheGamble> you have to manage the combinatorial issue for sure
[22:10] <d2k> the bigger picture is I'm trying to figure out the relationship between users b
[22:11] <TheGamble> yes, this is known as market basket analysis
[22:11] <TheGamble> more or less :)
[22:11] <TheGamble> it's not actually, but the science is similar
[22:12] <d2k> more or less, but I'm scared how long it will take once I execute the code ...
[22:12] <TheGamble> collaborative filtering is what you really need
[22:13] <d2k> actually.. since you seem to know what I'm doing, I'm trying to calculate the p
[22:13] <d2k> memory-based collaborative filtering
[22:14] <TheGamble> I'm looking for a good example
[22:14] <TheGamble> why not use something simpler like slope one?
[22:14] <d2k> I have the PCC equation.. it's just the problem of translating that into PL/SQL
[22:16] <TheGamble> challenging
[22:18] <d2k> I'm using PCC to create a "neighborhood" of peers who rate movies in a similar
[22:21] <TheGamble> yes, I've read the papers; I think you'll have trouble doing it in pure s
[22:24] <d2k> I'm trying to emulate the memory-based portion of the 1998 breese paper in PL/S
[22:25] <TheGamble> how about this: http://www.stanford.edu/dept/itss/docs/oracle/10g/server.
[22:25] <d2k> our dataset is from the movielens project (www.movielens.org)
[22:25] <TheGamble> built-in function CORR
[22:27] <TheGamble> I wonder if you can apply it to a list of the most oft-rated movies
[22:27] <TheGamble> and make a cartesian product on the list
[22:27] <TheGamble> this way you can prune the tree
[22:28] <TheGamble> then do movie_id, CORR(rating1, rating2); something like that
[22:30] <d2k> I wish I could talk with you longer TheGamble, but it's 1:30am and I'm a deadbe
[22:30] <TheGamble> me too :) I need to crach
[22:30] <TheGamble> s/crach/crash lol
[22:30] <d2k> night guys =)
[22:30] <TheGamble> night
[23:09] * NyQuil changes topic to 'If you want fair, we can start charging at the door.'
[23:46] <BlueCafe> could someone explain what it mean for a relation to satisfy a functional
Session Close: Tue Apr 18 00:00:00 2006