| |
| |
| |
|
Page: 1 2 3 4 5
Comments:
<0> oh
<1> hmm.. wish you could do something like SELECT [1..100], dbo.udf_unf() in MSSQL
<0> `osi, true, thanks
<0> how to I check for date, without '?
<2> dbo?
<0> ado?
<2> access?
<0> yeah
<2> i think it is # symbol for date
<2> so ... where order = #date#
<3> Slade: write a procedure ;p
<0> yeah worked perfect
<3> and wtf is [1..100] supposed to mean?
<0> it's funny how I haven't seen anything like that online
<0> thank you `osi
<3> select * from dbo.udf_unf();
<1> moz: i want 100 rows returned. 1 through 100 as the first field. with dbo.udf_unf called for each one
<3> and have dbo.udf_unf() perform your logic ... and return a table
<3> select * from dbo.udf_unf(1, 100); -- rather
<1> there are plenty of ways to do it. i was just bummed out there was no shorthand for expressing a range of numbers
<3> SQL does not work with 'ranges' ...
<1> whats BETWEEN do then?
<3> checks if something is between X and Y ... same as "where x => 1 and x <= 100"
<1> that'd be a range
<3> in the where clause, sure ...
<1> anyhow. yea i understand its not done. it'd just be handy now and then
<3> that's identifying your result requirements ...
<3> Slade: it's a retarded thing to add ... hence the reason it's never been added ..
<3> though if you tell the people in #mysql, they might add it for you over the weekend
<4> http://sql-servers.com/nopaste/?show=363 how do i use the string of ifs with out selects
<2> lol
<1> moz: some dbs already support it.
<3> Slade: such as?
<1> db2 if i'm not mistaken
<3> db2? lol ...
<3> db2 is a special thing all to itselfs
<3> scatterp: wtf does that code do? :)
<1> still sql :)
<3> Slade: not really ...
<4> MoZ well it doesnt do what it should
<1> the diffrence in language is minor really
<4> but i could get help to fix it if i could get it working normaly
<3> db2 is a specially designed database system ... which does support querying with SQL ... though that's not the 'preferred' method
<4> so i need to replace the selects
<4> i dont want it to show the select text etc etc
<3> scatterp: I don't even understand what the hell it's doing ...
<5> scatterp there are easier ways to convert to binary from decimal
<1> moz: sql is a language. it supports a sql variant. so its sql in my book :p
<4> Darken| i asked the other day you said there wasnt only if i write external application :/
<5> moz: a ghetto way to do base 10->base 2 conversion
<5> scatterp no i didn't
<4> oh maybe it wasnt you
<4> i been trying to get help all over
<3> Darken|: yeah, I got that much from the comments at the top ... but it makes very little sense ...
<4> with out much luck
<5> moz :)
<5> scatterp what cl*** is this for
<3> anyway, back to work ...
<4> none
<4> i got a game im working on but lets not go in to it or it will go down the fire the programer bad db router
<4> so how would i remove the selects ?
<5> oh yea
<5> i did say fire the programmer
<4> Darken| i heard it can be done with mod(2) also no idea how
<4> or %2
<5> but i don't recall anything about telling you to do binary conversions in sql
<4> ok
<4> so how would i convert to binary
<5> uhm
<5> that question is simple to answer
<5> but you need to understand the concept of
<5> what base 10 and 2 are
<4> thats what my dad said
<5> and that is a discussion outside the scope of this channel
<4> hence the commented text aat the top
<5> if you want me to explain that to you
<5> you're buying me a pizza
<5> because it is a lot of talking for me
<4> i understand that or can get the understanding off my dad
<4> only thing i need to know is how to remove the selects
<4> really
<1> wtf are you trying to accomplish with that code scatterp?
<5> slade
<4> decimal to binary conversion
<5> base_10->base_2 conversion
<4> im doing it wrong as well i know that much
<4> but what i want to know is how to remove the selects
<1> how does this code accomplish that?
<4> if anyone here knows ?
<1> scatterp: thats not what you wanna know. what you wanna know is how to do this properly
<4> yes slade that would be ideal i suppose
<1> do you understand what mod is?
<4> but i really want to know how to remove the selects also
<4> not really i understand that its relevent
<4> ive tryed to understand how to use it to solve the problem
<4> and failed
<1> did you graduate third grade?
<4> no
<1> ok. you're outta luck then.
<1> mod is a third grade concept known as a remainder in division
<6> heh, customer wants the ability to do wildcard matching on a numeric PK in our software.
<4> cant it be done useing the technic i was trying to use above ?
<7> Halo_Four: what practical purpose would that server?
<7> serve
<6> Apparently they have occasions where they don't have the complete value.
<1> halo: you displace the number eh :P
<1> err
<1> display
<6> The PK is the primary lookup value, yes.
<1> scatterp: i have no idea what you're trying to accomplish with the technique you're showing above
<4> ok
<7> that would make sense if said PK were an invoice number of some type and someone were looking up a smudged hard copy
<4> Slade could you tell me how to remove the select x
<1> scatterp: it seems to be without purpose
<4> statements and still make it work ?
<1> i cant imagine how it works now
<6> sam: Similar.
<4> i just dont want to see the 128 64 32 16 8 4 2 1 in the output
<4> and would like all the output on one line
<1> scatterp: as a shot in the dark are you looking for 'set'?
<4> hmm i dont think so im looking to remove the lines starting select and place something in there place that doesnt output text and still allows the code to parse
<4> and also doesnt make the output apear one line at a time
<4> yes set seems to improve the situation
<4> but the numbers are not printed in a strait line
<4> there like
<4> 0
<4> instead of 0000
<1> i'm not interested in fixing your copy paste code. would you like me to repeat what i said before. you are looking for the set command
<4> i used the set command now
<8> Slade: If not, its is a gross injustice. (re: dailywtf)
<4> http://sql-servers.com/nopaste/?show=364 its in use there
<4> but the results run down not accross
<9> heh
<1> tenfour: is this guy for real?
<9> i am thinking so
<1> Drk`Angel: yea..
<9> scatterp what are you trying to do? print a number in binary or something?
<4> tenfour exactly
<1> its supposed to be a converter from base10 to base2
<4> horizontaly at that
<9> heh "from base 10"
<9> i love that
<9> as if it was printed in base10 somewhere before the conversion
<1> Drk`Angel: take a log submit it to the site ;P
<4> tenfour i have the number i wish to convert in base 10 in a colunm ITEM_T.iAttribute
<1> tenfour: just paraphrasing what was told to me. and yea. its just an int at this point
<9> scatterp it's not in base10 in iAttribute
<9> it's just a number.
Return to
#sql
or
Go to some related
logs:
#beginner
#beginner
#sex
forward 5060
#gamedev
#freebsd
itunes Microsoft RDP Audio Driver
(married with children)nuddy bar
vsmware
#worldcup
|
|