Groups | Blog | Home


Archived Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007


all groups > sql server data mining > october 2003

Filter by week: 1 2 3 4 5

Group information retrieval
Posted by Derek Shi at 10/29/2003 5:47:33 PM
Hello all, I got two tables as follows: Table 1 Patient- patient_id - age - provider_name Table 2 Provider- provider_name - clinic_name How can I list the clinic name alphabetically with the number of the patient in the following age group: 0-10, 11-19, 20...more >>

Purchase correlation between individual items/artists
Posted by anonymous NO[at]SPAM discussions.microsoft.com at 10/29/2003 2:42:14 PM
Hi I'm totally rookie and have been trying to understand the mining model editor today. I ordered the tech reference book but I'm hoping someone here can help me with a hopefully simple senario: I have a flat table that has three columns I'm concerned with: Purchase ID Customer ID Ar...more >>

Change case of contents in tables
Posted by RD at 10/28/2003 11:28:06 AM
Hi, We have an SQL database with several tables that was popualted with data in all caps. We would like to convert this to proper case for most fields (i.e., the first letter of every word should be capitalized and the rest of the characters should not be). Also there are some field...more >>

Query Help for extracting a character
Posted by Miky at 10/27/2003 5:38:39 AM
Hi, I have a log entry with more than 100 characters in a single field. This field contains certain specific letters (A, B, C, D, E, F, G) at different places floating around in the record. Each of these letters follow the ampersand character '&' notice the letters in the example-->( eg. ...more >>

OLEDB Data Mining Spec - MINING_CONTENT schema rowset
Posted by John Sandiford at 10/27/2003 2:55:54 AM
Hi, I've developed several custom algorithms, implemented using the OLEDB Data Mining Sample provider. I' m trying to report learnt information about a model using the MINING_CONTENT schema rowset. In particular I want to report entries of a full covariance matrix. This means that I need t...more >>

Is this possible? please help (MS access query of sql database)
Posted by anthonyberet at 10/18/2003 1:03:05 AM
I work for an organisation that uses a bespoke document imaging system, the database of which is an MS sql server. We have MS Access and already use it for some querying of the database. The database comprises a large number of distinct cases, which are differentiated by case reference numbers, ...more >>

predictions with nested columns
Posted by Matias Schapiro at 10/15/2003 9:14:14 AM
Hi, I would like to know if there is any way to make a prediction about a nested column, using the same nested column as input, using ole db for dm specification. I need to do the follow prediction : if one customer has bought these products, he will probably buy this one. I will try to do ...more >>

data type
Posted by Antonio at 10/14/2003 5:32:13 PM
what the diference between: 1- nvarchar and varchar 2- nchar and char ? Tks, Antonio ...more >>



PredictProbability
Posted by Matias Schapiro at 10/14/2003 4:51:15 PM
Hi, I am trying to use the function PredictProbability, but I am receiving this error : "Parsing error occurred prior to 'occupation) FROM prediccion2'." My code is this : "Dim conn As New ADODB.Connection Dim rst As New ADODB.Recordset Dim query As String conn.Open("provider=msolap;dat...more >>

cost of olap services
Posted by bbliss at 10/7/2003 4:57:12 PM
Is OLAP services included with SQL 2000, or is it an add- on? I can't seem to find any info about it. thanks...more >>

SQL2K - Data mining - Clasification Tree
Posted by Iks at 10/7/2003 10:51:34 AM
Hi, I tried to use sql2k mining model - clasification tree. Result - graphical tree with lot of nodes/leafs (it is ok), each has condition, predicted value of dependent variable etc. Base on this result I would like to create SQL code to classify each record in learning table and other tabl...more >>

Can this be done?
Posted by Kathleen at 10/1/2003 12:37:11 PM
Hello all, I am another SQL newbie and I have a project I'm thinking I can create in SQL Server. We want to create a repository (database) of resumes that come into our recruiter email account. We currently use an app that automatically saves the body and attachment of the email to a net...more >>


DevelopmentNow Blog