I have another question related to the NULL IGNORE clause
one.  
Do you know how the Null values are treated in a
clustering relational data mining model?  Can the user

Thank you for your reply.  
I understand your point, however I cannot filter records
that have null fields because I need them.
What I need is to make a segmentation based on the fields

It seems that this clause is not supported in SQLServer
2000.
Do you know how can I ignore null values in a Clustering
mining model ?

Dear folks
I am a SQLserver rookie, when I run a time consuming query, how I can cancel the query while it is running?
Thank you for your time

 I have a server machine. It has SQL Server 2k with analysis services
running. Now can i write an application on a client machine to say read the
content of a  cluster data mining model ?  My client machine does not have
SQL Server installed. Is there any requirements the client ...

I am using SQL Server 7.0 to create Web based reports for global clients using Business Objects. I need to show line numbers(row numbers) for each record retrieved. Is there any function to achieve this in SQL(parallel to Oracle's rank() over rowid function) ? Any kinda help will ...

I wanted to use SQL Server's Analysis Manager to create a new data mining model. I was already running the wizard, until I got an error message which says
"Unable to get list of data mining algorithms. Operation is not allowed when the object is closed.
How do I solve this problem ...

Our db designer is storing dates (date_field) as nvarchar  (yyyymmdd) and
not as smalldate.
So I usually need to use the syntax RIGHT() to display the dates in an user
reading friendly format such as dd-mm-yy and the CAST(date_field AS int)  to

I have 5 fields:
Name       SpendAmount     RecommendedAmount            AmountOver       Compliant        
Jo                   5000             3000                                        2000                 Yes
Donna             2000             4000                             ...

I have a trained clustering model based on a cube with
two dimensions.  The training produced clusters of the
case dimension (A) elements, based on the existence of
records in the cube that associate (via foreign keys) a

i dont know if this is the right group ,therefore  sorry for any
inconvenience.
i didn't work on data mining before,now i want to implement an algortihm as
a beginning. When i search through the net, i see lots of algorithms. My aim

I need a function equivalent to the excel CHIDIST function.  This function
calculates the one-tailed probability of the chi-squared distribution.
I don't think there is a built in function for it in SQL server, so would I
calculate it?

Does anybody knows why the ClusterDistance() function
doesn't produce an output when used in a clustering
prediction query?  The functions Cluster() and
ClusterProbability work OK.

hi
 i WOULD LIKE TO KNOW  how to create   CUBE ROLES using
vb./c#(.net)coding.
any body   has any idea?  

I have to convert a field from a VARCHAR to a float on existing client
databases.
I am using IsNumeric to determine whether the column is a number and if it
is using CONVERT to change it to a float.