| |
| |
| |
|
Page: 1 2 3 4 5
Comments:
<0> right
<1> Arrakis "than that"
<0> right i gotz it :-
<0> :-)
<2> how do i see the code in a stored procedure using SQL statments ?
<3> yeah, this is our ERP system and the DB was done by a bunch of old school VSAM RPG programmer types who don't quite get what a RDBMS is
<4> "old school", lol
<4> I still do it they way Codd did in 1970. Is that "old school" ;)
<5> Marios: Query your data dictionary. a process that varies greatly from one rdbms to another.
<1> Marios_ try sp_helptext
<3> the DBA lied to me, it's 4.9M rows
<3> and the HAVING COUNT version is much much much slower
<3> Query running. 3 records selected, 4922766 processed.
<4> damn right it's slower
<3> oh lord...
<3> Query running. 15 records selected, 14051474 processed.
<3> hmm... is this damned thing doing a cartesian product?
<3> Query running. 16 records selected, 16993586 processed.
<6> lolz
<3> Drk I'm gonna kick you in the shin. :p
<3> now the thing is eating up about 67% CPU on the DB2 box and I can't cancel it
<3> Query running. 17 records selected, 29363108 processed.
<1> your fault
<7> Hi
<6> lmao
<1> Lukky herro, me ruv u rong time 5 dorrah
<3> yeah... trying out someone else's SQL is always a gamble
<3> I wonder how badly it would screw things up if I killed the process
<1> let's find out
<6> poooooooof
<6> *lifghts dim*
<7> I have to access some legacy FoxPro tables (free directory tables). Is there a way to issue a select statement that would join data in tables that are located in 2 separate directories ?
<6> *sirens going off*
<6> *distant screams and machine gun fire*
<3> heh
<6> *wailing of emminent nuclear strike alarm*
<3> I just set it down to a super low priority
<3> it'll eventually finish
<6> 15 years later
<3> this is almost funny...
<3> Query running. 18 records selected, 44722401 processed.
<6> 44 million records
<6> how many more are there?
<6> left
<3> it's the way the query is structured, it's re-reading the entire table every time
<6> ohs
<6> hmmz
<6> well umm
<6> ill distracy them and u kill it
<6> O HLOOK THERE GOES GOLDI HAWN!!!!!!
<3> *hehe*
<3> it's reading 2483576 for every row it returns
<6> ohs
<6> heh
<6> is the records selected have to go up to ?
<6> how high?
<3> it's going to return about 1800
<6> maybe the records processed will overflow and the db will crash
<6> hmmmaybe not :(
<3> nah, it's an AS/400
<3> it doesn't crash
<1> i have the as/401
<1> with new ring tones
<2> I am using aqua studio...I can see the list of stored procedures...but I don't know how to view them. any ideas?
<5> Oops. Sorry. haha :)
<1> what database are you using Marios_
<5> So, lesson: Yes, it can hurt. :)
<1> READ THE RULES WE TELL YOU TO SPECIFY
<2> Darken, I am using ODBC connection to a SYBASE DB
<7> I have to access some legacy FoxPro tables (free directory tables). Is there a way to issue a select statement that would join data in tables that are located in 2 separate directories ?
<3> Query running. 21 records selected, 138,011,704 processed
<3> *hehe*
<5> Its SHOULDN'T be correlated. So, I dunno what I did wrong.
<5> heh.
<5> Sorry :)
<3> it finally finished
<8> in sql server 2000, is there any way to relate... say in UPDATE tablename SET column = (SELECT value FROM table WHERE blah) .. to relate the WHERE blah clause to the row that is being looked at for update
<8> I know that doesn't work
<8> but i need something like that effect
<8> (or at least think i do)
<8> and would rather not use a cursor
<6> update table1 set column = (select top 1 column from table2 where condition=table1.column2) ?
<8> hm
<8> I'll try that.. but it seemed like i already had
<6> there is also the udf method
<6> lol
<8> udf?
<8> ah yes, that's why i didn't try that.. the top 1 will always pick from the same result set, even if the datetime's value changes, because it's selecting all values where table1.datetime = table2.datetime
<9> heh.
<10> yes joining channels is funny
<11> darken
<11> how much did u gain
<10> quant about 3lbs in the past week
<10> so far
<10> 2.5-3
<11> why so little?
<10> that's a lot quant
<10> it's about 0.4lbs/day
<6> gaining weight?
<10> yes
<6> for what?
<11> he's gonna compete
<10> because i feel like it Arrakis
<10> i'm entering the tough man competition
<6> heh
<10> iron man returning champion
<10> something like that..
<6> lol
<12> hey does a case work with a variable for example case @hours when '40' then 'do something' else 'some otherhitng' end ,does taht work?
<11> yea
<12> i'm using this case in a subquery, that shouldn't be an issue,right?
<11> nop
<13> depends on the rdbms
<14> and how hot your girlfriend is
<15> hi, is it valid to put something like WHERE TRUE ?
<15> so it acts as it has no WHERE?
<16> anyone around?
<15> :(
<17> im creating an SP that uses a couple vars, (MSSQL 2000) like so. create procedure blah @var1 as varcahr(2), @var2 as varchar(4) as .... my question is , shouldn't you be able to run it like so? Exec blah fo,sure Go
<11> ?
<17> nm.... i was omitting the ''
<17> didn't realize you needed to switch to using single quotes when using more than on Varchar in the SP
<18> You always have to put text in quotes.
<11> dur dur dur
<17> not for mine...if it is just a single value running in the SP and i have already declared it as varchar() it doesn't seem to care if in single quotes or not
<18> Yes, you got the special version
<17> im running a few along the lines of Exec mysp foo
<17> with no problems
<17> i doubt it is special.... although people call me special all the time LOL
<19> hello
<19> i got a funky sql issue.
<19> i have tableA(toID, fromID), i want to join my userTable to is so i can get the names of the contid but can you join the same table twice?
<20> I have a PostgreSQL database with three tables, the middle table ***ociates table 1 and table 3 as a many to many relationship via foreign keys. I'd like to be able to delete the record in table 1, and it automatically delete all the ***ociations for that ID in table 2 (table 3 should be left alone). If I just attempt a regular delete for that id on table one, I get a violates foreign key contraint error. Is there a simple SQL way to do this? Or do I
<20> have to do a delete/join ?
<19> you can manually delete it or read up on cascade delete
<20> aha
<20> so I don't do somethign like: delete table1 join table 2 on (t1.id=t2.t1id) where id=whaetver ?
<19> no. doubt that
<19> but don't take my final answer
<19> you're thing would work fine if it was a select
<20> it is as simple as delete from table1 where id=1 cascade
<20> it'll just hunt arround and get rid of rows on the ***ociation table?
<19> thats the simplest way to do it
<19> does anyone here know how to join the same table twice??
<20> Ooh.. the table definition has to set the casccade parameter
<19> say tableA has toID and from ID pointing to the same userTAble?
<19> yah,. read up on it
<19> it'll tell you all the bases to cover
<20> bleh.. I might as well just do two deletes :)
<19> for now. then go back to it
Return to
#sql
or
Go to some related
logs:
#politics
arrowheadproducts.net
#red
#windowsxp
#hardware
matthews county va accent
#beginner
#politics
#gentoo
#windows
|
|