| |
| |
| |
|
Page: 1 2 3
Comments:
<0> haha
<0> :)
<0> yea i know where he is
<1> :)
<0> thegamble
<0> what server are you on
<2> Hi. Could someone please direct me to some resources about asynchronous cursors in MSSQL? I need to see some C code samples. Thanks!
<1> Quant: Bloodhoof, you?
<0> Kalgcekoz
<0> or something
<0> lagtown
<0> what characters you got?
<3> can someone help me with brokenstones ?
<4> ?
<3> you know what bulletin is ?
<5> im using a select statement to bring back some rows based on StateID and SuburbPostcode. this works fine except in some instances there are duplicates that have the same SuburbName and SuburbPostcode..... how can i avoid bringing back duplicates based on the SuburbName?
<2> use DISTINCT keyword?
<5> ok mate ill check it out, cheers
<6> quick question before i ask my real question, why no mysql?
<7> 31-feb-06
<4> @ whynomysql
<8> whynomysql = because we said so ;it's probably easier to answer the question yourself by asking 'Why am I using MySQL?'
<6> ^that does erase my curiousity about why this channel doesnt like mysql
<6> im honestly curious because if there's a real reason why i shouldn't be using mysql i would like to know
<7> 1 = null and 1 = 0
<4> it follows less standards then microsoft usually does
<7> only standard microsoft follws are the ones they bought from sybase :P
<6> what if im not using microsoft?
<9> is that possible?
<10> Jarett: MS didn't inherit window functions and CTEs from Sybase.
<6> phargle: ever heard of linux?
<7> i was speaking database wise.. this is a database related channel.
<10> method: Ever heard of PostgreSQL?
<9> method|: ever heard of sarcasm?
<6> oh heh
<6> :/
<6> well i wont even waste my time asking a question regarding the inferior open source piece of **** that is mysql
<10> Jarett: Was that "database-wise" comment to me?
<7> never
<10> Just wondering because window functions and CTEs are database constructs.
<6> http://sql-servers.com/nopaste/?show=159 me and some guys at work were trying to figure this exercise out. we couldn't get it for some reason. any suggestions, i thought this query would work and it does kinda give you the result you want but it's still not the query that is right: http://sql-servers.com/nopaste/?show=160
<6> any ideas greatly appreciated cause ive been beating myself up about this query for the paste 2 hours
<1> method|, exactly what about the result set is incorrect?
<6> it is needed to find the maker producing at least two different computers (both PC and laptop) having speed not less than 750 MGz. Above query gives the result set which will also include a maker producing only PC (or only laptop) with required speed. This does not meet the exercise conditions.
<1> you say exercise and work in the same sentence; sounds rather like homework
<6> we got that excercise from this website and apparently that is a tricky one
<1> not really :)
<6> i was saying we were working on it at work
<1> what dbms?
<6> it isn't really work related
<6> microsoft
<1> so what are the tables? got a url? There are easy solutions; i need a bit more info
<1> in other words, is it maker, product, model?
<6> let me get you the url
<1> kk
<6> this comes from a site that gives you sql excercises
<6> http://www.sql-ex.ru/exercises.php?N=23
<6> just click enter without login
<1> one sec
<6> then go to database schema if you want to see the schema
<6> that's a cool site for anyone looking to practice sql
<1> i bookmarked it already :)
<6> the exercises start off easy but get REALLY hard
<6> when i say hard i mean they are coupled with crappy databases and everything
<6> heh
<1> the correct query results in an incorrect result. LOL.
<6> what was the query? check the faq theres a question about 23 on there
<1> In other words, there is no data that supports the exercise in the test tables
<1> ok, the only PC's with the required speed are models 1121 and 1233
<1> one is made by A (1233) and the other by B(1121)
<1> nm, this schema is just hosed. let me rewrite it lol
<6> it asks about pcs AND laptops tho
<6> not just laptops
<1> yes, i'm aware
<1> SELECT M.maker FROM (SELECT DISTINCT maker FROM Product) AS M WHERE EXISTS (SELECT * FROM Product AS P INNER JOIN PC ON PC.model = P.model WHERE P.maker = M.maker AND PC.speed >= 750) AND EXISTS (SELECT * FROM Product AS P INNER JOIN Laptop AS L ON L.model = P.model WHERE P.maker = M.maker AND L.speed >= 750)
<1> there you go
<6> lol wow
<6> did you use query builder to do taht or something :P
<1> just my neurons
<6> cool
<1> I don't believe there is a query builder anywhere to work with that hosage, lol
<1> steps:
<1> 1. Create derived table to correct the fact that there is no 'maker' table
<1> 2. Use aforementioned derived table as base table for query
<1> 3. Hang 2 EXISTS() predicates on to ensure the correct production of PC and Laptop, at the required speeds
<1> 4. Execute
<6> nice
<1> 5. PWNED, lol
<6> thanks a bunch man, imma go to work tomorrow and brang about how i cranked out the answers after hours of though ;P
<6> just joking i wont take your credit
<1> heck yes, why not :)
<1> there are other methods; this one seems simplest to explain to others
<1> I especially enjoy FAQ #3: "SELECT M.maker FROM (SELECT DISTINCT maker FROM Product) AS M WHERE EXISTS (SELECT * FROM Product AS P INNER JOIN PC ON PC.model = P.model WHERE P.maker = M.maker AND PC.speed >= 750) AND EXISTS (SELECT * FROM Product AS P INNER JOIN Laptop AS L ON L.model = P.model WHERE P.maker = M.maker AND L.speed >= 750)
<1> er, "Why do you use poorly structured Ships database to do these exercises? "
<1> clipboard problem, sorry
<6> yea lol
<1> thanks for the url; i'll p*** it around. Take care
<6> np, bye
<1> ok bye :)
<11> Anyone here familiar with Unixware SCO 7.x?
<12> oh
<12> oh god no
<11> lol
<12> go in #linux and ask that
<12> i just want to see the responses
<11> k
<10> Depends on how old that version is.
<13> wow.. unixware
<13> evil
<12> heh they just ignore you
<11> lol
<10> hm, yes, that is the evil SCO. Don't want to accidentally mix the original Santa Cruz Operation with the evil Caldera of today.
<11> well it's a pretty simple probelm. the ps -fu command isn't working properly. sometimes it works, and sometimes it comes up with no users.
<10> How really a SQL question.
<10> er, Not
<10> hm, how'd I do that?
<10> bleh, ****s that OPENXML requires calling sp_xml_preparedocument, makes it impossible to use it in a UDF.
<14> in tsql how to split a varchar by the last '\' ?
<10> Loop with CHARINDEX() or use REVERSE() and CHARINDEX() backwards and SUBSTRING()
<0> yo
<0> what's the easiest way to send a http post with a few form variablez
<0> to an address, i need this for testing
<0> using biztalk http adapter :)
<0> hurry, or i am gonna take the long way :)
<15> yo
<0> yo
<15> w***up dog?
<0> working with biztalk, you?
<15> munchin' my grub
<15> and waiting while yum updates my FC4 install
<15> I hate Microsoft
<15> I also hate stinky cheese
<0> fc4?
<15> Fedora
<14> is there a trim function in tsql?
<9> ltrim rtrim
<9> but no trim
<14> thx
<16> hello fruitcakes
<16> and rmah
<17> haha
<18> how do i restore a backup in SQL Server 2005?
<9> is this punch cards?
<18> no
<9> oh, then probably something like restore database dbnamehere from disk="filename" is a good start
<9> if you mean via the gui... you shouldnt have to ask
<9> :P
<18> er. im new to this. have to do it for work
<18> my predecessor was using access
<19> awesome
<19> hahahaha, Fedora?!?!
Return to
#sql
or
Go to some related
logs:
#unixhelp
#debian
XBox softmod washed out problem -360
the chicks never came
#linuxhelp
lincoln i freed the who?
cafu bamboo
Dell 690 motherboard
#photoshop
#solaris
|
|