| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12
Comments:
<0> like when giving language defitions
<0> like if it says: <derived table> [ AS ] <correlation name> [ <left paren> <derived column list> <right paren> ]
<0> that means that AS is optional right?
<1> yes
<0> so sql 2003 spec, as is optional
<0> http://savage.net.au/SQL/
<1> see, it's getting traction :)
<0> ?
<1> seeing as how tons of DBMSs already support it
<1> thx for the url, btw
<0> lol
<0> np
<2> sicwork, quick question
<0> it just ****s cause its so damn hard to read
<0> :)
<2> is there an easy way in sql to get random rows back from your where clause
<0> Grad: just drop the table
<2> when you use top
<1> haha
<1> Grad, what dbms?
<2> sql server
<0> well SQL persay does not support random numbers
<1> order by NEWID() ASC
<0> mssql
<2> ahh
<0> damnit i was just gonna say that
<0> :)
<0> bastard
<2> i was thinking something like that too lol
<2> good idea
<1> it's the booze :)
<0> i wanted the whole leadupto the newid
<0> :)
<0> wanted to make it more dramatic
<0> :)
<1> I'm sorry
<1> :)
<0> just ruined it
<1> I'm doing a real boring refactor; gotta get back to it
<0> you just dont respect hte power of newid() :)
<0> ya maybe ill just go p*** out so that a productoin system doesnt get taken down tonight
<0> :)
<1> have fun :)
<0> l8r
<2> my god
<2> sql server is taking up 1 gig of memory lol
<2> gonna have to get the admin to reconfigure that
<3> By default it will use what it can
<2> yea i know
<2> but with that and mysql running it's only leavnig 256meg, it's configured to use up to 1.2gig and it only has 2gig
<2> oh btw, halo i got a quick question
<2> i ran into a recursion stack overflow today and i found a great way of solving it
<2> http://pastebin.com/656801
<2> what do you think?
<2> i just renamed the old method to CloseNode2 and did that
<4> I am getting an invalid column name error here: http://sql-servers.com/nopaste/?show=534 when the column name exists
<4> is it because I cant you a field name twice in a where phrase or something?
<5> hey guys I need a bit help of a simple query. I am selecting from a table that has repeated user_id's in different entries, I am trying to find the number of entries that repeated less than 1
<5> this will get the # of repeats but I am not too sure where to stick in COUNT > 1 on the same query SELECT COUNT(*) as COUNT FROM `opening` GROUP BY user_id
<6> you can't repeat less than 1
<6> you can't repeat less than 2 times to be more exact
<5> not sure what you mean by that
<6> you want the unique results or duplicates
<5> they're just entries that potentially have repeated user_id's
<6> ok
<6> let me rephrase that
<6> [01:58] <6> you want the unique results or duplicates?
<5> ah I see what you're getting at
<5> i am actually trying to find both 0 entries and 1 entry
<6> so you just want to show how many times an id occurs
<6> and display the count?
<5> well not how many times but exactly 0 time or 1 time
<5> cus I can just group by user_id which will return how many times
<6> explain how something can occur 0 times
<5> so i need to extract the ones with 1 as count
<6> what other list are you comparing it against
<5> I will be comparing to another table for user_id's which I know how to do so this I left out of the question
<5> but lets not worry about 0 time
<5> how about just 1 time
<6> select id from table group by id having count(*) = 1
<5> group by gives # of occurances
<5> HAVING
<5> there we go :)
<5> thank you!!
<5> its the order of execution I am not getting right
<5> WHERE COUNT = 1 wont be interpreted
<6> you can send a check for my services
<5> actually if I may ask another question
<5> I think its easier solved than I was trying to do
<5> I have 2 tables, table A has full list of user_id, table B has selected # of user_id, I just need to find what A has but B doesnt
<5> there should be a shortcut to do this?
<5> intersect by user_id perhaps?
<7> where tbla.user_id <> tblb.user_id ?
<6> F1-Work outer join
<7> or tblb.userid <> tbla.userid
<6> no ninjajax
<6> select a.id from a left outer join b on (a.id = b.id) where b.id is null
<5> thanks guys I got it to work now
<8> I'm sure this is an easy one for y'all
<8> sql server 2000 wish to set the default value of an existing column
<8> got as far as: alter table pages alter column HideInMenu default 0
<8> anybody home?
<8> helooooo
<8> 111 ppl here and yer all idleing?
<8> as if
<7> cha
<9> sql server: bulk insert. I have when I insert a text file with unicode chars, its not inserting correctly. how can i resolve this issue ? I am using datafiletype='widechar' and codepage='raw'
<10> is there a way to extend the timeout on a stored procedure ?
<9> sp_configure 'remote query timeout', 0
<9> (i`m a newbie :D)
<7> ooo google calendar
<11> Greetings SQLers :-) I'm using VWD Express with SQL Express, i've setup a few users/p***words and userroles. When i try to run my application i get a 'User does not have permission to perform this action.' Is there somewhere in SQL Express that i must set the user permissions to access tables ?
<12> .
<13> !
<0> ~
<14> #
<14> octothorpe ownz j00 all
<0> $
<11> Hi all
<11> anyone know about SQL Express permissions ?
<12> hmm
<15> IanMc:: i just installed it and uninstalled it
<15> it's a piece of crap
<11> hehe
<16> have look at this it's Oracle 9i -> http://pastebin.com/657534 how can I add the TIME column up by the MACHID ?
<17> what do you mean
<16> like AOI is there 4 times, I want it to there once with the TIME beside it with the TOTAL
<16> The group by will not work correctly
<17> don't group by finish or date_open then
<16> I understand it is grouping by finish and date_open, and that is why it is seperating it, but the select statement will not work with out them being added to the group by
<16> any idea's?
<17> of course it won't... you would need to use aggregate functions
<16> do you have an example of one?
<17> min()
<18> server question.. does a low level format of a scsi drive take a long time... its a 36 gb drive and the dos program has no progress bar
<19> xloc: and you think this is the right chan for that question? :)
<14> xloc, yes it takes a long time
<16> we tried SUM()
<16> it complained
<20> any col which is not part of an aggr. func. needs to be grouped by, that's how it is
<19> planet: defined "it complained"
<19> and how did u try SUM()?
<19> arent u the same idiot with the datepart funtion from yesterday?
<16> using MIN() results in the lowest number using MAX() results in the highest number and using SUM() results in ORA-01722: invalid number
<21> does sum die on NULLs?
<16> just a sec pastebin it
<14> whoever said i was wrong that the most inane questions come from oracle users....the defense rests.
<19> im sure sum dies on dates
<19> lol
<16> is this right? http://pastebin.com/657608
Return to
#sql
or
Go to some related
logs:
#windowsxp
#politics
#firebird
berryirc
#computers
ze_Bezt
sirebreni
#solaris
mort kondrakes
#firebird
|
|