| |
| |
| |
|
Page: 1 2 3 4 5 6
Comments:
<0> hmm
<0> really?
<1> it does
<0> you could try, SELECT COUNT(*) FROM tbl GROUP BY col
<0> wait
<0> SELECT COUNT(col) FROM tbl GROUP BY col
<2> this give me the number off occurrennce of each distinct entry
<0> that's what you want right?
<0> its distinct w/o the keyword
<0> since appearently access doesn't support distinct
<2> i want the the number of distinct items in a column
<3> sum.
<3> its dirty
<4> select count(distinct colname) as distinctItems from tablename
<0> does access require an alias
<0> Alexi5: the group by should give you a distinct count
<4> if he's saying 'how many different unique items are in my column', then no
<4> which is what you said
<4> <2> i want the the number of distinct items in a column
<0> umm well i guess it depends
<0> techinically no
<0> it would return one row per item and eadch row would have the count of the item the row was for
<0> so @@ROWCOUNT would be it
<0> anyway, the count(distinct col) should do it
<0> try using the alias
<4> he's not asking for the items themselves, or at least not in his question
<0> my first answer was SELECT COUNT(DISTINCT Col) FROM table
<4> shouldn't be this hard to figure out what someone wants, clearly asking direct questions is optimal
<4> then i agree
<0> to which he replied access does seem to support distinct
<4> no, it doesn't support users that use distinct improperly
<0> how is that using distinct improperly?
<4> its not man, you gave him proper instructions
<4> he obviously didn't DO IT RIGHT
<0> oic
<4> a minor point :/
<0> you example uses an alias, perhaps that will fix it...
<4> save me a spot
<5> lol
<5> wut up
<4> sql2k on a win2003 64 bit server anyone?
<4> friend says its not taking his serial number
<1> is it a supported configuration?
<4> don't know, i'll tell him to verify
<6> how do you get SQL to parse an Access file?
<1> sql, or "sql server" MS's bastardized database server?
<6> eh
<6> what's sql?
<6> I thought there was just MS SQL and MySQL
<1> sql is a language for quering data in any server that supports it
<1> mysql and ms sqlserver are 2 pile of crap servers that use it (somewhat)
<1> there are dozens more
<4> there are also overpriced database systems where price per performance ratios are skewed to an unappealing degree that use it as well, such as oracle
<6> so what's a decent one?
<4> you're providing no criteria for knowing what a 'decent' anything is
<1> IF you have an application and database where the data is important.. use oracle
<1> if you are an idiot and need point and click and idiot friendly everything, mssql or mysql
<1> but we dont support mysql here. goto #mysql
<4> if you have hundreds of thousands of dollars lying around, then use oracle. if you want to be productive and cost efficient and still get an enterprise grade rdbms, use sqlserver.
<1> The uneducated arent aware that Oracle is priced many ways: Free, $3-5k, $15k/cpu (usually you can get 35% discount), or $40k/cpu (usually you can get 25-35% discount and other deductions)
<1> So, its very affordable no matter your company size =)
<6> oracle is garbage
<4> also, apparently using oracle makes you so efficient you can idle on irc a LOT
<1> Absolutely
<4> Chauncey, yes, its a toss up really, access or oracle
<4> its a tough call. go with your gut.
<1> Im paying $75k to upgrade one of my db servers to enterprise this year. It'll save me $30k a year in tapes alone. =) Plus performance improvements which are too hard to put a specific price on, will make it so much better value woot woot
<6> what's wrong with warez
<7> Chauncey has a valid point
<4> nothing man, go warez oracle. thats the other price point rjarett neglected to mention.
<7> hehe
<6> oracle isn't worth warez'ing
<6> only place you'll find oracle is in my recycle bin
<4> you're a stud, Chauncey
<4> i'd have to guess that with a **** as big as yours must be, flat files would even work for you
<4> clipper perhaps
<4> filemaker pro
<6> you use filemaker pro?
<0> when did _Kal-EL start trolling in here
<7> vive le mac
<7> MuteThis =P
<0> is nowhere safe
<7> hehe
<7> who helped you with your sql all these years ?
<7> <-- ofcourse
<7> what an ungrateful guy :-)
<0> hah!
<6> he should sign his paychecks over to you
<7> yeah MuteThis, i have started to count interest already =P
<7> that nice car you have, its time to sell it
<7> hehe
<0> my beater?
<6> beamer?
<0> i'm so poor most of the time i hitch hike to the office
<6> what are they paying you
<7> stop dogging me out MuteThis
<7> i want my money
<0> i make just over minimum wage, what ever i take home i drink in booze
<0> and you can't have my booze
<6> rjarett: what are you going to use instead of tapes?
<6> a slave to alcohol
<1> Chauncey im still using tapes as part ot the backup method
<0> _Kal-EL: i'll send this guy after you... www.bad***coders.com
<7> hehe
<1> but with incremental backups, block level backups, and being able to apply incrementals directly to past fulls my total backup sizes weekly have dropped by almosy 90%
<0> that's me with a co-workers head photoshopped on
<1> Plus archive log generation has reduced drastically because of changes ive been able to make
<1> lto-3 tapes arent cheap :P and its much cheaper to store 3-4 of them offsite a month than 20-30
<6> who do you work for?
<1> My boss
<6> what company
<1> It's IRC... and a channel full of punks
<1> i dont release that sort of info
<6> not asking you for your address geez
<6> MuteThis: if you like playing with guns why don't you goto iraq
<0> ummm
<0> I'm to ***y for Iraq
<0> can't you tell?
<6> too chicken **** more like
<1> Not alot of shooting in iraq. more in Philly nowdays
<6> so I guess the insurgents are killing soldiers with rocks
<1> no the terrorists are using IEDs
<1> there are no insurgents. since most of the people attacking the iraqis are saudis, iranians, pakis and others. Insurgency would mean the iraqis were fighting against their own govtm instead a majority are fighting for it, and even more voted for it
<1> hippy
<6> why didn't this happen in the first gulf war?
<1> because the UN wouldnt allow our troops to enter or liberate baghdad
<1> They bathe party and terrorists had a safe haven
<6> there weren't terrorists until saddam was toppled
<1> yeah tell that to the people who died in the 1993 WTC bombing
<6> they came from saudi arabia not iraq
<1> and?
<1> Anyone who supports terrorists is a terrorist
<8> Good morning gents, I have a database that has a full log file and won't allow me to do anything
<1> Iraq was warned
<8> is there anyway for me to back it up and clear it?
<1> If iraq didnt want to get defeated they would have allowed inspectors to do their job
<0> this is why i ignored his statements
<1> And we have found planes, jets, and arms which were banned for Iraq to have after the gulf war... but they sitll had them
<6> does the u.s. have inspectors?
<0> TRUNCATE CHANNEL #sql
<1> Plus we lost rights to our bases in turkey so we needed another central arabian location to setup a mountpoint at
<0> INSERT INTO #sql (Topic) VALUES ('is there a way to get partition statistics in sql 2k5')
<6> afghanistan wasn't good?
<6> are you a republican rjarett?
<1> Republican/constitutionalist
<6> lol
<1> are you a hippy?
<8> if you don't see flaws in the way the constitution is currently being followed, then you're as blind as the rest of the people on the earth
<8> which is pretty easy
Return to
#sql
or
Go to some related
logs:
googl naps
#computers
#mirc
#linux-noob
#mirc
craftmatic salesmen
hustlercentral ashley
#computers
#beginner
#stocks
|
|