| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8
Comments:
<0> so....each store can have the same books....
<0> but they each have their own invetory code
<1> why do you need the inventory code then
<1> why not just get the book names?
<0> i need it lol..if i explained why it would be beyond the scope.....
<0> if though, i could figure out how to return unqiue results in a free text search using CONTAINS, i woudlnt have to take the route i am
<1> you can do anything
<0> i believe! but help me remove the doubt!
<0> lol
<1> not enough information to remove doubt
<1> please insert $0.25
<0> This is the real code, if it is of any interest....http://sql-servers.com/nopaste/?show=299
<0> I want to return results that have unique titles
<1> can you not group by while using contains?
<0> description is ntext, so it cant be used in group by
<0> it tells me, ntext cant be used in group by since it cant be compared
<1> who said group by descriptions?
<1> group by some other identifier
<1> the title
<0> i did, but then descritpion needs to be inclded in the group by
<0> or else it gives me an error....since description is part of the main selection, and its not used in a agg function
<2> Checking for all books with some keyword in either the title or the description?
<2> But, if more than one copy of the same book comes back, you just want to pick one of them at random?
<1> ya
<1> that's ghetto
<0> 100% correct
<1> each book is guaranteed the same description right k00?
<0> yes
<1> why not normalize your data a bit
<0> its like.....two stores could have the same book...but i just want to select that one book, while querying both stores
<3> your mouth could have two cocks but you wanna make it seem like you only had 1 cock
<0> so.....
<0> the route i was taking was
<2> This is cimpletely off the cuff, so, yeah. But, it gets the idea across. item_id is the primary key for tblItems. If it doesn't have oen, make one.
<0> use the freetext to return ids....then, do another select that selects unique titles basd off those ids (select in)....then....take those ids and select the main database
<2> http://sql-servers.com/nopaste/?show=300
<2> You could probably drop out one of the subselects pretty easily.
<2> but that takes more thought thanI want to put into it right now :)
<0> anything you've done is greatly appericated, ty
<0> let me give it a go
<2> Liek the group by I lefto ff. And the the alias on min(item_id)
<0> what do people do in the case of having to select over 50 colums, except for one
<0> select col1, col2,......col49,?
<2> List them out one at a time.
<0> is it wrong of me to ask for SELECT * except COL50 lol
<2> Yes.
<2> So don't do it.
<0> i wont do it..i know it doesnt exist..but would u want somthing like that?
<2> I don't know that I'd ever use it.
<4> SELECT * is bad form anyway
<4> Pull what you need
<0> wow
<0> the MAX worked
<0> SELECT [Title], MAX([item_id]) .............. GROUP BY [Title]...
<0> now i can use those item_ids in a new select that will return unqie results
<4> That already returns unique results.
<0> right, but, i want to select DESCRIPTION, which, is nText
<0> and that can't be included in the group by, or any arrg functions
<4> Sounds like a really bad DB design.
<1> k00 normalize your data
<0> may sound that way, but if you saw the big picture, you wouldnt say that i believe
<1> no we'd still say that
<0> If I were to normalize, I would be removing dup entries, right?
<4> If we saw the picture we'd probably die from an aneurism
<1> haha
<0> But, everything about the entry is a dupe, except for the category id....
<4> Which means that the data is not normalized.
<0> http://www.kottke.org/04/10/normalized-data
<1> i'm not supposed to click links from strangers
<0> heh
<0> i understand.
<0> it may be a virussssssssssss
<0> and your free, mac afee might not be able to stop it
<0> or did u code ur own virus software with TSQL?
<0> select * virus from myharddrive and delete them
<1> bad syntax
<0> prehaps.. :)
<1> perhaps
<0> true.
<5> Super easy question. The MS-SQL version is "select top 1 from..." what is the Oracle equivilent?
<2> Such patience.
<6> <3 andes mints
<7> I'm using access to exclude records from one table field that are the same in a different table field.. this query gives me a cross-product of hundreds of thousands of records: http://sql-servers.com/nopaste/?show=301
<1> learn to join tables correctly
<1> table1, table2 is ambigious and confuses amateurs
<1> it should never be used in that syntax
<1> explicitly specify which join type you are using
<1> then specify the join on conditions
<7> let me rephrase.. i have one table with all my records, and i have another table with records i dont want in my query
<1> select .... from table where id not in (select ids from exclusion)
<1> or you can do an outer join
<7> Darken, that's what i did..
<7> http://sql-servers.com/nopaste/?show=301
<1> no, you didn't
<1> and apparently if you are trying to piss me off
<1> you didn't read the first 5 lines I wrote
<2> Have fun.
<2> ttfn. :)
<7> what's the different from comparing an id and any other random field?
<7> if they match then that's it..
<7> the table/view names seem distinct enough to me
<7> oh
<7> Darken: the second table doesnt have any relation to the first, that's why I'm comparing the email's not ID's
<7> I changed my conditional clauses to what you said (comparing emails instead of id's) with no luck: WHERE [Query1].cont_email NOT IN(SELECT [Mail Sent TO].email FROM [Mail Sent TO]);
<1> pseudo sql
<1> and i don't have patience for this
<1> i told you what to do
<1> go read a book and find out how to impliment what i told you
<1> microsoft has a reference site
<1> so does postgresql, oracle, etc
<7> i like this as much as you do..
<8> its not pseudo sql its 100% legal MS ACCESS :P
<7> perhaps it just eludes him..
<9> how do I select all records where the partno contains a lowercase 'b'
<9> if I do WHERE PartNo LIKE '%b%' it returns everything with an uppercase B too
<9> SQL 2000
<6> i would suggest doing a substr()
<6> er patindex()
<4> Opt: That depends on the collation of the column in question.
<9> hf: yeah, I think that's what I'm being told in #c#
<9> I have a program that is giving me some difficulties because data has been entered with part #'s 232702b AND 232702B...both are supposed to be the same part...but somewhere in the process something is differentiating between the two
<9> the easiest solution might just be to fix my code so it's not case-sensitive, rather than fixing the database/data
<9> when I do ORDER BY's, it should ignore the casing then too right
<9> if so this shouldn't be too big of a problem
<7> I have two views, identical fields.. how do I get View1 minus View2's records in View1?
<10> jimmy using minus :)
<11> lol using minus...
<11> no. use "where not exists"
<10> oracle has minus
<10> and he didnt tell me what he was using, so im telling him how I would do it
<11> wow.. oracle.. i didn't know about it.. :)
<12> does SQL2K have reporting features?
Return to
#sql
or
Go to some related
logs:
#nhl
#windows
#heroin
#politics
#beginner
#hardware
Pujol sucks
#computers
Flash scroll images endless loop
#visualbasic
|
|