| |
| |
| |
|
Page: 1 2 3 4 5 6
Comments:
<0> any1 here alive?
<1> you mean ORDER BY CASE WHEN field = NULL then -1 ELSE field END
<0> no
<0> its without using if or case
<1> then what do you mean
<0> i dont remember the syntax
<0> its order by field1 starting with 4
<0> or somthing like this
<0> and it start the order from the value 4
<1> try not ignoring cojones
<0> and go on
<0> uh?
<2> what rdbms?
<3> Carpathia: is it possible to use that function on an Access system?
<0> its a bunch of letters
<1> oh god, no
<1> [rb] thats mssql . i always ***ume mssql when ppl dont say otherwise
<1> and if it doesnt work, then its no longer my problem :)
<0> what the ****?
<0> what was that good for?
<4> sigh.
<1> why dont you just calm down needhelps
<0> to show off ur highly op power?
<0> im totaly calm
<1> good
<0> i dont know why he kicked me
<4> Read the kick message, read the topic, then read the small flood of rules that you get when you join.
<4> All of which you obviously haven't done yet.
<0> i flooooooood?
<1> because he asked you a question
<1> and all you do is talk, without answering that VERY important question
<0> i didnt know it was address to me
<0> duh
<0> say needhelps:
<0> or somthing like this
<1> no
<4> Someone really needs to work on their reading comprehension.
<0> i thought he was asking the channel a question
<1> you could try following the conversation perhaps
<0> excuse me?
<1> oh go away
<1> im tired of you too now
<0> he said 2 words
<0> whats rdbmps
<0> or somthing like that since i had no idea it was reffer to me or even what it ment
<3> Carpathia: ah, I see, yeah, I started my question with [Using Access] =) no problem.. I can write an equivalent function in VBA in Access
<0> ok so now lets start this again
<3> Carpathia: although your function is very good
<1> hehe
<0> does rdbmps have something to do with my kind question?
<5> using mssql, can you use select into to insert records in a table that already exists? if so, specify the fields that the data goes into?
<1> its rdbms
<1> what database system
<0> sorry
<0> oh
<0> sql server obviously
<1> yes tapped
<1> insert into blah (f1, f2) select f1, f2 from table2
<0> but its a part of the sql language i dont think its system depandent
<5> cool
<1> there is no standard sql in the real world
<0> hmm well there is
<3> Phargle: you mentioned the use of a fulltext index.. can you elaborate just a little so I know where to start searching?
<1> no, theres standards.
<1> thats not the same
<3> ANSI92?
<0> yes
<0> well its a standard
<1> sure, but if you adhere to it fully, it usually makes things very difficult
<0> does any1 know the syntax to my question pls?
<3> needhelps: right, and that statement is the same on m*sql oracle sybase, etc.
<1> no because we dont really know what youre asking
<0> [rb]: do u remember the syntax?
<1> why do ppl come here for help, then proclaim theyre experts
<0> Carpathia: i ask this
<3> needhelps: I can't find your question in your 200 statements, try calming down and writing one clear question and waiting for an answer
<3> needheps: that is, write your question and hit <Enter> ONCE. Then just wait.
<0> in the order by clause there is a syntax to let u start the order from a certion value (or display that value and then order)
<0> like order by field1 asc - so the asc say to order it from top to buttom
<0> so im saying there is such a syntax to let me do what i've asked
<0> i just cant remember it
<1> so when ordering from 1-10 you want to start from 4 ?
<0> and ask if some1 remember it
<3> needhelps: jesus kid, drink less coffee
<0> well in more general (its not numbers)
<1> heh
<0> and with out the if
<0> or case sentance
<1> yes, lets keep a simple example
<1> so when ordering from 1-10 you want to start from 4 ?
<0> let me write it again
<6> [rb]: if you use mssql try reading bout the freetext clause to get your feet wet without getting bogged down in the tech side of createing fulltext catalogs and such
<3> needhelps : google search "sql order by syntax" - first response: http://www.1keydata.com/sql/sqlorderby.html
<0> in the order by clause there is i belive something called starting with or somthing like this to make the order start from a certion value or to display a certion value on top and then go on with the order
<0> already used google btw
<2> and you use what database?
<3> phargle: again, no mssql, just msAccess
<0> sql server
<2> its not part of order by
<1> there is nothing like that for sql server
<2> doesnt mssql use limit?
<0> are you all sure?
<1> unless you use CASE
<2> oh.. mssql uses top
<1> i dont even know what hes asking anymore
<0> CoJoNEsXX: are u sure?
<1> you want to do pagination, is that it ?
<2> so use top in a subquery and then a subquery
<0> pagination?
<2> yeah he does Carpathia
<2> SELECT TOP 5 * FROM Users
<1> jeez, what a long winded way of explaining it
<4> mysql has pagination functions. I don't think any real db does.
<0> i dont want to select top
<2> select top 5 * from (SELECT TOP 10 * FROM Users) order by blah desc
<2> something like that
<1> i thikn you dont even know what you wanna do yourself
<2> my mssql is horribly rusty
<0> lets say i have a field containing 10 numbers from 1 to 10
<0> and u want to display it in asc order from the number 3
<1> and then what?
<2> needhelps http://www.dotnetjunkies.com/WebLog/warstar/archive/2004/07/13/19135.aspx
<0> i.e 3 1 2 4 5 6 7 8 9 10
<1> what when it goes 3,4,...10, after that ?
<1> yes, you use CASE
<1> damn, youre infuriating dude
<0> sorry if i upset u
<0> but i meant with out case
<1> why without case?
<1> youre imposing restrictions without giving any real reason
<0> CoJoNEsXX i believe there is a simpler way than 3+ inner selects
<2> there isnt
<0> Carpathia: im sorry that i impose this restriction
<2> thats why there are articles on it
<1> ORDER BY CASE WHEN field = 3 THEN -1 ELSE field END
<0> but its a must
<1> im sorry too
<1> then at least explain why you cant use case
<2> cause he thinks its easier
<1> who can say
<1> since it seems he wont
<4> needhelps: Check here. Then, once you'ev figured out that there is NOT OTHER WAY, feel free to use the case method
<4> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sa-ses_9sfo.asp
<1> also if you cared to read obooks online, youd see the EXACT syntax for ORDER BY and realise what a fool youve been
<1> Syntax
<1> [ ORDER BY { order_by_expression [ ASC | DESC ] } [ ,...n] ]
<4> Maybe he's thinking fetch relative for cursors.
<4> Dunno.
Return to
#sql
or
Go to some related
logs:
_judas_
#linuxhelp
#beginner
#redhat
+sql server 2000 +datepart +performance +group by
#beginner
#firebird
javascript onmouserelease
#gentoo
#politics
|
|