I have a need for a query where the WHERE clause checks multiple fields
against a subquery.  The following example returns the results I want:
SELECT
   *

SQL 2K
We have a data-warehouse server which loads data from different databases
which resides in a different server, perform business logic and load into a
FACT table.

Please refer to following table
-------------------------------------------------------------
ID Title               Genre LeadCast SupportingCast Director
-------------------------------------------------------------

I think the main advantage is that data mining helps bring to light the
trends that are within your data but are not so obvious while doing
simple analysis e.g. browsing a cube.
I also think that Data Mining also includes some kind of forecasting and

I tried to find some articles or titles of the books in which I could see the actual algorithms, explained in details, used for data mining.
If you have any good material for the topic, please reply.
Thanks,
Mario.

i am from Business Intelligence group, domain is media. my current assignment is to find out similar movie title for new release based on attributes like genre, lead cast, supporting cast, language.
we are using ms analysis service 2k for data warehousing & data mining. ms ...

I tried to find some articles or titles of the books in which I could see the actual algorithms, explained in details, used for data mining.
If you have any good material for the topic, please reply.
Thanks,
Mario.

We have a proble within a cube measure. We ant to design acube
containing something like a "running sum". I am quoting this, beacause
i didn´t fin any similar expression for this.
So, if the column "Sum" is the expression we wanted, we want to get

Received the following error during processing a relational mining
model.
Analysis Server Error: COM (OLE) error '(Microsoft? OLE DB Provider for
Data Mining Services) Query column [No of Cards] cannot be converted to

I don't want how to compare datetime and smalldatetime in where clause
Could you teach me?
Thanks
eg  table test

Is it possible to generate a password column by putting an expression into
the formula field when defining the column, to combine other fields? e.g.
(left([varcharcol1],2) &[integeridentitycol] & right([varcharcol2],1))
Thanks Sean.

I am trying to create a view but am having problems.
I have 3 tables
Contact1, Conthist, Cal (contact info, History (1:M), and
Calendar (1:M))

Which PMML mining model does SQL Server support (both as a producer and a consumer)?
Thanks

I setup a new server (Windows 2000 Server) and installed
SQL Server 2000. For some odd reasons every 3 or 4 days it
shuts down at nights and causes too many problems for us.
Because our clients are suppose to send information at

  I have an employee data base. I applied the clustering algo and now have
the model. But now i need to answer the following question:
Given an employee id, which cluster does he belong to, and who are the other
employees in that cluster? How do I write the query for this?