| |
| |
| |
|
Page: 1 2 3 4 5 6
Comments:
<0> well, it seems like he's doing most of what you suggested
<0> well, there are, but he removed them because it was crashing otherwise
<1> i am gonna go relax
<1> :)
<2> ok then for each one..
<2> all u hav eto do is just do what i suggested
<2> look at the dest.. find the first source, then use htat as a dest and find its first source and keep on going
<2> at a max you will have n runs through this before u find hte source you are looking for
<2> n being the total number of data points
<0> ok
<0> well, thanks for the ideas
<2> its not hte fastest route
<2> its A route
<0> ^_^
<0> yeah
<0> go through all those
<0> and find all route
<0> and find the short one
<2> ya so ur basically at n^2
<0> doing it in c++ instead of php may help
<2> lol ya
<2> :)
<0> thanks again
<3> how do you limit your results to the last 25? I tried top 25. Using Oracle 9i
<4> SicWork: sorry had to step away for a sec... THe query is being ran in the Query Builder of vs.net 2005
<2> ugh..
<2> well run it in QA
<2> or whatever the equivalent is in 2005
<4> i cant
<2> y not?
<4> Its a paid-for server.. i have no access to sql itself
<2> planet: where rowcount <= 25
<3> http://pastebin.com/664167
<3> SicWork - will that give the last 25 records entered?
<2> have you tried it?
<3> shoot rowcount doesn't work
<3> it doesn't return any values
<4> hmm i rewrote the sql with different links and it still dont work... im gonna exit vs.net and try again
<2> if you take the rowcount off it works?
<2> Knave: you should be able to run the query right through vs.net
<4> i am. And its failing.
<4> But it works fine in the equivalent to the Query Analyzer
<2> look at teh execution plan
<2> if you can
<4> I dont know how to do that...
<2> unless u have the access i dont know what to tell u
<2> ctrl-k should do it
<4> Hmm ok, tnx for trying
<2> atleast in QA
<2> its in the menu
<2> planet: another thing you can try is: select * from (your query here...) a where a.rownum <= 25
<5> hi. wondering if there is a way to export an sql file with both table structure and data using sql enterprise manager with mssql server...
<2> dk00: look at DTS
<2> right click on the table, export data
<6> !rules
<2> mysqlnoob: just read the online
<2> onjoin
<2> blah
<2> go away
<2> :)
<4> lol
<5> Sicwork, export data only does data, what about structure
<2> what are u exporting it to?
<5> anyway to generate sql script with both structure and insert statements?
<2> you can generate sql for sql but dts will create table also
<2> dont belive the insert statements can be generated
<5> damn.
<2> although....
<2> well what are u exporting to?
<5> flat file.
<2> what is the dest. database?
<3> how do I find the 25 highest ID's and display them desc?
<2> if its a flatfile why do u need insert statements?
<5> i need to backup the tables and data to a flatfile.
<2> planet: select * from (select blah order by id desc) where rownum <= 25
<2> did u try that?
<2> ok well dts will export to whatever u want
<2> almost
<2> including flat file
<2> csv works
<2> tab seperated works too
<5> flat file, only csv, i was wondering if i'd do the statements, so i can put them as part of the sql batch that is created when exporting strucutre
<2> well you can generate a flat file with teh insert with a bit of creativeness :)
<2> ur dts can just output an insert statement
<2> so instead of ur dts doing: select a, b from table c
<2> ur dts can do: select 'insert into table c (a, b) values (' + a + ', ' + b + ')'
<2> and that could be ur dts' output
<2> but then you would hav eto run the sql statements again
<2> i would personally just do a backup of hte actual sql server
<5> thanks for your help.
<3> SicWork - that worked sweet
<3> I didn't know you could build a select from a select
<2> cool
<2> its called a derived table
<3> Thank you.
<7> Derived table, inline view, subselect, and god knows how many other terms depending on who you talk to.
<4> Anyone know why the DISTINCT isnt doing anything with this? http://sql-servers.com/nopaste/?show=548
<8> What are you expecting DISTINCT to do?
<4> Well, im trying to get just the distinct results.. i.e. if it would typically output 'asdf' 5x i want it to only output it 1x. Only output the unique records.
<4> no duplicates
<4> i want it distinct on UserName as well.
<8> distinct applies to all columns, not a single column.
<4> ahh that would explain my problem.
<4> by hiding output of the other it will work it seems ;)
<8> GROUP BY with MIN/MAX aggregates can do what you're looking to do.
<9> q: using mssql.. are views supposed to have a primary key?
<10> hi
<10> i am multiplying two decimal(18,2) values which is producing decimal(18,4) value. is there any way i can round it upto 2 decimal places inside the stored procedure? using sql server 2005
<10> hm there is a ROUND scalar function that i missed.. :)
<11> hello
<11> this may seem like a stupid question, but is there any proper way you should name variables in your db?
<12> which db
<13> oh hey dfworking
<13> ltns
<12> hey
<11> just any database
<11> like say a atheletes diary for a professional institution
<12> you referring to column names or variable names?
<11> well row names?
<12> um, guess they do **** differently in the southern hemisphere
<12> in the northern hemisphere, rows are usually numbers
<11> ah ok.
<12> i was being ironical
<11> well just say like ID, fullname, sname etc?
<11> irc ****s for ironical remarks :S
<12> well, rules of thumb are: no spaces, no special characters
<12> the rest are stylistic opinions
<12> i can give you my own
<12> but everyone has their own way that is best for them
<12> if i have a table, say 'bookmark' (i name my tables singularly), i typically prefix an abbreviation of that to the column name
<12> and separate with an underscore
<12> bookmark: bm_ID,bm_CreationDate,bm_SomethingElse
<12> then camelcase the rest
<12> this eliminates any possibility of having ambiguity in a join
<12> if you have five tables that have 'ID' as a col
<12> ideally you should be using aliases or at least a tablename.columnname format in your queries, so technically it shouldn't be an issue
<14> I use Sybase and i would like to see the code of a stored procedure...how do I do it ?
<11> ah sweet thanks
<11> thanks alot
<12> Marios_, does sybase have catalog procedures like mssql?
<12> try EXEC sp_helptext 'procname' if so
<14> I tried that
<12> and
<14> and it seems I do not have permission...
<14> but using a product dbartisan, i can see the code
<12> does it work via DSN or a direct db connection?
<12> that is, connection string
<14> DSN
<12> so the user/p*** the dsn is setup with has the perms
<14> ok I tried in a different Database now...and I get lines of text =53
<12> you don't
Return to
#sql
or
Go to some related
logs:
wxwidgets rhel3
#goal
korrosive irc
akfighters.net
#politics
#computers
with the wrong persone
#politics
ati radeon x800gto firmware update
#mirc
|
|