| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9
Comments:
<0> I think you'll have to at least drop and recreate the column with an alter table.
<0> Dunno, never have had to do that
<1> actually with MSSQL I don't, but I am having an issue doing it with Oracle
<1> and none of the oracle people are alive lol
<0> mssql cheats. Look at the sql that enterprise manager makes to do that.
<0> it copys the table to a temp table, drops the old one, makes a new one, and copies it back :)
<1> ahh figured it out
<0> I was wondering how it did it one day because I couldn't find it documented. :)
<1> I hate how Oracle and MSSQL are so different
<0> I still prefer generators over autoinc fields.
<0> But I haven't used oracle in years.
<2> Drk: Actually I think you can modify the column definition with an ALTER TABLE statement without having to recreate the table.
<2> Yeah, that works just fine.
<0> Halo: there was some weird alteration that ent manager did a table copy for. I was just impressed that it would do that automatically.
<0> I don't remeber what it was. This was about 3 years ago.
<2> EM does it for a lot of reasons, possibly even altering just a column as well.
<3> well, SQL Server recreates the table
<3> if you just increase the size of a varchar column
<2> EM does
<3> yes
<2> ALTER TABLE dbo.Poo ALTER COLUMN [Value] VARCHAR(100) NOT NULL; <-- works fine
<3> ok
<3> wonder why EM does it that way then
<2> EM is pretty stupid :)
<0> Stupidity, I
<0> I'm going to ***ume at this point :)
<2> But EM lets you get away with murder, too
<0> EM has made me lazy. I almost miss Oracle doing everything in SQL*Plus :)
<4> is it ok to keep asking if new people enter the room?
<4> i know this is wrong... select Email,Answer,max(SubmitDate) from Comp group by Email .. but how do i return the persons latest answer only per email address (possible multiple entries)
<5> group by all the other columns
<6> drhyde_
<4> it doesnt return the specific entry tho
<6> does he ever come around anymore now that he got his new jobby job?
<4> i need to return only one answer per email address and that needs to be their latest answer
<5> select email, answer, max(submitdate) as submitted from comp group by email, answer
<4> that gives me multiple duplicate email addresses
<4> say one person entered 4 times
<4> i only want his latest answer
<4> that would give me 4 results for that email address
<7> um, no
<4> because you've grouped by email, answer if any of the answers are incorrect it'll return them as a separate row
<5> select email, answer = (select top 1 c.answer from comp c where c.email = email order by submitdate desc) from comp
<4> damn i've got the wrong channel open sorry
<5> i was lazy with the aliases, fix them
<4> this ones for mysql
<4> apologies
<5> no need for apologies, your usage of mysql is punishment enough.
<4> no subqueries in this version so yes it should be that simple but unfortunately it isnt
<4> indeed!
<4> i use both but unfortunately this project is mysql
<0> Upgade to mysql 5, or suffer.
<4> agreed, if only IT would
<8> mysql ****s
<0> Also, read the topic.
<4> i did. i've got #sql and #mysql open, i clicked on the wrong tab ok?
<4> thats why i apologized
<0> ah, ok :)
<8> mysql ****s
<8> [10:29] * Now talking in #mysql
<8> [10:29] * Topic is 'Lazy people will be banned. MySQL questions only. #php for php. #phpmysql for the misguided #wimp for the rest'
<8> [10:29] * Set by hub.efnet.nl on Wed Jan 11 07:18:15
<8> [10:29] [wobblie1 VERSION]
<8> [10:29] * nogger sets mode: +v ShrikeX
<8> [10:30] <8> shouldnt you all be banned for using mysql? Isn't that the essence of stupidity and laziness?
<7> heh
<0> How long did the ban take? :)
<8> I /part'd
<9> i am selecting an hour and minute from different columns and now i want it to look something like this once the select statement is done colHour =1 colMinute=15 -->1:15,how can i change the format to this?
<10> mysql's great as long as you don't consider data and transactional integrity as basic features in a RDBMs. :-\
<9> i am using sql server 2000 btw
<8> so is a voodoo stick and an etch-a-sketch gripe
<10> i was being sarcastic
<8> I wasn't
<10> were too
<8> no way
<10> way
<11> Halo_Four remember my odd app loading issue I mentioned yesterday. .. where the app just loads every time i login?
<11> I figured it out ...
<11> the app was VbsEdit ... a nice little editor for VBScripts ...
<11> I told it to ***ociate itself with .vbs files ...
<11> when I log onto the domain, the logon script is a .vbs script, and instead of being run ... VbsEdit tries to edit it...
<2> hehe
<11> I never paid attention to the script that was in the editor till right now, I just kept closing it ... figuring it was the last script I worked on
<2> Funny that the login policy doesn't explicitly know to run it with cscript.exe
<2> or wscript.exe
<11> yeah, I know ...
<11> now to figure out how to make vbsedit stop editting the damn scripts
<2> Flip the ***ociation back to wscript?
<11> yeah, that was actually easier then I thought ... right clicked a vbs file, open with ... "Windows Scripting Host" was an option ..
<11> thought I might have to manually tell it to run %winsys%\wscript.exe and possibly p*** parameters to it ...
<11> *shrug* ... tsk tsk ... shoulda known better
<9> http://sql-servers.com/nopaste/?show=155
<11> bbl
<5> anyone used fulltext in sql2005 and can compare its performance to 2k
<12> hi
<12> i am using access and i set a date field as shirt date(without time) but when i output the date field in my asp page teh time appears along wth the date
<12> how can i prevent this
<13> try truncating the date on return
<12> how do i do that?
<2> format at the client
<12> ok
<14> in sql2k is it possible to turn the rank output of a full text search into a percentage?
<5> not reliably
<14> a percentage of result relevancy that is
<5> order by rank and just be done with it
<5> thats not how they calc relevancy
<5> fulltext is really limiting this way
<11> digitalml ... http://msdn.microsoft.com/SQL/community/webcasts/FullTextSearchQandA.aspx
<14> yah i know ive done lots of reading on it, i was hoping someone might have found a way
<11> Paschal Asked: Do you know a way to transform a RANK as a valuable item in percentage like many other search products ?
<11> Answered Privately: You can find the largest rank from your result set and calculate percentage by divide the largest rank.
<14> _zoul_ i read that
<14> but that calc doesnt work
<5> blah
<11> digitalml, how does that calc not work?
<5> thats a bull**** approach to an impossible problem
<11> heh
<14> can i take the full text catalog sql created and use indexing services in 2003 on it?
<14> i hear the indexing services can return a result relevancy percentage
<5> for documents
<5> not db
<14> well these are esential text files filled with words
<14> and indexed
<5> then use indexing server
<5> not fulltext from sqlserver
<11> heh
<14> no no
<5> same basic technology, but indexing server has better options
<14> im asking if i can take the fulltext files generated from sql server
<14> b/c the data indexed IS from the database
<5> i don't believe so, no
<14> ok then i guess its order by RANK then... :)
<5> you have to order by rank and adopt the position of 'these are ordered most relevant first, trust me' to the user
<11> google doesn't give a relevancy percentage, do they?
<11> nope, they just show the results ... and we ***ume their "most relevant first" :)
<11> aside from those results which are "pay the most for ads first" ... of course ;)
<14> gotcha
<5> if google jumped off a bridge, would you too?
<14> yes
<15> hmm.. so if I have 100 million cells of completely pre-aggreagted data,, instead of hacking them into a data warehouse, I might as well just query the rdbms tables directly, with relevant indices...?
<11> dfworking, most likely ... yeah
<5> inge, yes i think so
<14> anyway to fts on fields with integer values?
<15> fts?
<11> digitalml is the column a text column ... ?
<11> or an integer column
<11> cause if it's an integer column, I'm gonna smack you for asking if you can full-text search it ...
<15> :)
<15> ah
<5> i'm out. later
Return to
#sql
or
Go to some related
logs:
#gentoo
seafate 250 gb sata2
CONOC stock symbol
#dsl
#sex
listen complete gotoandplay
#cph
#beginner
#politics
akbar tabon
|
|