IRC Chat Logs - An Archive of EFnet IRC Channels

Session Start: Tue Aug 08 00:00:00 2006
Session Ident: #sql
[00:34] * NyQuil changes topic to 'http://sql-servers.com/nopaste || read the rules || nopaste upda
[01:06] * [1]Telari is now known as Telarian
[01:34] * NyQuil changes topic to 'http://sql-servers.com/nopaste || read the rules || nopaste upda
[01:37] <Nightinga> using mysql, hello. i want to get information the user inputs from a form
[01:38] <daniela`> or with php, or with perl, or with asp.net, or...
[01:40] <Nightinga> okay cool..
[01:56] <Trengo> bom dia
[02:08] <Immy> hi
[02:08] <Immy> im working with sqlserver2k5
[02:13] <Immy> im working on a data security strategy for a system i am developing. the data
[02:14] <Immy> im not concerned about security for data being accessed by the webserver - i'l
[02:16] <Immy> for the windows app i was thinking of the following: have a login which can ex
[02:16] <Immy> i'm loathe to store a database/user pass in a config file
[02:17] <Immy> i think i'll have a few different database logins for the windows app - one sa
[02:18] <Immy> in any case i'm after some advice and ideas
[02:30] <dfwerking> so the app itself is web based with administrative consoles accessed by w
[02:31] <dfwerking> i don't see why you wouldn't have an admin users table and have a superus
[02:32] <dfwerking> by having each admin have his own login, you have more options for tracki
[02:32] <dfwerking> having a global admin and a global sales, etc, account is a poor idea in
[02:32] <Immy> so basically i need a database login for each employee?
[02:32] <dfwerking> that makes the most sense to me
[02:33] <dfwerking> then you assign sp perms based upon the group they belong to
[02:33] <dfwerking> not to the individual
[02:33] <Immy> i guess that does make the most sense
[02:34] <Immy> i guess storing a single database connection string in the .net app is out of
[02:34] * NyQuil changes topic to 'http://sql-servers.com/nopaste || read the rules || nopaste upda
[02:35] <dfwerking> i don't do .net, but i can see a number of ways to accomplish this
[02:35] <dfwerking> you could have users in the db, admin, sales, whatever
[02:35] <dfwerking> each has their rights set
[02:36] <dfwerking> actually nevermind, barking up the wrong tree
[02:37] <dfwerking> sorry, i do strictly web apps where managing this is easier
[02:38] <Immy> me too up until now
[02:38] <dfwerking> not sure how you can deal with individual logins via a .net app and not h
[02:45] <dfwerking> is the .net app already done?
[02:46] <dfwerking> kind of wondering why you went that way since you'd need an ACL for each
[02:46] <dfwerking> CAL
[02:52] * xorian` is now known as xorian
[03:34] * NyQuil changes topic to 'http://sql-servers.com/nopaste || read the rules || nopaste upda
[03:39] * suv4x4 is now known as judomagic
[04:24] <tikskarb> Hi, i am new to SQL, I am using MSSQL, I want to select 1 if a column is n
[04:24] <tikskarb> I ment 0 if it is not null...
[04:34] * NyQuil changes topic to 'http://sql-servers.com/nopaste || read the rules || nopaste upda
[04:39] <dfwerking> tikskarb, SELECT stat_fork = (CASE stat_fork WHEN IS NULL THEN 0 ELSE 1 E
[04:39] <dfwerking> reverse the values
[04:40] <dfwerking> a more efficient way is ISNULL()
[04:40] <dfwerking> but may not work depending on your column values
[05:19] <threadw> in mssql2k5, how can I select all rows from a table where its ID does NOT e
[05:22] <Jarett> not exists
[05:22] <Jarett> not in
[05:22] <Jarett> intersect or minus
[05:25] <limar> does anyone have a link checker they like to use?
[05:25] <Jarett> google.com
[05:25] <limar> google.com
[05:34] * NyQuil changes topic to 'http://sql-servers.com/nopaste || read the rules || nopaste upda
[05:42] * Smegmatta is now known as Smegmata
[05:54] <icnocop> executing a stored procedure results in the following profile: cpu: 16, rea
[05:54] <icnocop> i am not sure how i can make the sproc faster
[05:55] <Jarett> dont make it an sproc
[05:56] <Jarett> do it with 1 simple query
[05:58] <icnocop> why would i not want to make it a stored procedure? stored procedures are
[05:58] <icnocop> mssql
[05:58] <icnocop> http://sql-servers.com/nopaste/?show=971
[05:59] <Jarett> why do people assume that encapsulating a query in crap with extra crap spri
[06:00] <icnocop> Jarett, stored procedures are compiled.
[06:00] <Jarett> yeah that makes poorly written queries much better
[06:01] <icnocop> are you referring to only poorly written queries or all queries?
[06:01] <Jarett> all
[06:01] <Jarett> because if it was written by an sp favoring MS developer it IS poorly writte
[06:01] <icnocop> so you are saying that all queries are faster than stored procedures?
[06:02] <icnocop> stored procedures are more secure
[06:02] <Jarett> im saying that stupidity like assuming compiled is faster leads to bad queri
[06:03] <Jarett> no they are not
[06:07] <icnocop> so are you saying that stored procedures are good for nothing?
[06:07] <icnocop> or are you just projecting on stereotypes/assumptions?
[06:08] <icnocop> i thought there was some cache involved with stored procedures
[06:08] <Jarett> you are the one complaining about horriblely slow SPs
[06:09] <Jarett> theres cache with queries too
[06:09] * __ismell is now known as ismellWRK
[06:10] <icnocop> no, i didn't say my sp was slow. i wanted to know if i can improve the per
[06:10] <Jarett> by writting better queries
[06:10] <icnocop> most everything i've read tells me to use stored procedures
[06:10] <Jarett> because the whole fact that its an SP is irrelevant
[06:11] <Jarett> i bet it does
[06:11] <Jarett> its a rouse
[06:11] <Jarett> a false sense of security
[06:11] <Jarett> like a windows login prompt
[06:12] <Trengo> Jarett you oracle rjarett?
[06:15] <Jarett> Was that a sentence?
[06:18] <icnocop> so jarett, i am now thinking of creating several test cases to observe the
[06:18] <Trengo> Jarett was a question :P let me rephrase that: "Jarett, are you oracle's RJa
[06:19] <Jarett> icnocop, no i think you need to rewrite your query
[06:19] <Jarett> yes
[06:19] <Trengo> Jarett great :)
[06:19] <Jarett> this is a dead giveaway: * [Jarett] #oracle
[06:19] <Trengo> icnocop listen to Jarett, he knows what he's saying
[06:20] <icnocop> jarett, so you have looked at my sql paste and noticed something that can b
[06:20] <Trengo> Jarett might be, but i don't see that
[06:20] <Drk`Angel> Compilation time is negligable for a query, unless you're a total tard th
[06:20] <Drk`Angel> (And are running the query in a loop a few thousand times)
[06:20] <Jarett> i was actually impressed with your use of union
[06:21] <Jarett> usually MSers are violently against union, minus and intersect
[06:21] <dfworking> bah
[06:21] <Jarett> they feel it is below them to write tiny code.. instead of 30 sets of joins
[06:21] <dfworking> icnocop, don't subscribe to the false assumption that sp's are faster bec
[06:21] <Jarett> "my 30 joins are much more efficient.. since in theory it only pulls a small
[06:22] <dfworking> you should view sp's as ways of encapsulating more complex logic, not as
[06:23] <Drk`Angel> I wonder how all of these stupid assumptions get started.
[06:23] * Drk`Angel shrugs.
[06:23] <icnocop> ok, these are all interesting points ;) thank you
[06:23] <Jarett> Drk`Angel, MCSE and MSDBAs
[06:23] <dfworking> i think it was true in like 6.5 or something
[06:23] <Jarett> they are the same damn points i said :P
[06:23] <dfworking> but not for many years
[06:23] <dfworking> yes, but i'm a lot less sarcastic and annoying
[06:23] <dfworking> so i garner more listener good will
[06:23] <Jarett> why must people hear something with butt kissery before they accept it?
[06:24] <Drk`Angel> Jarett: I've met pleanty of stupid Oracle developers too.
[06:24] <Jarett> Drk`Angel, yes
[06:24] <Jarett> they are the same breed
[06:24] <Jarett> plsql/procedure lovers
[06:24] <Jarett> i work with plenty myself
[06:24] <Jarett> thats why ive banned procedures at work
[06:25] <dfworking> didn't they like vote you in as their overlord?
[06:25] <Drk`Angel> Eh, that's a bit over the top. Just shoot anyone that decides that every
[06:25] <Jarett> dfworking, no i took that role myself
[06:25] <Jarett> overlords must userp authority
[06:25] <dfworking> ah, fool of the kings or king of the fools, its a tough one to choose
[06:27] <Rizzar4> pwnd
[06:28] <Jarett> emos say pwnd.. and emos are fags
[06:28] <icnocop> jarett, you said that i need to rewrite my query. is there something speci
[06:28] <dfworking> there are like no vowels in that word
[06:28] <dfworking> icnocop, iirc, the best changes you can make you can't, since you said yo
[06:29] <dfworking> its those fucking left outer joins that would do well to be avoided
[06:29] * dfworking is now known as dfwbbiaf
[06:30] <Rizzar4> you = pwnd
[06:30] <Jarett> id even rather see this be a handful of queries in an if statement
[06:31] <Jarett> because you can save yourself alot of query time if you stop after pulling u
[06:31] <Jarett> or if they dont exist stop after group settings
[06:32] <Jarett> id be surprised if the coalesce handled it enough to tell it to stop running
[06:34] * NyQuil changes topic to 'http://sql-servers.com/nopaste || read the rules || nopaste upda
[06:36] <icnocop> hmmmm
[06:40] <Jarett> but i dont know the output or cardinality of the user/group/defaults
[06:40] <Jarett> so its hard to say
[06:41] * Disabuse_ is now known as Disabuse
[06:41] <Halo_Four> Does the query show one setting or all of the settings?
[06:42] <icnocop> it shows all settings
[06:43] <Jarett> got user, group, default?
[06:45] <icnocop> yes, the query combines the settings from all three types in their respecti
[06:45] <Jarett> ahh
[06:46] <Jarett> and inner joins didnt work?
[06:48] <icnocop> let me try inner joins...
[06:51] <icnocop> no inner joins did not work because they do not include group only settings
[07:24] * dfwbbiaf is now known as dfworking
[07:27] <technix> can some one help me with grouping i'm having some issues with thinking thi
[07:30] <icnocop> technix, where is your sql statement?
[07:32] <Drk`Angel> select * from table t join (select orderid, max(timestamp) ts from table
[07:34] <technix> way awsome drk, works perfect
[07:34] * NyQuil changes topic to 'http://sql-servers.com/nopaste || read the rules || nopaste upda
[07:34] <dfworking> that was a helluva guess man
[07:34] <Drk`Angel> oh, I missed the id column
[07:35] <Drk`Angel> Be easier to just join on that, probably.
[07:35] <technix> i can handle that
[07:35] <technix> i still got to join a few more tables to it
[07:35] <Drk`Angel> Off to stupid meeting.
[07:35] <Drk`Angel> I hate meetings.
[07:36] <phargle> meetings are the reason i wake up in the morning
[07:37] <dfworking> erections are my reason
[07:37] <phargle> otherwise i'd get to sleep later
[07:37] <phargle> :(
[07:37] <dfworking> me too!
[07:37] <phargle> lol
[07:38] <CoJoNEsX> wow.
[07:50] <lmnt> damn erections
[08:07] * SBrick looks for mute/coj/etc
[08:09] <CoJoNEsX> ?
[08:11] <SBrick> y0
[08:12] <SBrick> did you know anheiser-busch actually sent letters to STOP hosting "real amer
[08:12] <SBrick> though found one on youtube which was pretty funny
[08:14] <CoJoNEsX> those things are funny
[08:14] <CoJoNEsX> bastards
[08:15] <Drk`Angel> "Please, stop giving us free publicity by showing people our commercials.
[08:34] * NyQuil changes topic to 'http://sql-servers.com/nopaste || read the rules || nopaste upda
[08:42] <SBrick> well they (anheiser-busch) released CDs containing the songs
[08:42] <SBrick> i suspect they didn't want to undercut their sales (stupid)
[08:48] <martha_33> i have a problem with openxml in sql server 2k. i pasted a dummy code at
[08:48] <martha_33> anyone used openxml succesfully?
[08:49] <phrostix> Say I have 2 tables. Each of them contain their own UID. However I need to
[08:50] <CoJoNEsX> insert into table1 (co1, col2, col3) (select co1, col2, col3 from tableb)
[08:50] <martha_33> yup that's it
[08:51] <phrostix> just ignore AUTO_INCREMENT fields etc correct ?
[08:52] <slip> alright, how would i go about using inner join to join more than one table
[08:52] <martha_33> so , who is using sql server?
[08:52] <Arrakis> ms sql ?
[08:52] <martha_33> yeah
[08:52] <martha_33> arrakis: are yo u using ms sql? have done openxml succesfully?
[08:53] <Drk`Angel> slip: The same way you use it to join one table.
[08:56] <John334> Is there a way I can get all the records after the first day in the current
[08:56] <martha_33> i have a problem with openxml in sql server 2k. i pasted a dummy code at
[08:56] <John334> but I want it to automatically know what the first day in this year is, not
[08:57] <martha_33> anyone used openxml succesfully?
[08:58] <CoJoNEsX> martha_33 are you planning on asking every 5 mins?
[08:58] <CoJoNEsX> John334 which rdbms?
[08:58] <Arrakis> its every 3 minuts 27 seconds
[08:58] <Arrakis> to be exact
[08:58] <martha_33> no, i won't ask after i get an answer
[08:59] <Arrakis> hahaah
[08:59] <Arrakis> gg pwnt
[08:59] <CoJoNEsX> maybe no one here right now knows the answer.. relax.. take a deep breath.
[09:00] <phrostix> CoJoNEsX: I actually said it wrong. Its one table called 'userdata'. Insid
[09:01] <CoJoNEsX> its still the same concept phrostix
[09:01] <phrostix> how do you say its a UID inside the SQL Stament?
[09:02] <CoJoNEsX> uh.. what?
[09:02] <martha_33> http://support.microsoft.com/?kbid=279434 - does this say what i think it
[09:03] <martha_33> i mean intermediaary table
[09:03] <dfworking> martha, yes i believe thats correct
[09:04] <dfworking> just shove it into a temp table
[09:04] <phrostix> CoJoNEs: like.. insert into userdata (tp_ListID, text) values('{guid here}
[09:04] <Arrakis> maybe its because
[09:04] <Arrakis> its not a valid ? unique id?
[09:05] <Drk`Angel> Ditch the curly braces.
[09:06] <Arrakis> no
[09:06] <Arrakis> i like the curly braces
[09:06] <Arrakis> and they like me
[09:06] <Arrakis> we're going to get elopedand theyres nothing youcan do about it
[09:06] <Drk`Angel> Arrakis: Nothing likes you.
[09:06] <Drk`Angel> They're just lying to you. After your money.
[09:06] <Arrakis> :(
[09:06] * Arrakis jumps off of a 17 terabyte sql server
[09:06] <Arrakis> GOOD BYE CRUEL WORLD
[09:07] * Drk`Angel throws confetti
[09:08] <Drk`Angel> phrostix: The first thing you should have done was look up constants in t
[09:08] <Arrakis> that would require effort
[09:08] <Arrakis> amnd intelligence
[09:08] <Arrakis> \sand ingenuity
[09:08] <CoJoNEsX> effort is for hosers
[09:08] <Arrakis> but most importanetly effort
[09:08] <Arrakis> exactly]
[09:08] <CoJoNEsX> im getting lunch..
[09:08] <Arrakis> hmm
[09:08] <Arrakis> i can pretend like im getting lunch
[09:08] <Arrakis> bbl
[09:08] <Drk`Angel> I already ate lunch.
[09:08] <Drk`Angel> It kinda sucked.
[09:09] <martha_33> in sql server there is only one instance of a sproc executing at one time
[09:09] <Arrakis> i have these 4 dollar bills in the back of my jersey
[09:09] <Arrakis> and they're annoying the fuck out of me
[09:11] <martha_33> if you want to use a temp table - one is enough, right?
[09:12] <Arrakis> that depends
[09:12] <Arrakis> is this 25 questions?
[09:14] <phargle> no the homework only has 10 questions
[09:17] <martha_33> http://www.microsoft.com/technet/abouttn/flash/tips/tips_033005.mspx says
[09:17] <Drk`Angel> It wouldn't be very useful in a multiuser environment if people had to wa
[09:18] <martha_33> well yeah
[09:18] <martha_33> but if you modify the data at the same time you can corupt it
[09:19] <Drk`Angel> Thats what transactions are for.
[09:19] <Drk`Angel> And locking.
[09:20] <martha_33> so transactions enable you to use only one temp table for all instances o
[09:20] <martha_33> am i correct?
[09:20] <Drk`Angel> er, no, sql server takes care of that anyways.
[09:20] <Drk`Angel> temp tables are unique to the session that created them.
[09:20] <martha_33> yeah if i create it and drop it on the spot
[09:20] <Drk`Angel> You don't have to drop it.
[09:21] <Drk`Angel> It goes away when the session closes.
[09:23] <martha_33> i love temporary tables :)
[09:24] <martha_33> so is passsing arrays as xml to sql server good for scalability?
[09:26] <CoJoNEsX> xml is overrated
[09:27] <Drk`Angel> Why do you want to use xml for?
[09:27] <martha_33> cojonesX: so you would rather use a table?
[09:27] <martha_33> i want to pass arrays as parameters
[09:28] <martha_33> there is no array data structure in sql server. you can go arround it usi
[09:29] <PoseFant> I always wondered what that number means. Either your age or your year of
[09:29] <martha_33> you could always store the data somehow in a table
[09:29] <martha_33> wich solution would you choose?
[09:30] <PoseFant> Well, since I'm kinda kinky myself, it wouldn't matter
[09:30] <martha_33> is xml slow?
[09:30] <PoseFant> oh nm lol
[09:30] * PoseFant is outa here
[09:33] <PoseFant> martha: http://www.sommarskog.se/arrays-in-sql.html
[09:34] * Drk`Angel eyes PoseFant
[09:34] <Drk`Angel> KinkyChick17, huh? I don't even want to know what other channels you're
[09:34] * NyQuil changes topic to 'http://sql-servers.com/nopaste || read the rules || nopaste upda
[09:34] <PoseFant> not a secret, #MILF
[09:34] <PoseFant> ok j/k
[09:34] <PoseFant> tata
[09:35] <PoseFant> hm I wonder
[09:35] <PoseFant> @@ array http://www.sommarskog.se/arrays-in-sql.html
[09:35] <PoseFant> @ array
[09:35] <NyQuil> No match found for array
[09:36] <CoJoNEsX> @= array http://www.sommarskog.se/arrays-in-sql.html
[09:36] <PoseFant> @@array http://www.sommarskog.se/arrays-in-sql.html
[09:36] <NyQuil> Added key array
[09:36] <PoseFant> @ array
[09:36] <NyQuil> array = http://www.sommarskog.se/arrays-in-sql.html
[09:36] <CoJoNEsX> :)
[09:36] <PoseFant> re-tata :)
[09:36] <CoJoNEsX> to add a key its @=.. to append its @+
[09:36] <CoJoNEsX> or for help jsut type @
[09:37] <Drk`Angel> I hate headaches.
[09:40] <martha_33> http://www.sommarskog.se/arrays-in-sql.html - good article. i don't agre
[09:41] <martha_33> xml parsers are fast.. i believe they're faster than a normal string
[09:44] <martha_33> anyway gotta go , bye guys
[10:15] <Jarett> mmm wendys chili
[10:15] <Jarett> but they stiffed me on the frosty. 3/4 full cup
[10:20] <phargle> i saw they have vanilla frosty's now
[10:20] <slip> what would be the proper syntax for multiple join statements?
[10:21] <Jarett> and
[10:21] <slip> alrite ill try that, ill be back when it doesnt work :O
[10:22] <Rejected> mssql is for noobs like Arrakis
[10:22] <Halo_Four> He told you.
[10:23] <Arrakis> heh
[10:23] <Arrakis> he started arguing how php
[10:23] <Arrakis> runs perfectly on lwindows
[10:23] <Arrakis> and doesnt have any bugs
[10:23] <Arrakis> and then how windows sucks
[10:23] <Arrakis> and how bsd is better then linux
[10:23] <Arrakis> and on and on and on
[10:23] <Jarett> better than asp :P
[10:23] <Jarett> bsd sucks
[10:23] <Arrakis> lmao
[10:23] <Arrakis> and im all LIKE WE DONT FUCKING CARE!
[10:23] <Jarett> bsd'ers are whiney
[10:23] <Jarett> especially about not getting funding
[10:24] <Jarett> i love seeing SSH corp at conferences
[10:24] <Jarett> "yeah you casn use openssh and other bsd stuff, but itsucks and is slow and
[10:24] <Rizzar4> that reminds me, i need to sign up for iForum
[10:26] <Arrakis> iForums
[10:26] <Arrakis> forums brought to you by the Mac where nobody is allowed to be angry as it
[10:27] <Rizzar4> haha
[10:27] <Rizzar4> luckily its not mac related
[10:28] <Arrakis> ur ruining my joke :(
[10:28] <IdiosMach> When you create a foreign key in MSSQL, the underlying constraint has the
[10:28] <Rizzar4> sorry
[10:28] <Arrakis> DF ?
[10:28] <EyePulp> Districto Federale?
[10:28] <Arrakis> Damn Foreigners
[10:28] <Jarett> Designed to Fail
[10:29] <phargle> dumb fuck
[10:29] <Arrakis> lmao
[10:29] <Arrakis> well duh
[10:29] <Arrakis> why didnt i think of that
[10:29] <phargle> DF_phargle
[10:29] <EyePulp> Dastardly Frogs?
[10:29] <phargle> defrost
[10:29] <Arrakis> dead fucker
[10:29] <EyePulp> DeForrest Kelly?
[10:29] <EyePulp> name the show!
[10:32] <IdiosMach> Alright, besides the DF question...does anyone know how to determine whic
[10:32] <Arrakis> theres probalby something in the schema for that
[10:32] <Arrakis> id check bol or google or query profiler
[10:33] <IdiosMach> I looked breifly and didn't see anything stand out, so I thought I'd ask.
[10:34] * NyQuil changes topic to 'http://sql-servers.com/nopaste || read the rules || nopaste upda
[10:38] <syth> I have a query that is "UPDATE Delivery set paid = 'TRUE' WHERE id IN (607084,
[10:39] <syth> or should I ask in #php ?
[10:39] <EyePulp> probably should try php, as that's where your problem appears to be.
[10:39] <SBrick> ugh... talk about annoying... drive from lunch to the gas station for some s
[10:39] <EyePulp> won't turn over?
[10:39] <EyePulp> or grinds?
[10:40] <SBrick> clicks
[10:40] <SBrick> won't turn over
[10:40] <phargle> try jumping from battery to solenoid, or to starter
[10:40] <SBrick> well... noticed a few thigns
[10:40] <Jarett> syth, are you escaping the ' or "?
[10:40] <EyePulp> hrm... sure your battery is cool?
[10:40] <SBrick> battery's + side is corroting to fuck (i think it popped the safety cover of
[10:41] <SBrick> and before long i'd drained the battery trying to start it (noticable when t
[10:41] <SBrick> then coworker arrived and i tried to jump it, battery seemed to be ok (windo
[10:42] <SBrick> clicking sounds like it's coming from the starter
[10:43] <EyePulp> how old is the battery? It would be cheaper to replace it (as it sounds li
[10:43] <EyePulp> er, "though"
[10:43] <SBrick> old ass battery, i've got another battery for it as is
[10:43] <syth> Jarett: replied in pm
[10:43] <EyePulp> Optima Dry cell?
[10:43] <EyePulp> =)
[10:44] <Jarett> syth, do you know what vi is?
[10:44] <syth> yep
[10:44] <EyePulp> heh
[10:44] <EyePulp> painful
[10:44] <Jarett> ok open that up in vim enhanced
[10:44] <Jarett> and does the crap like 'TRUE' look red or a different color?
[10:45] <syth> hand on a sec... need to ssh in
[10:46] <Jarett> because #1 mysql sucks and we dont care about it here. and #2 its probably
[10:47] <syth> don't think so, it all shows the right colors in BBEdit (everything inside the
[10:48] <Jarett> and your ' show up in the echo?
[10:48] <syth> yep
[10:48] <Jarett> does it error or just not do anything?
[10:48] <syth> no error
[10:49] <liquified> hey
[10:49] <Jarett> are you reporting your errors out?
[10:49] <syth> good question....
[10:50] <syth> for php, yes
[10:50] <liquified> msSql2k: How can i select (valueA from table1 - valueB from table1) as
[10:51] <Arrakis> how many rows would it return?
[10:51] <liquified> i do a select valueA where id=1
[10:51] <Arrakis> actaully
[10:51] <liquified> so, one row
[10:51] <Arrakis> select a - b
[10:51] <Arrakis> or do youwant to sum a up
[10:51] <Arrakis> and sum b up and then subgract?
[10:52] <liquified> the no-paste gives a 404
[10:52] <liquified> http://rafb.net/paste/results/f4beXA10.html
[10:52] <liquified> that's my query
[10:53] <Arrakis> i dont get
[10:53] <Arrakis> why youre creating a temp table for that
[10:53] <Arrakis> rofl
[10:53] <liquified> i want to return maxValue and the difference between the two results.
[10:53] <liquified> i know it's a WTF.. but sql aint my thing
[10:53] <Arrakis> you know you can do sub queries in #sql right
[10:54] <EyePulp> hey liq what up.
[10:54] * liquified waits for his sql to show up on theDailyWtf :/
[10:54] <liquified> he EyePulp
[10:54] <liquified> how's your mom
[10:54] <liquified> say hello from me
[10:56] <liquified> anyway, i get the totalPageCount and publishedPageCount now. But i want P
[10:57] <EyePulp> liq: start with this
[10:58] <EyePulp> oops, forgot a comma
[10:58] <EyePulp> start of line 4
[10:59] <syth> ah... ok, enabled mysql error reporting and now getting an error, so that's go
[11:02] <syth> cool, that's sorted. Thanks for the pointer Jarett
[11:02] <liquified> eye?
[11:03] <EyePulp> yo
[11:34] * NyQuil changes topic to 'http://sql-servers.com/nopaste || read the rules || nopaste upda
[11:51] <Ragnarok> [MoZ] http://zoulcreations.com/
[12:09] <lonetron> this is my connectoin string to oracle but how do i conver it into a sqlpl
[12:12] <Drk`Angel> set up your tnsnames connection, then sqlplus user/pass@db
[12:12] <Drk`Angel> You must be new to oracle :p
[12:12] <Drk`Angel> And have issues reading the documentation.
[12:28] <Darken> *cry*
[12:34] * NyQuil changes topic to 'http://sql-servers.com/nopaste || read the rules || nopaste upda
[13:34] * NyQuil changes topic to 'http://sql-servers.com/nopaste || read the rules || nopaste upda
[13:41] * _|0| is now known as |0|
[14:17] <MarkP> If I have an insert trigger, how can I prevent the data from being inserted?
[14:18] <CoJoNEsX> im pretty sure you cant without throwing an error
[14:18] <Halo_Four> ROLLBACK TRANSACTION
[14:21] <GuntherX> don't use triggers in the first place
[14:21] <MarkP> Why?
[14:22] <GuntherX> why use them? why not just have a better design?
[14:23] <MarkP> Trust me, I would love to have a better design. I would be absolutly filled w
[14:26] <MarkP> When I can find time, I'm building one
[14:27] <MarkP> In the meantime, I have to deal with this PoS
[14:34] * NyQuil changes topic to 'http://sql-servers.com/nopaste || read the rules || nopaste upda
[14:41] <SpOrTs> greetings..
[14:41] <MarkP> Salutations
[14:42] <MarkP> I think this IP capture is stopping these damn spammers
[14:43] <CoJoNEsX> ?
[14:44] <Arrakis> Cojones
[14:44] <CoJoNEsX> Arrakis?
[14:44] <Arrakis> dont mind me
[14:45] <CoJoNEsX> I havent so far
[14:45] <Arrakis> Vista
[14:45] <Arrakis> kay
[14:45] <MarkP> I have a bunch of sites where people enter in thier information, and a bunch
[14:45] <Arrakis> should use something a tad more intelligent
[14:45] <Arrakis> like image verification :p
[14:45] <MarkP> Yeah, but I was in a hurry
[14:45] <CoJoNEsX> still its better then nothing :)
[14:45] <Arrakis> lol true dat
[14:46] <MarkP> Besides, I don't think it was scripts doing it. Probably a chinese sweatshop
[14:46] <Arrakis> rofl
[14:47] <Arrakis> thats almost sad
[14:47] <CoJoNEsX> fucking chinese and their sweatshops
[14:47] <SpOrTs> I am trying to implement a clickstream data warehouse in MS SQL. I have a ta
[14:48] <Smegmata> [MoZ] http://zoulcreations.com/
[14:48] <Ragnarok> [MoZ] http://zoulcreations.com/
[14:48] <Zo|oft0> [MoZ] http://zoulcreations.com/
[14:48] <NyQuil> [MoZ] http://zoulcreations.com/
[14:48] <MonkeyPox> [MoZ] http://zoulcreations.com/
[14:48] <CoJoNEsX> select min(datecol) as starttime, max(datecol) as endtime, session from ta
[14:48] <MarkP> wtf?
[14:48] <CoJoNEsX> group by session
[14:48] <CoJoNEsX> wow thats annoying
[14:49] <___XXX_X_> these operators... :) ahhahaah
[14:49] <Arrakis> yeah that is
[14:49] <Arrakis> it was bad enough when it was one
[14:49] <Arrakis> but now its like 5 of them go off - wtf
[14:50] * MarkP puts zoulcreations on his list of sites NEVER to go to
[14:50] <SpOrTs> CoJoNEs: thanks.. i'll give it a try :)
[14:51] <SpOrTs> CoJoNEs: will i have a problem if the datecol is of VARCHAR type instead of
[14:51] <MarkP> btw, what exactly is wrong with triggers? Seems to me like something pretty u
[14:51] <sofisma> ? Seems to me like something pretty useful
[14:51] <CoJoNEsX> difficult to maintain
[14:51] <MarkP> hmm
[14:52] <CoJoNEsX> commonly causes problems on import/export/backup/restore
[14:52] <CoJoNEsX> hard to trace when you get errors
[15:04] <lonetron> is there any way to get oracle sqlplus without installing a local oracle d
[15:05] <CoJoNEsX> just install the oracle client
[15:07] <CoJoNEsX> http://www.oracle.com/technology/software/products/database/oracle10g/htdo
[15:07] <NyQuil> http://tinyurl.com/ev36x
[15:07] <phargle> sqlplus is great
[15:07] <phargle> i especially like the way the cursor keys work
[15:09] <CoJoNEsX> heh
[15:11] <kexmex> shut your pie hole
[15:12] * CoJoNEsX shoves my foot into kexmexs bum
[15:31] * sornman_ is now known as sornman
[15:34] * NyQuil changes topic to 'http://sql-servers.com/nopaste || read the rules || nopaste upda
[15:55] <kexmex> buncha jizzers
[16:21] <TheSiege> ok can you tell me if this is possible, im using mysql and i want people t
[16:23] <Jarett> TheSiege, use google maps pedometer
[16:23] <Jarett> and goto #mysql
[16:24] <TheSiege> im in mysql but the chan topic did say i could ask in here
[16:24] <Jarett> the rules here says you cant
[16:24] <kexmex> suck cock jared
[16:25] <Jarett> how can you be such an idiot that you cannot spell a name right in front of
[16:25] <Jarett> on top of that... you have nickcomplete
[16:25] <kexmex> yer name is jared mate :)
[16:25] <TheSiege> i just want it to display the text i dont want a visual of it with gmap pe
[16:25] <Jarett> last time i looked at my license, it wasnt
[16:26] <Jarett> TheSiege, sum()
[16:26] <kexmex> jarred jarred jarred
[16:26] <kexmex> lawl
[16:26] <kexmex> just messing with u
[16:26] <Jarett> do the math
[16:26] <kexmex> i got a headache
[16:27] <TheSiege> im aware of the sum fuction, im just not sure how to incorporate it with p
[16:28] <Jarett> well php has math functions
[16:29] <phargle> no way, thats crazy
[16:29] <phargle> wtf do people have calculators for
[16:29] <TheSiege> hmmm
[16:34] * NyQuil changes topic to 'http://sql-servers.com/nopaste || read the rules || nopaste upda
[16:53] <Arrakis> lolz
[17:18] <TheSiege> whats wrong with this mysql
[17:18] <TheSiege> http://sql-servers.com/nopaste/?show=977
[17:27] <wasabi_> Probably where you say SUM * which is meaningless.
[17:27] <wasabi_> Also, maybe the `'s around names.
[17:27] <wasabi_> Unsure on that one though
[17:27] <wasabi_> Also, name_1 doesn't seem to mean anything.
[17:28] <wasabi_> Also, rread the rules.
[17:31] <TheSiege> http://sql-servers.com/nopaste/?show=978 name_1 is like bob so id be l
[17:34] * NyQuil changes topic to 'http://sql-servers.com/nopaste || read the rules || nopaste upda
[18:34] * NyQuil changes topic to 'http://sql-servers.com/nopaste || read the rules || nopaste upda
[18:53] * Disconnected
[18:53] * Attempting to rejoin channel #sql
[18:53] * Rejoined channel #sql
[18:53] * Topic is 'http://sql-servers.com/nopaste || read the rules || nopaste updated || 'gui' is
[18:53] * Set by NyQuil!himmler@EV-ESR1-72-49-119-80.fuse.net on Tue Aug 08 18:34:45
[18:53] -NyQuil- Welcome to #sql Please read these brief rules or be banned without warning:
[18:53] -NyQuil- 1) Dont ask if you can ask a question, just ask it.
[18:53] -NyQuil- 2) If you ask a database question, and dont say what database youre using (MSSQL,
[18:53] -NyQuil- 3) SQL Code should not be pasted in chan, please use http://sql-servers.com/nopast
[18:53] -NyQuil- 4) If we say RTFM, its because you should. For MSSQL check Books Online. Enjoy You
[18:53] -NyQuil- 5) No Homework! No MySQL!
[19:34] * NyQuil changes topic to 'http://sql-servers.com/nopaste || read the rules || nopaste upda
[19:45] <rmah> yar
[19:56] <rmah> hello?
[20:16] * ismellWRK is now known as ismellHW
[20:17] <Darken> the sound of one hand clapping
[20:18] <rmah> hi darken
[20:21] <Darken> hey
[20:21] <Darken> i went to sea world tonight, again what a useless place
[20:22] <rmah> kids dig it
[20:22] <Darken> i don't see why
[20:23] <rmah> they like shiny fish
[20:24] <rmah> at least my 3 yr old niece does
[20:26] <Darken> ah
[20:27] <rmah> and she just *loves* nemo (no surprise there probably)
[20:28] <Darken> ya
[20:29] <rmah> so I have a new keyboard (again)
[20:29] <rmah> this is the third one in a year
[20:32] <Darken> stop spilling special sauce all over them
[20:34] <rmah> you're nasty
[20:34] * NyQuil changes topic to 'http://sql-servers.com/nopaste || read the rules || nopaste upda
[20:35] <phargle> did you gui them?
[20:36] <Arrakis> rofl
[20:37] * Arrakis finds Nemo
[20:39] * rmah shakes head in bewilderment
[20:43] * Arrakis shakes rmah in bewilderment
[20:43] <Arrakis> WHERS NEMO! WEHERES NEMO!
[20:49] <phargle> lol
[21:10] <dmitry> how do I have mysqldump not append a ' DEFAULT CHARSET=latin1;' to my CREATE
[21:10] <dmitry> because its not being imported correctly because of that
[21:11] <dmitry> it just throws an error saying invalid sql
[21:24] * Rav3n^AFK is now known as Rav3n^
[21:26] <Darken> dmitry the rules say no mysql
[21:26] <Rav3n^> Using MSSQL, could anyone tell me a way to convert a number into a month nam
[21:29] <Rav3n^> Got an old database that I can't change, it's storing dates as varchars in t
[21:29] <Rav3n^> could anyont give me some pointers on how I can convert those three strings
[21:30] <Rav3n^> I've tried convert datetime, but because months are missing leading zeros, i
[21:34] * NyQuil changes topic to 'http://sql-servers.com/nopaste || read the rules || nopaste upda
[21:38] <dmitry> Darken: are you prejudice against MySQL?
[21:38] <dmitry> are you a database racist?
[21:38] <dmitry> nerd.
[21:38] <Darken> tonight isn't the night to randomly pick me to say stupid things to
[21:39] <Darken> Rav3n^ you can pad strings with zeros if you desire
[22:00] * Rav3n^ is now known as Rav3n^AFK
[22:02] <Nineth> MSSQL: how can I export a DTS package from one sql server to another? (no co
[22:34] * NyQuil changes topic to 'http://sql-servers.com/nopaste || read the rules || nopaste upda
[22:37] <Arrakis> Nineth saev it?
[22:37] <Arrakis> and then load it?
[22:38] <Nineth> save it....
[22:38] <Nineth> let me check.
[22:40] <Nineth> :) how to save?
[23:07] * Zo|oft0 is now known as Zoloft
[23:34] * NyQuil changes topic to 'http://sql-servers.com/nopaste || read the rules || nopaste upda
Session Close: Wed Aug 09 00:00:00 2006