Hi, I hope this is an appropriate group to ask a question about basic SQL SELECT performance. I'm creating a VIEW which draws together two tables; T_ONE and T_MANY. Basically, the VIEW creates a LEFT JOIN from T_ONE to T_MANY so that the Ad Hoc SQL submitted from the software is simply a SELE...more >>

Hi every one: I am realy stuck! 1. I am always receiving an error while running query using DMsample.exe. I have installed lattest service packs and installed ocx componenet according to SQLSERVER.DATAMINING faq . --> Error message comes: The operation has failed because of an error in the...more >>

Hi ! I installed the Angoss SDK. Theres a sampe application that comes with it. It uses an MS Access dbase. Is there a sample that shows how to use it with the data in SQL server? ....Sinex ...more >>

Hi ! I have SQL Server2K on my machine. I want to create a decision tree model from my VB application. I created an ADODB connection first (uses the MSDMine.1 provider). Then I tried to execute the following statement: DC.Execute "INSERT INTO " & DMMName & " " & _ "(SKIP, [EMP_CARD_INDEX]...more >>

In the classic foodmart 2000 example(a data set i'm taking as input into building an mining application) in an attempt to identify patterns in customers in SQL SERVER 2000: analysis services based on sales data(customer transactions)...what are the patterns i should try to find and what would be the...more >>

Hi all, this is regard to the massage "SQL server books online mining model sample VB6 to C#" replied by Peter Kim ...I have added the DSO referance already but converting VB6 code Set dsoDB = dsoServer.MDStores("FoodMart 2000") to C# coding is difficult. and also is it possible to get the number...more >>

I just started using SQL at work. Iwas wondering how to write a query for a reprt that would allow you to pick the date range that you wanted. Any help someone could give me would be appreciated. I would also be interested in some book titles that would help with this. --- Posted using Wimdows.n...more >>

Hi all I'm trying to re-process a manually created mining model in the analysis services. I suppose this is possible with DSO 'processfull' command ? but i use C# for development and not sure how to connect to a existing mining model. I have pasted a part of the VB 6.0 sample coding found in SQL se...more >>

Hi, I have VB 6.0 and am running Win2K with SP4. However the readme file recommends SP3. Is this the reason for the crashes?? Sinex Original Message: Hi, I just tooke the DMSample from the files section at MSN groups. The exe works fine. But when i open the vbp project I encounter...more >>

Hi, I am using SQL Server2K with Analysis Services. Does the client version of SQL Server also have an Analysis Manager? Is there some UI in the client which hooks up with the Analysis Server on the server side? Another doubt I had was the following:: Say I write an add-in for Analysis Servi...more >>

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 Error converting data type DBTYPE_DBTIMESTAMP to datetime. I assume since valid dates ...more >>

Hi, I'm looking for a good tool that end users can use to view data mining models that I have created. Excel can be used to view the pivot tables, but I have yet to find a good viewer for mining models. Regards, Olof...more >>

if i implement ole db for dm provider,and build it as **.dll, how to register them in analysis server?? is it like :regsvr32 **.dll, is it right?...more >>

Hi ! I have a cluster model of my data. I'd like to perform queries against this model now. What sort of queries can I make? How can i make more sense of the clusters? ....Sinex ...more >>

Dear all, I’m a student whose doing extensive research on data warehousing and data mining. With me, is a full dataset of students’ record from a local university. Information’s which is in the dataset consists of students subjects, grades, personal information, library information, to hostel...more >>

Hi ! I have an employee database. I applied the culstering model to thid db. Now I want to write a query such that given an employee index, i need to retrieve which cluster he belongs to ( and also retrieve info abt the rest in the same cluster)! ....Sinex ...more >>

Hi ! I just ran the clustering algorithm (from analysis manager) on my data and got a nice output in the mining model browser! But how did the algo segment the data into 10 clusters? Whats the meaning of these clusters? How do I interpret these clusters? Is there any material/resource th...more >>

Hi, I have a db on Sqlserver 2000, compatibility level 80 and my collation name is "SQL_Latin1_General_CP1_CI_AS", I have SP3 On the server regional options we have dd/MM/YYYY, and the problem is that after a reboot I have months like 'tammi', 'helmi', 'maails', 'huhti', 'touko', 'ke...more >>

Hi all I have written many times to this forum and have received valuable information. Thanks for all who replied me. But I’m still uncertain, what analysis service is capable of. My scenario is as follows (I’ll try to make is simple as possible). I have a chart and the X axis is the days (e.g...more >>