| |
| |
| |
|
Page: 1 2 3 4 5
Comments:
<0> sure you could
<0> Accepting poor quality applications must be in your very nature. you are a sql server lover after all
<0> i have better things to do with my time than fix the more basic of os functionality that should never break
<1> Hi
<1> What is the syntax in Ms SQL server 2005 for "SHOW TABLES" in my sql?
<0> http://www.google.com/search?hs=B2F&hl=en&lr=&client=firefox-a&rls=org.mozilla%3Aen-US%3Aofficial&q=ms+sqlserver+show+tables&btnG=Search
<0> 4th down.. identical question
<0> was that SO hard?
<1> :)
<1> Thanks
<2> lol
<2> :(
<2> then howwww
<3> kq : read the documentation as it relates to 'backup'
<2> ahh
<2> enterprise manager
<4> hey, using sql server 2005 express, was wondering when you're doing one of those function query (i.e. calculate the averages on certain fields), if a table is empty, how do you define default values in a query?
<4> 0 instead of null
<5> wladek: isnull(col, 0)
<4> MoZ, merci
<5> and an empty table will have no returned values, period ...
<6> [MySQL/PHP] How can I get a "top entires" from a db with multiple rows only differing by a key. I have a "playlist tracker" for a web radio, and want to get the top played. I ***ume 'group by' and organize by the group size? A row consits of song name, and last played time. So I can have multiple "Artist One - Song Name", just different play times.
<5> KingTomat: #mysql, we don't support MySQL here
<6> ohh, sorry
<7> o/t: does anyone know of a way for me to mirror my outlook mail ? I have desktop and laptop I'd like them to stay in sync
<4> yeah.. get an account on a microsoft exchange server
<4> mailstreet.net offers exchange server hosting for cheap
<8> I'll stay and help if somebody answers this offtopic question, got 37 rows, whats thebest method to concatthose values in a reply? server side, stored procedures?
<8> eeg: 50 rows of numbers, have them return as 1, 4, 6, 8, 9
<9> no one cares if you stay or not
<9> no one is forced to do anything
<8> It's called a bribe, haven't you watched the shield.
<9> let your client do the formatting
<9> that isn't a bribe
<9> it is a punishment
<8> sometimes they like it kinky.
<10> yo
<10> any one awake?
<11> nope
<12> hello all
<12> <9> the problem is that there's no body replying in main channel
<12> I posted my statement just now, could any body help me
<9> no you didn't
<12> yes I did
<12> !
<9> you posted nothing here
<12> not here, don't you know the rules
<4> I saw nothing
<4> and I was keeping eye
<9> i know the rules better than you think
<12> I posted to using the web interface
<4> y'know, for the likes of you
<9> wladek explain the nopaste site please
<9> i'm tired
<12> 3) SQL Code should not be pasted in chan, please use http://sql-servers.com/nopaste
<4> nah, my stew's burning.. brb
<12> ?
<9> you must give us the link to your paste
<9> we aren't mind readers
<12> http://sql-servers.com/nopaste/?show=479
<12> weird, when you view http://sql-servers.com/nopaste/ the site will give you the recent postings. whatever
<12> okay, did you see the statement
<12> ?
<12> hello Darken, did you see the statement?
<13> hello
<14> elder: I saw it...and that's some ugly ****...
<13> heh --> A.TRKNO = B.TRKNO = C.TRKNO ; can't say I've seen that structure before :)
<15> why do you need to self join? I dont get it
<14> not to mention his AND can't ever happen
<15> heh funny.. it cant
<13> it looks like a nice cartesian actually, with a weird-*** boolean after-the-fact
<15> whole thing seems pointless to me
<13> yes, nice obs on the AND lol
<13> Elder, you need to rewrite this thing to actually join A, B, and C
<14> sometimes noobs are so lame it's almost cute
<14> almost
<13> indeed (and he just timed out lol)
<15> heh
<13> I like when you say "get the dba" and they say "I *am* the dba"
<15> poor bastards
<15> been there long ago though
<13> yeah
<13> 1AM diversion: http://worksafevideos.com/movies/rims/led_wheels.htm
<14> heh...one of my neighbors is a cop, the other a drug dealer...I wonder if either of them is paying attention
<13> haha
<13> nice
<15> damn that lame
<13> no doubt
<13> "and you can do it while you're driving!"
<14> if he's not a drug dealer...I gotta wonder about 37 visitors a day...all hours of the night...that stay maybe 10-15 minutes
<15> heh
<13> absurd
<15> a pimp?
<14> never any chicks except one that lives there
<14> can't tell if she's his sister or what...
<15> well..
<15> hes whoring her out
<14> and there are some seriously low cl*** guests...sitting outside honking, tossing trash out the car window
<14> I've gone out twice to tell them to pick the **** up... :) I ain't skeered
<13> maybe they're just filming ATL and you didn't realize it was the movie set
<14> but in townhomes? surely I'm not the only person to notice the traffic
<15> heh
<14> gamble: lol
<14> nah...big boi is from waaaay more ghetto than here
<13> :)
<14> I have friends that live on that side of town...they meet me out front to escort me inside
<14> atl is showing up on cops more than broward or dade county fla lately...scary
<13> I used to live in Broward
<14> ever been on cops? :)
<13> heh, not to my knowledge
<14> nice answer :)
<14> "I uh...can neither confirm nor deny the veracity of that statement SIR"
<13> :)
<12> Hello all
<14> I'm full of 2.00 words today...dunno what's wrong with me
<14> elder: that sql statement you posted is crap
<14> and won't ever work
<13> Elder, the query needs to be re-written to use JOINs
<13> plus as someone else pointed out, if A.TRNKNO = B.TRNKNO AND B.TRNKNO = C.TRNKNO, then you can't also have (B.TRKTYPE = 0 AND C.TRKTYPE = 1)
<13> that's equivalent to saying 0 = 1
<13> opps it says TRKTYPE lol nevermknd
<14> which is pretty unlikely
<13> we misread that one :)
<14> no we didn't
<14> treks as b, treks as c, b.trktype = 0 and c.trktype = 1
<13> sure we did; the joins are on TRKNO, and he wants to compare TRKTYPE, not TRKNO
<13> http://sql-servers.com/nopaste/?show=480
<13> Elder, try that one
<13> the joins were broken, but the TRKTYPE predicates are fine
<14> yeah...but he's comparing all the trkno stuff...AND trktype = 0 and 1
<14> read it again
<13> I fixed it for him (although it still should use ANSI joins)
<14> my neighbor has had three different visitors since we've been talking :)
<13> lol
<13> business is brisk
<14> the chick that lives there seems to be the only one with a regular job too...
<14> this kid is gonna get himself arrested if he ain't careful
<13> TheElder, what's with the query now?
<14> anybody seen that human body dissection exhibit? saw it today...extremely cool ****
<12> I'll check it now
<14> nice...4th guest just pulled up at neighbors...
<14> business is apparently booming
<13> man that's out of control
<14> at least I know he'll never say a ****ing word about how loud my stereo is
<9> if you don't like it move out of the trailer park
<14> I ain't complaining...and that's just it, this is a nice neighborhood
<9> $500k+ houses?
<14> like I said...I can have band practice here at 4 am on a monday morning...and this dude won't say ****
<14> darken: 200 ish...
<14> I'm not that loaded
<9> that's about average
Return to
#sql
or
Go to some related
logs:
#beginner
#beginner
song goodbye so long nice try im gone
#beginner
kemotherapy marijuana
#linuxhelp
#flash
ithought.dk
slap dodges irc
oracle private MT
|
|