The dates in a SQL2k table are stored as nvarchar (yyymmdd). When displayed,
the CAST (DATE_FIELD AS datetime) syntax is used. Because of the given
format, when the DATE_FIELD has no dates, the empty field is converted into
01/01/1900. What is needed to keep 01/01/1900 from ...

Can I move my SQL database to another drive as We have
space issue? How to do This?

Can i tranfer mining prediction output into cube in Microsoft Analysis Server 2000.
thanks & regards
rajesh
**********************************************************************

I have Store No & Daywise sales data of Movies. There are 40000 stores and for each store i have 56 days sales data of Movies to predict. The criteria for prediction of sales is based on the selection of
1. Store attributes (like Store Space, Store Type, Regionality, Demographic, ...

I did a cluster analysis using about 20 variables, almost all
continuous.
Number of clusters is 9. When I ask for the clusterprobability, I get
almost always a pure 1, which let me suspect of something wrong.

Is it possible to have 2 sql servers inserting into the same database.  In
my specific case, the servers would be inserting to different tables and
there would be no overlap.  I don't want to split the database because
reporting would be based on data from the whole database.

When I run a T-SQL query through OSQL, at the very top of
my output file is a row of column headers, how do I stop
this? Also, how do I get rid of the 'nnn rows affected' at
the very end of my output file?

I am having problems to convert this layout in the way I want.
I have this table:.
Date                 Code               Value
2002                 01                    101

I am trying to create a view that combines the results of
three different select statements where the individual
select statements return different numbers of columns and
varied column names. I've pasted an example of what I want

Hi. I am a beginner in data mining.
I want to use AS Tool to do data mining. I have used DTS wizard to import data. However, I donno where can I read the statistics of each column. You know we need the statistics to clean the data. Can anybody tell where to read the statistics? If ...

Hi! I have read the online book suggested by Sanchan.
When i follow the example in the online book, the software has no response for a long time. I donno understand why
After reading the online book, my first feeling is that no data mining can be done if I only have AS. To me, it ...

Several of the algorithms I have developed, using the
downloadable code for the OLEDB DM framework, need to
return quite a few nodes (maybe 100000, each with a
distribution) in the MINING_MODEL_CONTENT schema rowset.  

do you know how can I store a mining model that was
created using OLE DB for DM syntax through a OLEDB
connection?
The problem is that when I close my application the model

I operate with 2 tables: tbLocations and tbDepartments. Both have a column
named Town.
tbLocations.Town looks like long unique list of different towns world wide:
Copenhagen

My company has begun utilizing analysis services to create cubes and subsequent reports using sql reporting services.  Our next step is creating reports that show historical trends in data, such as if a particular product's sales are above or below some predefined sales rate over ...