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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|