| |
| |
| |
|
Page: 1 2 3 4 5
Comments:
<0> np
<1> omg it was windows firewall
<0> "NASA Department Saves Nearly $180,000 with MySQL"
<2> haha
<1> unfortunately that was saved on a package for ordering office supplies which costs (on its own) $500k
<1> im sure mysql would want you to know they are launching rockets with it or something
<3> hahah
<4> sql 2000.. trying to connect to a network drive from within my sql statement and i'm getting "access denied".. my sql 2000 is set to use "system account".. anyone know which user i have to give rights to
<5> Probably would have to give Everyone read access to the share and the path.
<4> i believe we tried that with no luck
<1> you mean local system account
<1> just create and use a real user
<5> I'd run it manually with bcp instead of trying to run BULK INSERT through SQL. Either that or use DTS to perform the file copy and then the insert process.
<6> In a subselect I'd like to get a sum of dollar values from a list of DISTINCT record id's
<4> phargle so changing that to use a user with admin privledges.. could that stop my sql server from running or any negative consequences
<6> eg, I could select distinct id, sum(price) this from that but only return sum(price)
<6> wow
<6> every nerd is getting laid apparently
<6> =)
<7> all except you.
<7> that must make you feel worthless
<7> learn to group by
<6> group by id, but then if I do sum(price) i'll still get the total, not the distinct
<6> should I use top or what?
<6> each item reported with the same id is going to return the same price
<1> lol
<1> why sum it then?
<6> well if I were to distinct the id first, then sum, it makes sense
<6> thus my question here =)
<1> oh, in that case.
<1> 14:54 < Jarett_> learn to group by
<2> ron_frown i don't get it
<2> select id, sum(price) from **** group by id
<2> what's wrong with that
<6> tenfour if an item with the id of x exists twice in that table price will be recorded twice
<6> when it shouldnt be
<2> no it wouldn't be
<2> that's the point of group by
<4> sql 2000 can you via sql code transfer one table from one sql server to another sql server
<8> yes
<4> insert tablea (select * from tableb) thats if they were in the same database
<8> insert into (localtable) (columnlist) SELECT (columnlist) from OTHERSERVERADDRESS.DATABASE.TABLE
<8> orrr
<4> ok.. where do i put hte other server address username /pw
<8> enterprise manager -> tools (on menu) -> data transformation services -> export data
<8> then import on the target server
<8> to do it with the query you'll need the other server registered in your enterprise manager
<8> do that from the tree on the left
<1> wow
<6> tenfour that doesnt return a global sum, but rather 23 individual rows
<1> step by step instructions for using a wizard.. what has this world come to
<6> which I can see WHY
<6> but I would like to essentially take a field of each row thats unique based on id
<6> and sum that field
<1> but
<1> summing one row of that field?
<1> NO, you're summing more than one row of that field..
<2> ron_frown can you use the paste site & show what you want to get?
<2> show source table(s) and result
<6> if I have 23 distinct contract id's I get 23 rows with your suggestion
<6> I think the sum of those is 100
<6> 100% correct
<6> but I'd like to get a grand total
<6> which is the ultimate goals
<2> then just select sum(blah) from lol
<1> not distinct sum(distinct col) group by table distinct sum(col) having distinct col
<1> because that shows more than one distinct
<1> but like distinct id sum(col) id from id distinct col col distinct distinct distinct
<5> I'm not sure if anything is more embarr***ing than spelling errors in your products.
<7> a virus on a media card
<9> heh
<10> howdy ho
<11> hey - I will pay $5USD via paypal if someone can write (2) MySQL queries for me. under 10 minutes work I would ***ume. I have structure and concept.
<2> $5
<2> heeh
<11> if you worked $5 per 10 minutes you would make $30hr :\
<5> #mysql
<12> #doyourownhomework
<13> lol
<13> so...
<13> Sr. Architecht guy thinks that I should fix the db so that deadlocks don't occur.
<13> heh
<13> i mention that it's fairly common to check for a 1205 error and resubmit your transaction.
<13> he tells me "I'd hate to see a system programmed like that."
<13> so, I think I'm only gonna be here a year or so...
<13> this coming from a guy who thinks that adding errorhandling (and subsequently his app checking for errors) is too much work (complexity).
<13> he would prefer to do it all in the app layer...
<14> hehe
<13> eh, whatta ya gonna do...
<13> this same guy also said "But that's too much work" when I suggested they add errorhandling to the sp's.
<15> Hey
<13> my reply was "Doing things right, sometimes is work."
<15> How do I fix this error?
<15> Http://rafb.net/paste/results/uClN4k14.html
<13> man thats ugly...
<13> looks like a null insert to a not-null column?
<14> Hanif you use our paste site
<14> to fix the first error
<15> Here is the error -http://sql-servers.com/nopaste/?show=259
<15> What is the pre-defined error exception for a value not being null
<15> ?
<13> beats me, i dunno pl/sql...
<13> there should be an errorcode lookup for it though.
<13> iirc oerr can take a wildcard search.
<13> but i may be wrong, its been ages since i've worked with oracle.
<15> Anyone else?
<14> http://www.error-code.org.uk/view.asp?cl=ORACLE&p=PLS&ec=00109
<14> http://ora-00926.ora-code.com/
<14> was that so hard :/
<14> a thanks would be nice
<16> what sql field type will take 0.74654984
<14> read the rules on join
<14> thanks
<16> what sql field type will take 0.74654984? microsoft sql server?
<17> now that BerkleyDB has been bought by Oracle, who is more interested in PostgreSQL?
<7> whatcha gunna do when they buy Zend and own all rights to php?
<17> dunno, i am more of a python person :)
<7> python ****s for the web
<7> Oracle "we own the software at the heart of open source!"
<17> it's a different approach, I've been doing work with turbogears, which is a MVC framework for python. Python basically asks me to use ORM instead of embeding sql into php code
<17> php is cool too, it's kind of like RDBMS, whatever i am paid to use
<7> so you are a whore
<17> lol, no really, all the stuff is pretty much alike, so there is no reason to preffer one over another for technical reasons, there are license issue that do matter
<18> hi, i would like to figure out which fulltext engine scales best... lucene or sql server. anybody have any idea about this?
<19> screw you guys, i am going to bed
<20> What is the benefits of using Stored Procedures instead of normal sql queries. Im using MSSQL as SQL Server
<21> SilverWrk, people feel differently about them, so you'll get different answers. if you want opinion, i can answer
<20> sure :) Always
<21> i prefer to use stored procs for a number of reasons
<20> We have some problems with the database server not quite fast enough and are trying to optimize the tough qouries
<21> they allow a more sophisticated degree of processing than a simple query
<21> well, sp's won't help slow running queries, but they give options on how you can possibly reduce the complexity of those queries
<21> also, you can encapsulate 'business logic' within procs
<21> and control access to them
<21> you can return multiple resultsets from them
<21> mostly its just a different kind of envelope for your db requests
<20> Ah, nice. At the moment we have a query which joins 4 different tabel with outer joins and the execution plan use hashtabels for solving the sql query. It hurts performance like hell, plus there are too many locks. ( 350.000 at peak times )
<21> i wouldn't go so far as to say 'they are faster', but they can be
<20> Oki nice
<21> well, a proc would give you more flexibility in possibly using temp tables to avoid the outer joins, ***uming thats possible
<21> the table is indexed?
<21> tables
<20> yeap. Very much
<21> how many rows are processed
<20> But there are some small itches where joining 2 of the tables, it start on the hash tabel. So there need some index at some point
<20> one moment
<20> ill just have to find the query again.
<20> found it
<20> counting
<20> return 2800 rows. And
Return to
#sql
or
Go to some related
logs:
#beginner
#windows
#gamedev
199 FETCH FIRST 1 ROWS
#nhl
un 9a7y
#ubuntu
#politics
bash print unix time
#red
|
|