I have downloaded ANGOSS data mining 30 days trial version for testing. I am trying to use Angoss Expectation-Maximization, Angoss K-means, Angoss Clustering, Angoss Decision Tree alogrithms in Microsoft Analysis Sever Server 2K. but only Angoss Decision Tree is working in ...

I hope this is the correct newsgroup to ask a question regarding a SQL
statement I'm trying to construct.  Thank you for those who may help me
with this.
SQL Server 2000

Hi,
Does anyone know of a way I can usage out of the SQL?
I have come to a problem where I need to know who is using our system and for how long.
Is there any code I can run in query analyser? or log files I can write a program to analyse?

How can I get a display a list of all tables in database along with
their row sizes.
The idea is to find the heaviest tables and trim them.
I am currently doing on the basis of deleting 30 day old data.

I want to retrieve all records that col1 begins with certain char(s).
The simple case might be solved as follows:
----------------------------------------------------------------------
create procedure GetNames ( @Param nvarchar(20))

I want to reduce my log file size. The data file is 54mb
and log is 61.92gb. How this is possible? Is this a normal?
If so please tell me how to reduce that?
Shanthi

i wish to have serial numbers of rows returned in query
i am basically using a complex query the only requirement is to have
serial order for the rows returned.
Kindly guide on how this hould be done

how do i extract the time value from this
'2004-07-10 11:23:50.000'
inside a query statement

I am trying to write a SELECT statement that excludes
records based upon a value in the immediately previous
record.  The table that I am selecting data from has a
column called "status".  I want to exclude all records

what dbms support the other database models?

I have simple problem, but i'm new in SQL
I have 3 columns.
1 - Hotfixes (there are id number of hotfixes as string)
2 - domain (about 4 domains as string)

this may be a very naive question, but I would like to
know if it is possible to create and apply (for
prediction) the data mining models (the decision tree
algorithm in particular) of SQL Server 2000 from a hosting

I have a database with a table that contains multiple versions of the primary key
I am trying to pull data for Orders
Each order can have multiple order versions, they are sequential in nature.
My current query is as follows

I'm new to datamining, and I think what I want to do should be fairly
simple, but I can't figure it out (even after going through the Books
Online, and the tutorials).  I've got a table with the following fields:
FormId

I am doing a social services data project where they need to know the number
of days a kid is in their 'system'
In a table it has a beginning and ending date and 'place' that shows where
the child is.