-------------------------------------------------------------------
:::: Great Indian Developer Summit 2009 - GIDS .Net ::::
:::: 24 April 2009 ::::
:::: J N Tata Auditorium, IISc, Bangalore ::::
:::: http://www.developersummit.com ::::
-------------------------------------------------------------------
Dear Group members,

The economic downturn will run out of steam trying to outdo the 'ready
and waiting' software professional. Packed with premium knowledge,
action plans and advise from been-there-done-it veterans, creators...

Hi, I wanted to make sure you were all aware of these upcoming events.
There is a seminar in Predictive Analytics on Oct. 24-25 in DC, and in
San Francisco Nov 6-7. This is intensive training for managers,
marketers, and IT people who need to make sense of customer data to
predict buying behavior, profit, etc. Past attendees have given rave
reviews.

You can find more info at http://www.predictionimpact.com/predictive-analytics-training.html,
e-mail training@predictionimpact.com, or call (415) 683-1146.

thanks --Elise Johnson, Prediction Impact

Hi guys

I need to save the result clusters in a table by code, how can I do that?

I'm creating a process flow, using sql data mining structures. This
process consist in run clusters and for each cluster, run a logistic
regression. The mining strucuture for that is already, but I need to find a
way to save the cluster groups in a specific table.
I made a mistake with the name of this group but I know that you guys are
experts in SQL, and can help me to solve this trouble.

best

Hi guys,

How can I write the final clusters in a table, after the clustering process?

US Training Courses for Open Source Data Mining Software
RapidMiner (New York & San Francisco, October 2008)

Data Mining Training in New York, October 6-10th, 2008:
http://www.rapid-i.com/content/view/106/125/

Data Mining Training in San Francisco, October 20-24th, 2008:
http://www.rapid-i.com/content/view/105/121/

Open source software nowadays is a reliable and often more powerful
alternative to closed source software. This is especially true in the
case of software for data mining, text mining, web mining, predictive...

I'm trying to follow Microsoft's KB Article #312839 on how to send e-mail
without SQL Mail in SQL Server.

We have SQL Server 2000 with SP2.

I entered the script they listed in their article for CDOSYS:
http://support.microsoft.com/kb/312839 (as long as the link is good)
I edited the 'cdoSMTPServerName' to be our SMTP Server: 'http://172.16.8.1'
in a new Stored Procedure, and it saved with no problems.

Whenever I run the SP in Query Analyzer, I get -2147220973. Is that an error
code or a phone number [i.e. (214) 722-0973]?

I am a Software Developer and not a DBA (we do not have DBAs here). Any help
or advice is appreciated.

I am running SQL Server 2005 and the Analysis Tools. When trying to run a neural network model I get the following error: "Execution of the managed stored procedure GetAttributeScores failed with the following error: Exception has been thrown by the target of an invocation.Column 'Prices Pct Higher Than Outsourcer' does not belong to table .."

I have about 500 columns I am using, I increased the MAXIMUM_INPUT_ATTRIBUTES and MAXIMUM_OUTPUT_ATTRIBUTES to 10,000 but I still run into this error. Anyone run into this issue before? Anyone know how to resolve the issue?

From http://www.developmentnow.com/g/101_0_0_0_0_0/sql-server-data-mining.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com/g/

BOL 2008, Breaking Changes to Analysis Services Features in SQL Server 2008
(http://msdn.microsoft.com/en-us/library/ms143742.aspx) page says:

Previous versions of Analysis Services support using the MINIMUM_LEAF_CASES
parameter with the Microsoft Decision Trees algorithm, and the
MINIMUM_CLUSTER_CASES parameter with the Microsoft Clustering algorithm.
Since SQL Server 2005 Analysis Services, both of these parameters have been
renamed to MINIMUM_SUPPORT. If these parameters were used in mining models
created using the previous version of Analysis Services , the parameters are
not migrated.

From my tests, in SSAS 2008, they are migrated and even used in processing
the model. BTW, there is definitely a typo in BOL, as you can see from the
copied from BOL referring to SSAS 2005 and not 2008. Nevertheless,
forgetting about the typo, I am interested whether this behavior in SSAS
2008 is intended, is it a bug, undocumented feature, or simply an error in
BOL.

In 2008 BOL, in the IMPORT (DMX) topic
(http://msdn.microsoft.com/en-us/library/ms132174.aspx), the syntax for the
statement is

IMPORT [

We have two tables that I need to write a query for. I am a Software
Developer, and we do not have any Database Admins here.

TableA:
|_varchar(50)_|_char(15)_|_char(10)_|_varchar(99)_|_DateTime_|
|_Employee____|_ModelNum_|_Station__|_Status______|_TestDay__|

TableB:
|_char(15)_|_varchar(50)_|
|_ModelNum_|_ModelName___|

Though no primary key exists for the two tables, TableA's ModelNum *does*
map to TableB's ModelNum.

How would I get:
TableA.Status, TableA.ModelNum, and TableB.ModelName
WHERE (TableA.Station='Testing')
AND (TableA.TestDay between (Date1 and Date2))
AND (TableA.Employee from TableA.Station='Building')

Here is the scenario:

Employee 'John' assembles units at the 'Building' Station.

Sometime later, these uints arrive at the 'Testing' Station where they are
tested by others.