Hi;
I am undertaking an CRM analysis for a company.
I want to know :
1- (in depth) the algorithms used in Clustering and Decision tree.

Is there any equivalent in SQL server for oracle statement "Create or
Replace" such as CREATE OR REPLACE PROCEDURE.......
As far as I know, SQL Server doesn't support "CREATE OR REPLACE". Also a
DROP and a CREATE can't reside in the same query batch file. I want to put

When i execute a Query from an Oracle Linked server  i got 99 rows less then
the original data.
when i run The query in oracle i got 999 rows , when i run in SQL using
openquery i got 900 rows.

I have a dataTable in my database with columns title, category,
problem(description of the problem) and solution. I want to develop a good
search mechanism for certain problems so that the user can search for
problems – solutions, when he quotes a search term. But I think it is ...

I have a table name Trxs, now I would like to create another table
TrxHistory which should have exact same structure as Trxs. I want to create
this table in the same database. Can anyone suggest me quick way?
Thanks.

I'm new to SQL server technology (have been working only with MS Access
databases), so, please, be indulgent to my question.
When working with Access I often made queries processing records retrieved
by another query.

hi
I have a very large database with several stored procedures. now, I
need to find a stored procedure that does some calculation if that
stored procedure has a string "MESSAGE"(just an example) in an IF

        I 've been assigned a Data Mining Project on sample data 'FOODMART'
in SQLSERVER 2000, but i am not too sure about how to get started and what to
do afterwords. can anyone lists the steps to follow and task to be done.
I am needing you peopl's urgent help as i don't have ...

Hi People,
I've got some data that I need to group in a really awkward manor.
Given the following data:
A1, B1

i tried this question in olap room but there was no reply.
i had a question regarding Expectation-Maximization
algorithm used by microsoft for data mining in ole db.
Does anyone know how good this algorithm is when compared

I am trying to simulate mining model creation in SQL
Server 2005, using C# in .NET. SQL Server 2005 has
provided with AMO object model for this purpose. To use
this object model, it is required to

other than foodmart...?

Looking for Thrid_party tools to explore MS Data Mining
on the WebSite
please tell me thanks

How do I build query to extract the following columns from
two tables?
I need the following as a result:
Order_History.Order_No,

Is it possible to make this on SQL server 2000?
There is a table with a columns:
SomeTime | SomeEvent
2004-09-22 08:00:00 | Event 1