| |
| |
| |
|
Page: 1 2 3
Comments:
<0> !addr rodneyj.net
<0> oops
<0> wrong window
<1> I'm surprised any channel aside from #help lets anybody join as "guest*"
<1> iow, banned
<0> why? who cares really
<0> I think you've got to be quite an IRC addict to even wonder about that
<2> Halo
<2> you still messing with MDX?
<2> at some point i was able to write those queries myself but now i dont remeber anything
<3> omg rails naming convention is nutty
<0> heh, rails
<4> Quant: thanks again for your help earlier, your idea about creating the categories came through with flying colors and sped my data analysis onward.
<2> cool
<2> your welcome
<5> you're
<2> jizzard and his spelling
<2> riz, did you notice that Moz pissed off Senz so Senz left
<5> nope
<5> never saw that blog
<5> now i done did it, i no'ed out my user/pw in my cisco router
<2> the rest are faggggs
<5> now i cant get back in to it
<2> jk :)
<2> so reset it
<5> http://www.cisco.com/en/US/products/hw/routers/ps259/products_p***word_recovery09186a0080094675.shtml
<5> i gotta go through this **** apparently
<5> atleast i have console access
<5> never had todo this before
<2> hehe
<6> is anyone interested in doing some custom coding tonight for a small fee? please send me a msg
<7> we pay you to be allowed to code? come on!
<8> how much $$ for how much work?
<2> "small fee"
<2> that's like 15 bux
<2> jarett sup
<2> jar, where in NJ?
<2> **** i am using a filesystem watcher and once the file is dropped i read it with a dataset (ds.ReadXml()) and then i try to move the file to another directory and that **** is "Used by another process"......annoying. Any ideas on how to wait till some process releases the file?
<9> for (; !moveFile(); take100%CPU());
<2> heh
<0> hehe...M4 stuff does that all the time
<0> m$, stuff, rather
<2> i am afraid that loop is gonna hang my **** up
<2> hmmmz
<2> i dont think the dataset is holding the file but the Biztalk that created the file is.....**** happens too fast
<0> some 'consultant' guy wrote some automation sripts in vb and when they errored out they'd send up a visual alert/comfim popup. this is fine if a human is running it, but an autojob needs the error sent to STDOUT or STDERR and this guy didn't know what it meant. so if one of his vb scripts threw ANY kind of error the whole job would hang waiting for somone to 'click the confim box'
<0> I reworte everything in batch files after he left
<2> heh
<2> oh well
<2> now i have
<2> while(!movefile){Thread.Sleepies(1000); count++; if(count > 2) break;}
<2> dont like for loops
<10> can you use ms sql server trial for commerical use
<11> I think you can but why do it when it will just expire?
<12> k00, why not use express?
<10> does ithave full text search?
<12> your data isnt important anyway, do you really need to fullt ext search it?
<10> yes
<12> doubtful, or else your database would be important enough to pay for
<10> i dont have 2K
<10> to drop
<12> you data isnt even worth 2000?
<12> see i was right
<10> i dont have 2k
<12> is it a webapp?
<10> windows service.
<12> then its 1478 or less for 10CALs of workgroup
<12> if your data is worth less than that.. well its time to rethink access or foxpro
<13> If it's a service and not doing any network I/O then a file-based/embedded DB would be fine
<13> Not doing any network I/O to the DB, that is
<12> so would express or postgres :P
<13> Sounds like MS is planning on providing fulltext in SQL Express later this year.
<10> neg.
<13> So would any of the Express products from the various vendors.
<13> PostgreSQL is probably the only of the free DBs to have a fulltext engine and be fully functional.
<2> other vendors use the "Express" naming scheme?
<13> Quant: Both Oracle and IBM have Express editions
<14> SQL Server 2000::: How can I fill an ***ociative table in this case? http://www.sql-servers.com/nopaste/?show=398
<14> well it's not that i don't know "how" to fill the table, but not sure "WHEN" to fill "collection_sale" ***ociate table with data...
<8> well collection & sales have to have items before they can be ***ociated in collection_sales
<14> yeah, that was what i thought...
<8> but you'll need to know the ID of the items you insert so you know what values to stick in there
<14> hmm does that mean, although "collection" and "sales" have many-to-many relationships, i shouldn't create an ***ociative table?
<14> yeah.. that's true.
<8> if it's n:n, then you need that collection_sales table
<14> "n:n"?
<14> is that a notation for "many-to-many"?
<14> oh yeah.. it is
<8> yea
<14> but then. i am not sure, when to insert data to that "collection_sales" table... hmm
<14> well i wish either "collection" or "sales" was a lookup table.. hmm..
<14> this is friggin' driving me nuts
<8> hehe sounds like you maybe are asking the wrong question or something
<8> seems obvious when to insert the rows
<14> you mean, to "collection_sales" table?
<8> yea the question you are asking
<8> hmm
<8> what are these tabels anyway?
<14> they are simplied versions of...
<8> a sale happens, then collections happen? is collection a payment?
<14> "sales" <-- keeps track of ads, "collection" <-- keeps track of checks and cash
<8> ok this is for advertising
<14> collection is a payment
<14> tenfour:: yes
<8> ok
<8> hmm why do you even need to ***ociate them?
<8> don't you just have a running balance?
<8> so a collection isnt necessarily ***ociated with a sale, but just contributes to the sum?
<14> but.. what i needed from that was that...
<14> i wanted to keep a track of, for how much of ADs, payment has been made
<14> and vice versa
<8> i haven't done this before, but i would think you'd just calculate it on the fly
<14> you mean, using running totals everytime?
<8> but i guess you are just trying to cache that data using this table?
<8> yea
<14> yupz exactly
<14> cuz there are just too many data for me to calculate'em all on the fly
<8> so when you create a collection row, you will want to run a query that gets you the sale records that it affects
<8> not sure how that query would look though
<14> hmm.. and after that, if there exists a sale records, then i will need to fill the "collection_sales" table...
<8> this ledger type stuff i have never done before
<14> yeah.. this is such pain in the ***..
<14> this MIS and accounting stuff...
<14> moreover, i have learned about thsi stuff in English while in college, but in real life, i have learned how that works in Korean and now i have to explain the very nature of the problem back in English
<14> tenfour:: Anyways, I guess there isn't much else for me to do except to check "collection" table when inserting a new data into "sales" table and vice versa everytime...
<8> yea but it might be hard without keeping a running total or something
<8> if a collection pays for a part of a sale
<14> it will be a bit complex with running totals but I think it has to be done for now... i can't come up with much idea...
<14> i am going to see if calculating running totals on the fly in one single step would take a long time or not tomorrow morning... hmm
<14> i guess i am going to have to run tuning advisor to update indexes
<14> tenfour:: thanks for the help there.. I really appreciate it...
<14> now i am going to bed..~~~ gnite
<14> hmm trigger sounds temping...
<14> s/temping/tempting
<15> how to get the "ID" value of the last row ? I need to get the last row ID, how can I do that ?
<16> Anyone know, how to write sql queries and willing to help me
<7> I am! Me me!!
<7> oh.
<7> Too late
<7> :P
<17> Hi
<7> hi
<17> hey
<17> why is this channel so dead?
<7> it is not dead
<7> just a little quiet right now
<17> oh
<17> does everyone just talk about db's?
<7> like any channel on IRC it has its amount of crap as well
<7> but mostly it is about db's and queries and stuff
<17> cool
Return to
#sql
or
Go to some related
logs:
#politics
#stocks
#visualbasic
#visualbasic
boobcountry movie
allnitecafe rincewind
#hardware
elnas channel
simscan: fatal error executing clamdscan
benefits and taxiation of america
|
|