| |
| |
| |
|
Page: 1 2 3 4 5 6
Comments:
<0> however in actuality categoryID is a uniqueidentifier not an int
<1> ut oh, you're trying to order by a field that doesn't exist
<1> sash look at the columns in the WHERE clause, those at least, should be indexed
<0> is there anyway to convert a uuid to a bigint?
<0> or a piece of it
<1> cast(blah as bigint)
<0> Explicit conversion from data type uniqueidentifier to bigint is not allowed.
<2> guest actualy the field is indexed, it's id
<1> cast(left(blah,23) as bigint)
<3> hash it
<0> oops that was with convert
<4> uuid is 16 bytes... bigint is 8?
<3> checksum() it
<3> checksum(catID, @someseed)
<4> Kaine: what are you trying to accomplish?
<1> sash so id is the only thing in the where clause?
<1> yeah, it probably has a PK clustered index on it too
<1> foodtime for me....
<2> it looks like 'delete from searh where id search.id=temptbl.id' id's are index
<5> not to undermine the power of SQL... but kaines problem would be very easy to solve client-side.
<5> =)
<3> yea
<0> yeah i am well away
<0> aware
<0> hwoever in this case it would not be... really dont want to get into it. :P
<0> so shshhh
<3> unless he only needs the top 5 random rows... that would be best done in a query like this imo
<5> you could do it in a stored proc more easily, I believe. but lemme go get some food and chew on this (and my food)
<0> it is a stored proc
<0> and i think i got it :D
<3> did the checksum thing work
<0> yes
<0> let me clean it up a bit
<6> Hi guys! I need answer to a small question: Is there any simple way of testing if a tupple exist in _all_ of a relation (not like the EXIST func)?
<7> is this homework?
<8> no one actually uses tupple in conversation, it must be
<9> yup
<9> either m*** nerd or a student
<10> yep
<10> big up :)
<9> big down.....your throat
<10> haha
<10> you are nice
<10> yup for east
<6> so I guess you don't know the answer....
<11> HiQee: be more clear with your question
<6> you've got the EXIST function to test if a condition matches at least _one_ of the rows in a query (ex. WHERE x EXIST IN(SELECT b etc.etc) - Is there a simple way of checking if x matches ALL the result in the nested select, and return false if not?
<10> my best friends from sweden
<8> how can it match all?
<8> exist isnt like
<10> finland
<8> its =
<10> france
<10> germany
<3> HiQee maybe you need to test for the opposite condition
<3> instead of testing for all of something, test if any aren't
<10> quant are you from swedish?
<10> err
<10> are you swedish?
<8> jetair stfu
<10> ok
<8> thanks
<10> np
<8> HiQee your question does not make sense, there is no way it can be = to everything
<12> HiQee: select where it doesn't match.
<12> then your exists wil fail.
<12> err, your exists will succeed.
<12> which to you is a failure. ;)
<13> hey what's the command in SQL to print the defintion of a sproc again?
<13> its like "helptext" or something
<14> state your rdbms
<13> SQL Server 2000
<13> you type like "helptext spYourSproc" and it types out the sproc definition
<13> so you don't have to actually open the sproc every time
<13> anyone?
<13> ahh
<13> for anyone interested
<13> sp_helptext
<15> yea sp_helptext
<16> hi all, using ms enterprise manager and exporting some data to excel using a query...any idea why every field in my xls file has a single quote (') in front of the value?
<9> yea
<15> because you said the destination column was text prolly
<9> this tells excel to format it as a string i think
<3> yep
<3> ' tells excel to treat it as text even if it's a number or date or whatever
<17> which is quite good because else excel sometimes has weird ideas about the data ;)
<3> yea it likes to overwrite data
<16> ok i see, well how can I remove it lol
<16> I don't see any options in the SQL export to not do that (all the fields are text anyway) and doing a find and replace doesn't grab it, plus I don't want to remove all quotes as I have data with quotes in it, like names (O
<16> O'Brien)
<3> why do you need to do that
<3> in excel it looks just fine, right?
<3> if you really need to, go into excel, select everything, and edit->paste special -> values
<3> and it will remove the '
<3> i think
<16> well looking at it yes, but for copy/paste purposes
<18> tenfear
<9> StoneCyqh is here now
<9> hahhahaha
<18> now?
<3> ken- it should copy just fine (won't have the ')
<3> it's similar to a formula in excel
<3> if you copy a formula cell, it will copy the value (what is visible)
<16> thanks, that worked :)
<19> Recognize-Security : Many e-books about : Network , Programming , Security , Encryption , Os (un1x \ fbsd \ win \ etc ) , Social engineering , hard\software : check it out > www.rec-sec.cjb.co.il or www.recognize-security.cjb.co.il
Return to
#sql
or
Go to some related
logs:
62 percent of Oscar winners can be genealogically traced to a common great grand
#linuxhelp
#c
#slackware
#debian
alex sartan
jews not human extermination
was sadaam shiiate or sunni
#online
still set to Factory gentoo
|
|