Click here to Skip to main content
15,887,344 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
The bold part is where it meets mistake : datamining problem: varchar mistake
SQL
create mining model DecisionTree_LevelPredict
(	
	stu_ID varchar(50) key,
	stu_gender varchar(50) discrete,
	stu_birthyear varchar(50) discrete,
	stu_education varchar(50) discrete,
	stu_levels varchar(50) predict
)
using Microsoft_Desicion_Trees (Complexity_Penalty=0.5)

insert into DecisionTree_LevelPredict
(stu_ID,stu_gender,stu_birthyear,stu_education,stu_levels)
openrowset ('Microsoft.Jet.OLEDB.4.0','Data Source=dbo.customer;','select ID,gender,birthyear,education,levels')
select * from DecisionTree_LevelPredict
Posted
Updated 25-Apr-11 18:18pm
v2
Comments
walterhevedeich 26-Apr-11 0:34am    
Not sure if what you are trying to say is it errored on that specific line and you are asking why. Please try to make your question clear.

1 solution

I think you should change varchar(50) to TEXT.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900