IRC Chat Logs - An Archive of EFnet IRC Channels

Session Start: Sat May 06 00:00:00 2006
Session Ident: #sql
[00:26] <AcidX> I am using Postgres. In one of my tables I have a column of type 'timestamp w
[00:30] <Lagged__> helllo ppl, i have a MSAccess Database and i need to store "Long" Asccii
[00:30] <Lagged__> ??
[00:36] * NyQuil changes topic to 'http://sql-servers.com/nopaste || If you want fair, we can start
[01:36] * NyQuil changes topic to 'http://sql-servers.com/nopaste || If you want fair, we can start
[01:51] <mainproc> Hi
[01:53] <mainproc> if i have 2 tables let say ppl(with number of hairs) and heights, how do i
[02:30] <Reese2199> when you insert a new row, do you need to call commit on your transaction
[02:31] * pushgone is now known as _pusher_
[02:36] * NyQuil changes topic to 'http://sql-servers.com/nopaste || If you want fair, we can start
[03:09] <Chyx> Still stuck with the same problem as last night - trouble with a GROUP BY - ht
[03:28] <till> all day?
[03:29] <till> Chyx: what's the problem?
[03:29] <Chyx> Nah I decided to go sleep ;)
[03:30] <Chyx> I described the problem in a comment above the paste, I want to select the use
[03:30] <Chyx> I can select the highest rank per username by doing a GROUP BY username
[03:31] <till> join the table and get the alias
[03:31] <till> ;)
[03:31] <till> no idea, i don't have mssql to check
[03:32] <till> but a join should do it
[03:32] <till> not sure if it's efficient - probably not :x
[03:32] <till> i go outside
[03:32] <till> cheerz
[03:36] * NyQuil changes topic to 'http://sql-servers.com/nopaste || If you want fair, we can start
[04:24] <Lagged__> mainproc
[04:36] * NyQuil changes topic to 'http://sql-servers.com/nopaste || If you want fair, we can start
[04:47] <SicLuDe> Chyx: still stuck with the problem?
[04:48] <Chyx> Yup
[04:48] <SicLuDe> ok hold on let me look
[04:49] <SicLuDe> geez we are getting so many of these lately
[04:49] <Chyx> Heh
[04:51] <SicLuDe> select a.username, a.rank, b.alias
[04:51] <SicLuDe> from (select username, max(rank) as rank from data) a inner join
[04:51] <SicLuDe> (select alias from data) b on a.username = b.username and a.rank = b
[04:51] <SicLuDe> o sorry hold on
[04:51] <SicLuDe> select a.username, a.rank, b.alias
[04:51] <SicLuDe> from (select username, max(rank) as rank from data) a inner join
[04:51] <SicLuDe> (select username, rank, alias from data) b on a.username = b.usernam
[04:51] <Chyx> Ah well I wondered whether it was doable without a join, not that that's a pro
[04:52] <Chyx> Thanks :)
[04:52] <SicLuDe> so u knew how to do it with the join?
[04:52] <SicLuDe> and u wanted to know hwo to do it without?
[04:53] <Chyx> Well, it crossed my mind that it would be doable with a join, but I thought th
[05:36] * NyQuil changes topic to 'http://sql-servers.com/nopaste || If you want fair, we can start
[05:37] * Godzi_ is now known as Godzi
[05:48] <d2d_w0rk> another day another day at work~
[06:26] * knowone|a is now known as knowone
[06:36] * NyQuil changes topic to 'http://sql-servers.com/nopaste || If you want fair, we can start
[07:10] * Quant is now known as Quant|Out
[07:36] * NyQuil changes topic to 'http://sql-servers.com/nopaste || If you want fair, we can start
[07:51] <phargle> another wha? it's saturday mang!
[08:07] * cletus is now known as Cletus
[08:09] * SicLuDe throws a keyboard at d2d_w0rk
[08:36] * NyQuil changes topic to 'http://sql-servers.com/nopaste || If you want fair, we can start
[09:36] * NyQuil changes topic to 'http://sql-servers.com/nopaste || If you want fair, we can start
[09:42] * Quant|Out is now known as Quant
[09:43] <Quant> pfft
[10:28] * justinm is now known as bsdkrnl
[10:30] * bsdkrnl is now known as justinm
[10:36] * NyQuil changes topic to 'http://sql-servers.com/nopaste || If you want fair, we can start
[11:36] * NyQuil changes topic to 'http://sql-servers.com/nopaste || If you want fair, we can start
[12:36] * NyQuil changes topic to 'http://sql-servers.com/nopaste || If you want fair, we can start
[13:01] <justinm> jesus stfu NyQuil
[13:02] <Drk`Angel> heh
[13:02] <CoJoNEs> waaaa
[13:02] <CoJoNEs> people piss me off
[13:03] <Drk`Angel> People suck, fact of life.
[13:03] <CoJoNEs> true
[13:03] <d2d_w0rk> bah
[13:03] <justinm> oh no, it won't notice me again will it
[13:04] <justinm> sweet
[13:04] <Drk`Angel> it? heh.
[13:04] <Jarett_> everyone should be out geocaching
[13:04] <justinm> NyQuil is a bot Drk`Angel, have you not noticed
[13:04] <justinm> bots don't have a gender, like Jarett_
[13:05] <justinm> he is what most would refer to as a facist unic
[13:05] <Drk`Angel> And cojones kicked you, not nyquil, which you would know if you knew how
[13:05] <justinm> CoJoNEsX didn't notice me, the bot did, which you would know if you knew ho
[13:06] * Drk`Angel just shakes his head and goes to do something more useful than arguing with an
[13:06] <Jarett_> CoJoNEs has kicked justinm from #sql (stfu yourself) CoJoNEs people piss
[13:06] <justinm> yea, cause you're wrong
[13:06] <justinm> tard
[13:06] * Drk`Angel pets justinm on the head.
[13:06] <Drk`Angel> Yes dear, of course.
[13:06] <justinm> don't call me dear you pervert
[13:07] <justinm> stop touching me
[13:07] <d2d_w0rk> you can say you like it
[13:07] <justinm> It's sad that you still can't figure out i was referring to the bot when I
[13:07] <justinm> instead you call me an idiot and pat me on the head
[13:08] <justinm> actually i do kind of like it
[13:08] <justinm> it calms me
[13:08] <Drk`Angel> I don't think the bot noticed anything, since cojones kicked you. But, w
[13:08] <justinm> don't stop :<
[13:08] <justinm> you don't know what /notice is do you
[13:08] <justinm> lol
[13:08] <justinm> and you call me the idiot
[13:08] <justinm> sheesh
[13:08] <justinm> the nerve
[13:09] <justinm> when you join the bot /notice 's a bunch of rules, that's why i complained
[13:09] <justinm> do you follow yet
[13:09] <justinm> you can keep patting me if you want
[13:09] <justinm> lets keep those two things separate
[13:09] <Drk`Angel> Ah, that kind of notice. Gotcha. Precision in language is useful, it st
[13:09] <justinm> :<
[13:09] <justinm> Drk`Angel, could you pat me on the head again. I'm sad because I got kicked
[13:10] * d2d_w0rk fondles justinm
[13:10] <justinm> Could you say "there there" as well, and perhaps give me pudding
[13:10] <justinm> ahh!!! I've been physically violated
[13:24] * d2d_w0rk is now known as d2d_g0ne
[13:26] <justinm> anyone use sql express? I want to connect to it with query analyzer from an
[13:26] <justinm> I mean, how am I supposed to work with it or configure it if it doesn't com
[13:32] <GuntherX> justinm : one, you cannot manage sql express remotely.
[13:32] <GuntherX> justinm : two, download the tools you need
[13:33] <Jarett_> use toad for sql server express
[13:33] <Jarett_> remotely :P
[13:36] * NyQuil changes topic to 'http://sql-servers.com/nopaste || If you want fair, we can start
[13:46] <justinm> screw it, I'll just get a dev copy
[13:48] <GuntherX> justinm : you do that small thing...
[13:49] <justinm> it came with vb 2005, i just won't bother with it
[14:36] * NyQuil changes topic to 'http://sql-servers.com/nopaste || If you want fair, we can start
[15:12] <eLight> I want to do this
[15:13] <eLight> Select fields from Table1 where Pkey = X Inner Join Table1.FK On Table2.PK i
[15:19] <eLight> whats wrong with this code ? http://pastebot.nd.edu/291
[15:24] * Drk`Angel suggests reading the rules and providing an approiate amount of information mig
[15:24] * Godzi_ is now known as Godzi
[15:34] <Darken> haha nice vhost
[15:36] * NyQuil changes topic to 'http://sql-servers.com/nopaste || If you want fair, we can start
[16:35] * samlande` is now known as samlander
[16:36] * NyQuil changes topic to 'http://sql-servers.com/nopaste || If you want fair, we can start
[16:37] <samlander> in my .net app.. is it better to used nested sp's or a single large inlin
[17:36] * NyQuil changes topic to 'http://sql-servers.com/nopaste || If you want fair, we can start
[18:02] * lehheh is now known as face-
[18:36] * NyQuil changes topic to 'http://sql-servers.com/nopaste || If you want fair, we can start
[18:49] * gripe is now known as reverend
[19:17] <justinm> samlander
[19:17] <justinm> use stored procedures rather then inline queries, and use temp tables inste
[19:36] * NyQuil changes topic to 'http://sql-servers.com/nopaste || If you want fair, we can start
[19:38] <gulag> does sql 2005 come with a enterprise manager? i cant seem to find that anywhe
[19:40] <Halo_Four> SQL Server Management Studio
[19:41] <gulag> that come with sql2005? cant find it in the start menu :(
[19:41] <Halo_Four> Which version?
[19:41] <gulag> dev
[19:42] <gulag> let along that it hasnt installed the VS2005 templates for rep[orting service
[19:42] <Halo_Four> Should have asked you during the install. Run the installer again and ch
[19:43] <gulag> okay
[19:44] <gulag> havnt even used sql2005 and i already dont like it :(
[19:44] <gulag> just wanted it for reporting services :P~
[19:48] <gulag> ahh i think i see where i went wrong in install... i just used the tick boxes
[20:00] <justinm> gulag
[20:00] <justinm> sql 2005 is nice so far, from what i can tell
[20:00] <justinm> still a noob at it though, it's so different from 2000
[20:02] <gulag> so far all i can comment on is the installer.. twice now lol
[20:02] <gulag> but prob my own fault, ill see how this install goes
[20:02] <Halo_Four> Business Intelligence Studio to write reports.
[20:02] <gulag> aye
[20:03] <gulag> made sure it was selected this time :P
[20:03] <gulag> i only thought.. installing dev edition.. with vs2005 install would auto do i
[20:03] <gulag> should know better to assume, because something is 'dev' doesnt mean it will
[20:03] <gulag> ev = dev
[20:08] <gulag> yay! it installed it
[20:19] * Disconnected
[20:20] * Attempting to rejoin channel #sql
[20:20] * Rejoined channel #sql
[20:20] * Topic is 'http://sql-servers.com/nopaste || If you want fair, we can start charging at th
[20:20] * Set by NyQuil!~NyQuil@nr14-66-161-196-46.fuse.net on Sat May 06 19:36:58
[20:20] -NyQuil- Welcome to #sql Please read these brief rules or be banned without warning:
[20:20] -NyQuil- 1) Dont ask if you can ask a question, just ask it.
[20:20] -NyQuil- 2) If you ask a database question, and dont say what database youre using (MSSQL,
[20:20] -NyQuil- 3) SQL Code should not be pasted in chan, please use http://sql-servers.com/nopast
[20:20] -NyQuil- 4) If we say RTFM, its because you should. For MSSQL check Books Online. Enjoy You
[20:20] -NyQuil- 5) No Homework! No MySQL!
[20:34] * knowone is now known as knowone|a
[20:36] * NyQuil changes topic to 'http://sql-servers.com/nopaste || If you want fair, we can start
[20:46] <kittybum> I am wokring in ACCESS and I have a form where the user selects hobbies th
[20:46] <kittybum> here is the code i have used and it works fine...
[20:47] <kittybum> http://sql-servers.com/nopaste/?show=629
[20:47] <kittybum> but when i make the hobbies form a subform of another it wont work
[20:47] <kittybum> how do i make the last line od code point to a field in a subform?
[20:56] <kittybum> http://sql-servers.com/nopaste/?show=630
[21:31] * _pusher_ is now known as pushgone
[21:36] * NyQuil changes topic to 'http://sql-servers.com/nopaste || If you want fair, we can start
[21:56] <casabrava> If you think about you dream holiday visit http://casabrava.hit.bg En
[21:57] <samlander> jackass
[21:57] <Quant> whats there
[21:58] <samlander> spam for a hotel in bulgaria
[21:58] <kittybum> http://sql-servers.com/nopaste/?show=630
[21:59] <eLight> I have a persons table and it has a type for customers or contacts and that
[21:59] <samlander> kittybum: that looks remarkably like a homework assignment
[22:01] <eLight> anyone?
[22:01] <kittybum> it is an assignment...
[22:01] <samlander> kittybum: then how will you learn anything if any of us help you with it?
[22:01] <kittybum> i have finished but would like to use sub categories...
[22:02] <samlander> kittybum: and just out of curiousity what part of : -NyQuil- 5) No Homewo
[22:02] <kittybum> huh? how am i supose to learn something if i am never shown or can't find
[22:02] <samlander> did you not understand?
[22:02] <samlander> kittybum: ask your teacher would be a great start.
[22:02] <kittybum> ah ok, i didn't see that
[22:03] <kittybum> teacher doesn't know
[22:03] <samlander> then your teacher shouldnt be teaching
[22:03] <kittybum> haha i agree
[22:03] <samlander> wtf are they teaching kids these days sheesh
[22:04] <eLight> kitty WHAT do you want to do?
[22:04] <kittybum> http://sql-servers.com/nopaste/?show=630
[22:04] <eLight> Not code
[22:04] <eLight> just what do you want to do?
[22:04] <samlander> eLight: he's got a nice lil description ontop
[22:05] <eLight> oh I dont use access. ;0
[22:05] <kittybum> ah ok thanks anyway
[22:06] <eLight> what about my question? is moving from a customer+contacts table and puting
[22:07] <kittybum> no idea
[22:08] <eLight> I think it is in pure relational terms but coding against it was a pain for
[22:08] <eLight> simple
[22:09] <eLight> problem is I dont have a constraint taht makes sure "customer" in orders is
[22:11] <eLight> shit it broke my entire application
[22:11] <eLight> lol
[22:36] * NyQuil changes topic to 'http://sql-servers.com/nopaste || If you want fair, we can start
[23:36] * NyQuil changes topic to 'http://sql-servers.com/nopaste || If you want fair, we can start
Session Close: Sun May 07 00:00:00 2006