I have a single table that contains information of photos
ie.
ID PhotoName PhotoTags
23 my cat cat animal pet
24 cell phone electronic communication
25 tiger animal zoo
What would be a possible way to write a query that returns similar items
- share similar tags, similar photo name
can this be done with a sql query?
Thank you
Tem 6 1454
need to join the table on itself for this. note it will be SLOOOOWWWW if
the table is huge.
select t1.*, t2.*
from yourtable t1 join yourtable t2 on t1.photoname = t2.photoname
and t1.phototags = t2.phototags
--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"Tem" <te*****@yahoo. comwrote in message
news:uU******** *****@TK2MSFTNG P06.phx.gbl...
>I have a single table that contains information of photos
ie.
ID PhotoName PhotoTags
23 my cat cat animal pet
24 cell phone electronic communication
25 tiger animal zoo
What would be a possible way to write a query that returns similar items
- share similar tags, similar photo name
can this be done with a sql query?
Thank you
Tem
thanks ill try it
"TheSQLGuru " <kg*****@earthl ink.netwrote in message
news:13******** *****@corp.supe rnews.com...
need to join the table on itself for this. note it will be SLOOOOWWWW if
the table is huge.
select t1.*, t2.*
from yourtable t1 join yourtable t2 on t1.photoname = t2.photoname
and t1.phototags = t2.phototags
--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"Tem" <te*****@yahoo. comwrote in message
news:uU******** *****@TK2MSFTNG P06.phx.gbl...
>>I have a single table that contains information of photos
ie. ID PhotoName PhotoTags 23 my cat cat animal pet 24 cell phone electronic communication 25 tiger animal zoo
What would be a possible way to write a query that returns similar items - share similar tags, similar photo name
can this be done with a sql query?
Thank you Tem
If you are on 2005, check Term Extraction and Term Lookup Transformations
You can build pretty much "smart" service on top of this
If you are interested in fuzzy matching - you can take a look at Fuzzy
Lookup and Fuzzy Grouping Transformations
--
Mikhail Berlyant
Senior Data Architect
MySpace.com
"Tem" <te*****@yahoo. comwrote in message
news:uU******** *****@TK2MSFTNG P06.phx.gbl...
>I have a single table that contains information of photos
ie.
ID PhotoName PhotoTags
23 my cat cat animal pet
24 cell phone electronic communication
25 tiger animal zoo
What would be a possible way to write a query that returns similar items
- share similar tags, similar photo name
can this be done with a sql query?
Thank you
Tem
this is very cool!
"Mikhail Berlyant" <tn*******@ecap sym.mocwrote in message
news:OK******** ******@TK2MSFTN GP05.phx.gbl...
If you are on 2005, check Term Extraction and Term Lookup Transformations
You can build pretty much "smart" service on top of this
If you are interested in fuzzy matching - you can take a look at Fuzzy
Lookup and Fuzzy Grouping Transformations
--
Mikhail Berlyant
Senior Data Architect
MySpace.com
"Tem" <te*****@yahoo. comwrote in message
news:uU******** *****@TK2MSFTNG P06.phx.gbl...
>>I have a single table that contains information of photos
ie. ID PhotoName PhotoTags 23 my cat cat animal pet 24 cell phone electronic communication 25 tiger animal zoo
What would be a possible way to write a query that returns similar items - share similar tags, similar photo name
can this be done with a sql query?
Thank you Tem
Table Tags
ID TagName PhotoId
1 cat 23
2 animal 23
3 pet 23
4 animal 25
select PhotoId from Tags where PhotoId = 23 and (other photoId that has 23's
tags)
Need some help with this sql statement
"Tem" <te*****@yahoo. comwrote in message
news:uU******** *****@TK2MSFTNG P06.phx.gbl...
I have a single table that contains information of photos
ie.
ID PhotoName PhotoTags
23 my cat cat animal pet
24 cell phone electronic communication
25 tiger animal zoo
What would be a possible way to write a query that returns similar items
- share similar tags, similar photo name
can this be done with a sql query?
Thank you
Tem
So is the requirement that there must be a match on ANY tags of PhotoId = 23
(in which case, PhotoID = 25 WILL match) or is it that you want a match on
ALL tags of PhotoId = 23 (in which case PhotoId WILL NOT match)?
--
Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada https://mvp.support.microsoft.com/profile/Tom.Moreau
"Tem" <te*****@yahoo. comwrote in message
news:ua******** ******@TK2MSFTN GP02.phx.gbl...
Table Tags
ID TagName PhotoId
1 cat 23
2 animal 23
3 pet 23
4 animal 25
select PhotoId from Tags where PhotoId = 23 and (other photoId that has 23's
tags)
Need some help with this sql statement
"Tem" <te*****@yahoo. comwrote in message
news:uU******** *****@TK2MSFTNG P06.phx.gbl...
I have a single table that contains information of photos
ie.
ID PhotoName PhotoTags
23 my cat cat animal pet
24 cell phone electronic communication
25 tiger animal zoo
What would be a possible way to write a query that returns similar items
- share similar tags, similar photo name
can this be done with a sql query?
Thank you
Tem This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: tshad |
last post by:
How do I find (and set) a couple of labels in the Footer after a DataGrid is
filled?
I have a bunch of DataGrids that get displayed nested inside a DataList.
The datagrid looks like:
*******************************************************************************
<asp:DataGrid visible="False"
border=1
|
by: oscar |
last post by:
i've created a search function, using vc#, and i'm using the dataview.find()
method to get the index of the found record. the problem is that there are
many similar names. it always returns the same index, but it can be any one
of the items. as an example, if i type in the work "bolt" it will return the
index 1201, the first "bolt" is at 1120 and the last one is at 1294. it is
for a point of sale program and i have no control over the...
|
by: Pieter |
last post by:
Hi,
I have my own custom BindingList, that inherits from BindingList, and
implements IComponent.
I would like to implement a Find-method, that will allow me to search for a
property of my Items.
So basicly: If my Items in the List have a property Name, I would like to be
able to return with this method all the items that have Name = 'Bill Gates'
etc.
|
by: Drew |
last post by:
When is it appropriate to use dict.items() vs dict.iteritems. Both
seem to work for something like:
for key,val in mydict.items():
print key,val
for key,val in mydict.iteritems():
print key,val
Also, when is it appropriate to use range() vs xrange(). From my
|
by: moondaddy |
last post by:
I had to repost this because I had to update and change my msdn alias. I
will re-ask the question and clarify a few things that were not clear
before.
This code is all executed on my dev machine running winXP sp2 and VS2005.
I'm using a c# 2.0 winforms app which talks to a c#2.0 asp.net app that also
contains 1 web service. Note: the webpage and web service are located side
by side in the same web app.
| |
by: =?Utf-8?B?VGhvbWFzVDIy?= |
last post by:
Hello,
I have an array that holds 4 values ( they contain random numbers). I would
like to find the lowest value (if there is a tie i would like to find one of
the tie.) then remove that value. I am new to Programming and C#.
Thanks for any help you can provide
Thomas
|
by: Academia |
last post by:
I like to be consistent in the way I name items.
Unfortunately I changed the rules a few times as the code developed.
So I'm sure I have things like:
Private Sub XYZ_Click(ByVal sender As System.Object, ByVal e As EventArgs)
Handles ABC.Click
I can't spend a lot of time on this but it would be great if I could easily
|
by: =?Utf-8?B?UGhpbA==?= |
last post by:
I have seen the samples for Find that explain how to use the predicate, but
they are always searching for a pre-defined value. What I don't understand
is how to search for a random value stored in a variable.
For example,
List<intitems;
int val=3;
items.Add(1);
|
by: Payne |
last post by:
Hello, I'm having trouble figuring out how to best explain my problem
but I hope I can make myself clear enough. Anyway, I'm doing an
assignment for school and in this one we're supposed to write a simple
"database" class. The interface of this database class supports adding
items, removing items, obtaining information about how many items are
stored etc. In the assignment the database is supposed to support only
storing items of a...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |