I've made a database table "Points" with columns "PointID","X","Y", populated
it with 3 piles (visually abvious) of 2-dimension points, and then asked
Analysis Services to segment them into 3 clusters. The result ("Paths" of
clusters) is quite confusing: it is NEAR the 3 piles of ...

I am trying to do an application in VB 6.0 and I try to get the mining
models from sql server 2000, in the VB form.
Please help me with this problem because I cannot succed in viewing
the mining models. (maybe you can help with some code lines)

I have a table which is a process log and has entries such as datetime and
process status (e.g.with values of "Start" and "Stop") and an identifier for
the item of machinery that the row relates to.
What I would like to do is fold the table up so that instead of having

Obtuve el trial de SQL 2000, pero necesito trabajar los algoritmos en
datamining, pero me indica que hace falta la lista de algoritmos para poder
trabajar datamining.
Necesito saber cual es el archivo que necesito bajar para poder trabajar?

   Hi
   I'm not sure if it's the right group for this kind of question
(if not, then please direct me to the right one). I'v looked
for the answer in "Books Online" and newsgroup archive but havent

I'm trying to change the data source of my cubes because we have change to other server all datawarehouse.
is It possible?
---

I used case method in my query. But there is one small thing very
important for me.
Here's my CASE code:
SELECT Nazwastacji, Data,

I have set up an Active Directory, Certificate Services on Windows 2003
Server. I am running SQL 2000 Server. AD and Certificate Services were
installed correctly.
My goal is to be able to use SSL when connecting to SQL Server via Query

Which is the easiest way to get the date of last full
calendar month. I need to know the first day of last month
as well as the last day of last month. If today
is '11/23', I need to get '10/01' and '10/31'.

Is it possible to use the Query Analyser of SQL 2000 to make a a report-like
query on the models generated by Analysis Manager?
I know this report can be done by Visual Studio and some other tools, but I
think Microsoft should have something on the SQL 2000 tool-set that should be ...

HI, I seem to be having a problem with decimal places.
I created a view in SQL 2000. In my source table I have a field with values
of 25.
I added an expression to divide the value by 100.

I've got a linked server setup to DB2, and some of the
date fields in the DB contain 1/1/0001 values.
When I attempt to select that  field, I get an error
Server: Msg 8114, Level 16, State 8, Line 1

I have been developing in MS SQL Server 2000 for about 8 months now so I
would consider my self to be really new to this Database.
As I am lacking in long term experience I really have no idea about the
sizes that MS SQL is capable of.

How do you get a top 10 count for each people? For
example, I have table like this:
person  count_of_sales  product_id
100001  12               1

I need help with a query, and unfortunately, my SQL skills aren't
particularly advanced. My sample data looks something like this:
Name                City                    Date
Smith               New York            Jan. 23, 2004