Matching Users Profiles Using Sql

May 5, 2007

Hi folks

I have a section in my networking site where people can write things about themselves, such as likes dislikes, hobbies etc for their profile.

I am looking to provide a very basic profile matching service, and have done a bit of searching to find out what the best way to approach this feature is. I have looked at using the sql LIKE clause, but since the profile information can be any length, there seem to be too many variables to account for. I have also looked at identifying keywords in profile blurbs to do the matching too, but I am struggling to see how this could be done with relative ease.

My reason for posting this is simply to get some experienced knowledge about where to start the problem, of even some resources to look at that I may not have found yet.

If anyone could give me some advice on where to start i would be very grateful

I am develping in vb, with an sql server 2005 back-end

View 2 Replies


ADVERTISEMENT

How To Find Matching Profiles?

May 6, 2006

Users have to answer 17 simple yes/no questions and the answers are stored in an column for each question as tinyint 0/1 values.

At least that's what seems reasonable to me at the moment.

The table is under my control so I could change it if needed.

Now from several tenthousend or maybe hundreds of thousends of entries I need to find those with the closest match. Of course, I need all of the entries that have the exact same answers and this is no problem. But - at least if there are not enough full matches - then I need all records that have maybe 16,15,14... matches out of the 17 answers.

I have not yet the idea on how to handle this without quering 17*16 different answer schemes.

View 7 Replies View Related

Returning Matching/Non Matching Records

Feb 4, 2007

Hi All

I have a strange request that might not be possible based on the laws of relational databases but I thought I'd give it a try.

I have three tables which for simplicity I will call A, B and C. Table A contains my master records, Table B contains user details and the final table contains some extra data

In my initial search when joining A and B, I return 100 records. I then need to search in table C for these 100 records based on a criteria. the expected result should return all 100 rows for the ones that match and also the ones that do not match. The problem is that in Table C, not all the 100 IDs exist, so there will not be a corresponding record. Unfortunately, our users still want to see all 100 records in the output. Is this possible

As always any help or direction would be appreciated.

View 5 Replies View Related

SQL Server And Profiles.

Mar 16, 2006

I've created a website using Microsoft's built-in profile/membership system. I'm used to referring to these elements without actually having to interact with the underlying tables. Thus, I type:Profile.UserName when I want a users UserName rather than querying the database manually.Now, I need to create a scheduled job in SQL that sends emails out based upon user preferences specified under Profile. Is there a way to use Profile within SQL Server 2005?David.

View 1 Replies View Related

Transactions And Profiles

May 26, 2006

HiI'm trying to make a transaction with the TransactionScope class and if I modify a profile and call ProfileBase.Save(), it throws an exception with the message: "MSDTC is unavailable".thanks

View 1 Replies View Related

SQL Server Configuration For ASP.NET 2.0 Profiles

Apr 12, 2006

Hi,
I want to configure SQL Server 2005 Express to work with profiles and that kind of ASP.NET 2.0 things :)
The problem is, when I run aspnet_regsql.exe I can't get a list of databases, and when I manually enter the database name, I get the same error."(provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"
I've enabled the named pipes and tcp/ip connections in the Server Configuration Manager.I've also tried multiple logins.
I run the sql server locally.I can connect with my website to it, I can use the Management Studio Express (with win auth).
But I can't get those tables configured :(
Anybody got an idea?
Thanks in advance.

View 2 Replies View Related

Xp_startmail And Switching Profiles

May 13, 2002

Guys!
I'm using SQL Mail to send out Emails to Customers re: outstanding Invoices. I also use SQL Mail on the same box to send out emails to our Sales Reps with summaries of outstanding invoices. Now, I've set up multiple outlook profiles on the server. I tried using

xp_startmail @user = 'CreditControlDept'
xp_sendmail .... (to customers)
xp_stopmail @user = 'CreditControlDept'
xp_startmail @user = 'InvoiceTracker'
xp_sendmail...(to internal sales reps)
xp_stopmail @user = 'InvoiceTracker'

DOES NOT WORK!!! the profile does'nt switch at all. SQL Mail sends out all the emails using the profile that it started with. How can I use xp_startmail and xp_stopmail to switch between different user profiles.

Regards
Uday

View 1 Replies View Related

Unable To Get MAPI Profiles

Jan 22, 2008

Error message "Unable to get MAPI profiles" in send mail task(DTS).

View 4 Replies View Related

Storing ASP.NET 2.0 Profiles In SQL Server 2005

Oct 17, 2007

Hi Everyone,
I have an e-commerce site that uses Profiles in ASP.NET 2.0 to store items in a shopping cart.  The problem is that we are now using LDAP authentication, so we are getting rid of the ASPNETDB membership database that stores the profile values.  How can get the shopping cart functionalty to work with SQL Server 2005?  How can I store the profile object in a SQL Server instead of the ASP.NET memberships database?
Here is the profile field:
  <profile enabled="true">      <properties>        <add name="Cart" serializeAs="Binary" type="Commerce.ShoppingCart" allowAnonymous="true"/>      </properties>    </profile>
 
Thank you in Advance
-Sam 
 

View 1 Replies View Related

Can We Use SQLServer 2000 For ASP.NET Profiles And Aspnetdb ?

May 16, 2006

Hi,Can we use SQL Server 2000 for ASP.NET Profiles, Security etc.. ?for ASP.NET2.x?instead of SQL Server 2005 or Express editions?Rizwan

View 1 Replies View Related

SQL Mail - MAPI Profiles On Windows Server 2003

Sep 16, 2005

Scenario:DBMS: SQL Server 2000OS: Windows Server 2003Goal:Enable SQLMAIL via Internet MailProblem:How do I set up the MAPI profile for the SQL Server service account?On Windows 2000 Server, I can use "Control Panel"/"Mail" tocreate a MAPI profile for the SQL Server service account, and thenreference that profile for SQLMAIL in SQL Server and SQL Server Agent.But on Windows Server 2003, there is no "Mail" applet in "Control Panel".How do I create a MAPI profile, for the SQL Server service account,on Windows Server 2003?

View 5 Replies View Related

Reporting Services :: Adding (new) Child Domain Users To SSRS As System Users?

Jul 28, 2015

We have an existing SSRS server, and have just created a new child domain. We'll be migrating users from the parent to the child, and want to add the users of that new domain with access to SSRS. In the parent domain they are able to access, but after migration with the child domain account, they cannot.

I have added the group CHILDDomain Users with a system user role on SSRS, and PARENTDomain Users was already there.

Is there any additional step I should/could take to get this active?

View 5 Replies View Related

Why Out Of The Blue Would VPN Users Be Unable To Connect To Database And Local Users Are Unaffected?

Mar 6, 2008

I have had this issue just pop up. I have local users who can connect fine, but my users that require connection by VPN cannot connect. I get the server not available or access denied error. I did confirm that the VPN'ers are connected to the network correctly and can see that their shares and mappings are correct. Any ideas? Thanking you all in advance!!

View 6 Replies View Related

SQL Security :: Did Not Create Any New Users And There Are No Other Users Listed In Accounts Section

Sep 28, 2015

I am trying to revert back to Windows 7 after upgrading to Windows 10, however it will not let me and the following message occurs: "Remove new accounts.Before you can go back to a previous version of Windows, you'll need to remove any user accounts you added after the most recent upgrade. The accounts need to be completely removed, including their profiles.You created one account (NT SERVICEMSSQLSERVER) Go to Settings> Accounts> Other users to remove these accounts and then try again".However I did not create any new users and there are no other users listed in the Accounts section.

View 2 Replies View Related

Stored Procedure To Get All Users Or All Users Of A Specific Country

Apr 30, 2008

hi alli've got two tables called "webusers" (id, name, fk_country) and "countries" (id, name)
at the meantime, i've a search-page where i can fill a form to search users. in the dropdown to select the country i included an option which is called "all countries".
now the problem is: how can i make a stored procedure that makes a restriction to the fk_country depending on the submitted fk_country parameter?it should be something like
SELECT * FROM webusers(if @fk_country > 0, which is the value for "all countries"){    WHERE fk_country = @fk_country}
who has an idea how to solve this problem?

View 9 Replies View Related

SQL Server 2008 :: Migrate All DB Mail Profiles To New Server?

Oct 6, 2015

I need to migrate the all dbmail profiles(around 15) from Old server to new SQL instance.

is their any script or any way to do so that i can perform all at a time instead of doing manually.

View 0 Replies View Related

Difference Between Database -- &&> Users And Security --&&> Users

Nov 28, 2006

Hi Team,

In SQL Enterprise Manager, when we expand "Database -->Users", we see the

users there. When we expand "Security --> logins" we see the same users there.

Can you differentiate these two.

Thanks

Santhosh

View 1 Replies View Related

List Users Then Disconnect Users

Jun 4, 2008

I want to be able to list all users connected/logged in a specific database and disconnect them all or a certain user.

can this be done in SQL and if so how?

View 1 Replies View Related

Users Get Blocked By Other Users Alot

Sep 26, 2007

We are using Navision with SQL server 2003.

What kind of methods is there out there to reduce hwo often this happens?

View 10 Replies View Related

SQL Query For Matching

Jul 26, 2007

Okay I've posted something like this in another area but it doesn't seem to be focused towards the right people.  I need ya'll SQL experts!
 I have a database table that has 5 columns:  Time  Status  Message  Source  IP
The Status column has only two choices "up" or "down"
 I'm looking for some kind of advanced query that will do the following:
 I need the query in my application to pull the table and then match up IP, Status, and Message columns.  It should only find One match and then once it has found a match it needs to recognize that one is an "up" status and one is a "down" status and then remove them from the database.
 Does that make sense?  Is it impossible?

View 1 Replies View Related

Most Matching Records

Oct 5, 2007

Hi,
This is a where clause I am using in a search.
 WHERE (ADDRESS_STREET LIKE '%' + @Search + '%' )
I am trying to do a search which returns the most matching record. For example if I have a record with Denver  as text . If I search for Denvr the spell error is intended , I will not get the result. How can I create a stored procedure to counter probable spelling errors and return  matching results in a ranked order.
Thanks

View 2 Replies View Related

Matching On From A List

Jan 15, 2004

HI,

say I have a list from an sql statement (results list)
this list contains 10 items

In another table, in one particular column - there is a match for one of these items from the initial list.

SO... this may be the list
_____________________
itemnumber
1
2
3
4
5
6
7
8
9
10
------------------------------

in the other table there is a match...
but just for one item on that list.
____________________
othertablefield
11
13
14
3 <------ match
99
78
----------------------------

How do I find that match with my sql statement?

View 1 Replies View Related

Csv Matching Problem

Aug 2, 2005

Dear all,
I have two table, both table have a col which stored the data in CSV format, ie "ab , bc, de", etc
I would like to select the item where "any one item" in first table is same as "any one item" on second table.
I have alread have the private CSV function which can convert the string and return as table. However, I find i cannot do it like this   select ..... where dbo.CSVfunction(tableA.colA)
Thx//CSV functiondeclare @separator char(1) set @separator = ','
 declare @separator_position int  declare @array_value varchar(1000)   set @array = @array + ','  while patindex('%,%' , @array) <> 0  begin    select @separator_position =  patindex('%,%' , @array)   select @array_value = left(@array, @separator_position - 1)   select @array_value = RTrim(@array_value)   select @array_value = LTrim(@array_value)   Insert @StringTable  Values (Cast(@array_value as varchar(50)))
   select @array = stuff(@array, 1, @separator_position, '') endre @separator char(1) set @separator = ','
 declare @separator_position int  declare @array_value varchar(1000)   set @array = @array + ','  while patindex('%,%' , @array) <> 0  begin    select @separator_position =  patindex('%,%' , @array)   select @array_value = left(@array, @separator_position - 1)   select @array_value = RTrim(@array_value)   select @array_value = LTrim(@array_value)   Insert @StringTable  Values (Cast(@array_value as varchar(50)))
   select @array = stuff(@array, 1, @separator_position, '') end

View 1 Replies View Related

Matching Names

Sep 3, 2003

My company is going to start a Cancel web site so customers can cancel their future orders by simply filling out a form. I was wondering what would be the best way to compare the cancel db to db that is used to store customer information and order information.

The cancel website will only hold the name, address, and Credit Card Number used. There will not be a customer/order number. The simple Credit Card to Credit Card search will be easy but I was more worried about comparing the rest of the information in case the Credit Card search fail. I was told the "standard" look up was to take the first 3 letters of the first name and the last 3 letters of the last name. If that comes up with more then one record, take that set and see if the zip code matches up and/or part of the street address matches up (counting we do not have very reliable people inputting the information into the system is not going to help this search).

Anyway, any suggestions on comparing the data would be great.

Thanks ahead of time

View 4 Replies View Related

Matching Columns

Sep 7, 2004

All

I have a table which contains 4 columns each of which are NULL or contain a 6 digit code.
Here is a sample of the table content:

COL1 COL2 COL3 COL4
----- ----- ----- -----
452359 NULL NULL 347406
NULL NULL 347406 347406
592319 NULL 347406 347406
592319 150009 347406 347406
592319 150010 347406 347406

Through out the table any number of the columns can be null.

I wish to remove rows from this table where the columns values are contained in another row i.e Row 2 above is contained within row 3. Similarly, row 3 is contained within row 4.
So, the only rows I want from the sample data above are rows 1, 4 and 5.

I hope I have explained my query adequately, and any help would be great appreciated. (Before I go mad...!)

Regards,
Katherine

View 6 Replies View Related

SQL Pattern Matching

Mar 20, 2008

Hi everyone. I'm developing a web search engine using asp and SQL Server 2000. I need to return records that matches with a string entered by users. In example, suppose my database to have this structure and it's filled like this:

ID NAME KEYWORDS
--- ------- -----------
AA025 NAME1 attached, atic, common, business, hotels
AA026 NAME2 headache, medicin, aspirins, heat, health
AA027 NAME3 at, services, music, electronics

suppose that user enters 'at'. By now, i'm using this pattern '%<input_text>%'. So in this example, pattern would be '%at%'. As i remarked in the fields above, the three fields matches, and that's not what i'm looking for. I want that the result of that query be just the last field, with 'AA027' ID.
Thanks in advance guys.
Cheers.

View 14 Replies View Related

Sys.sql_dependencies Does Not Have A Matching Row

May 22, 2007

I'm getting the following error when running dbcc checkdb and no clue as to what to do.

Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1328111872,referenced_minor_id=5) of row (class=0,object_id=1795589535,column_id=0,referenced_major_id=1328111872,referenced_minor_id=5) in sys.sql_dependencies does not have a matching row (object_id=1328111872,column_id=5) in sys.columns.

View 6 Replies View Related

Record Matching

Feb 3, 2008

What can be done with Sql Server for this problem?

In this query:

select A, B, C
from
(select A, B, C from table1) as G1,
(select A, B, C from table2) as G2

where G1.A = G2.A
and G1.B = G2.B
and G1.C = G2.C

a record in table1 can be matched with more than one record in table2, and I don't have any other field in the tables that helps me link one G1 record to a specific G2 record.
What can I do to match each G1 record to only one (if any) G2 record (if there are two records in table2 which are identical, I want the query to choose one of them and leave the other one unmatched)?
Another question: is there a way to count records and attribute them a unique number? What is an index?

Thanks in advance

Anna - Verona (Italy)

View 5 Replies View Related

Substring Matching

Jul 19, 2007

hi allI want to write a sotred procedure which has a parameter,called@name.The SQL statement must return all rows where this parameter is asubatring of a special column called FirstName.This procdeure do thesame ,but return all rows where @name is the exact matching.whatshould I do?/*This procedure return the exact matching*/CREATE PROCEDURE substring@name varchar(50)ASSELECT *FROM table1WHERE (table1.firstName LIKE @name);

View 2 Replies View Related

LIKE Matching Question

Nov 12, 2007



I have a piece of code that uses LIKE matching to check for the existence of a set of characters in a string as follows

SELECT a.Name, a.Market
FROM Table a
Where a.Name LIKE 'DAVIEL%'

I have the following sample data in a look-up table

AddID Name_Full
100 DAVIEL
101 DAVIEL
102 DAVIELT
103 DAVIELT
104 DAVIELT
105 DAVIEL

When I write the above query, I want to exclude the AddIDs that have a Name_Full of DAVIELT. In the Name_Full column the only difference between the two strings is the "T" in DAVIELT.

Please note that it has to use a LIKE statement. The code is already written that way and I do not have control over it.

Any help will be much appreciated.


View 5 Replies View Related

Batch Name Matching

Feb 2, 2008

Hello friends,

We are in initial phase of designing an application whose primary purpose is to match a list of loan defaulters with bank's customer database.

Let me make the picture more clearer to you,

There is a list of defaulters which contains about 1500000 names (Primary names and Aliases e.t.c), related to a person.

On the other hand there is database which contains bank's customer's (about 20, 00000 records) data.

We will have to run batch a scan for name matching against defaulters list to the current customer base of bank to check if any of existing customer is in defaulter's list.

This whole exercise of name matching should be finished in 4 to 5 hours (as required by user/client).

How can I optimize my data base design or processing logic to achieve this goal,

Should I use full text query or I should load data related to names in memory than carry out some logic for name match. These are two my primary thoughts.


View 1 Replies View Related

String Matching

Nov 22, 2007

I'm on SQL Server 2005.

I have 2 tables called Customer & CustomerArchive. Both Tables have the same Column names and Datatypes etc.


CustomerID Address Postcode

1 10 Alcove Street 4000

50 21 Spring Street 4032

33 5 Terrace Place 4010

What I need to do is compare each column except for the CustomerID to see if it is the same!

In other words, I need to compare Address in the Customer Table with Address in the CustomerArchive Table.

I have to do this with all columns (12) of them between the 2 Tables.

Is there a efficient & smart way to do this aprt from the obvious way of joing the 2 Tables via the CustomerID and performing a Customer.Address <> CustomerArchive.Address
Customer.PostCode <> CustomerArchive.PostCode
etc etc etc!

View 2 Replies View Related

Types Are Not Matching

Feb 17, 2008

I'm working with Access 2,007, and I have an instruccion in SQL but when I execute it, it shows an error "" the instruccion and var in red


Dim Mes As String
Dim CostoKw As Double
Dim SQLUdate As String
Mes = InputBox("Mes a Actualizar Costo: ")
CostoKw = InputBox("Costo que se Aplicara: ")
Select Case Mes
Case 1
DoCmd.RunSQL "UPDATE Clientes SET Clientes.Costo01;" = CostoKw


The table's field Costo01 is the type Number and Double.

Thanks

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved