Hi Jamie MacLennan, Thanks for the help...Now this query "select * from intrusion.pmml" is also working....But i dont know what to do with the output....I remember you telling me PMMl is used for the representation of the content of the model.How can i represent this output to the user....more >>

Hi all, I tried executing a singleton query in dmsample application.But it is giving me an error "Unable to execute query The operation has failed because of an error in the COM component. can anyone help me out correcting this query SELECT Predict([CUSTOMER_PRASHANTH].[Yearly I...more >>

Hi all, I have a question???The name of my model is intrusion(name of the decision tree )Where should i execute this query.. select * from intrusion.PMML Itried executing in query analyzer it gave me a error Please can any one tell me where should i execute this query. Thanks...more >>

Hello.. I'm trying to convert a numeric value to a monetary format. Take my query "Select 1000 As MyNumber" for example. This obviously returns 1000. I'd like to return $1,000. When I run "Select Convert(Money,1000) As MyNumber", it still returns 1000 (no commas or $). Any ideas? Many thanks....more >>

Hi guys I'm just curious - is there a (preferably free but if needs be my company will have to pay) web front end (much like Web Data Administrator) for Analysis Server? I've searched high and low and I've heard of Digial Dashboard but I can't find the resource kit anywhere and I've read ab...more >>

I am trying to manipulate data before it is inserted into a column. For instance I am reading in a MAC addreess which looks like '00DE0B16AA99' and when I do an insert into the column I want it to be '00:DE:0B:16:AA:99' In other words I am trying to insert the semicolons. I thought I was...more >>

Hi, This looks simple but I can't figure it out. If there's a n-n relationship between two tables, how can I find all records in the first table that are linked to all records of the second table. For Example: TableComputers ComputerID, Name 1, PC1 2, PC2 3, Server3 TableSoftw...more >>

Hi, I have two tables (tblPOLICIES and tblCLAIMS) from which I need to extract the following information: Total active policies and their related claims. If in a query I sum all active policies. SELECT COUNT(POLICY_ID) AS T_Policies FROM dbo. tblPOLICIES WH...more >>

I work for an insurance agency that needs to run a multitude of checks on applications when they are added to our database. A large union query in a stored procedure works just fine, but is slow. I want to create a temp table, transfer the data into it, then run the union query against it. Thi...more >>

Can anyone recommend a good book on SQL Server 2000 Analysis Services and data mining techniques. I have used SQL database for a while now, but i am totally new to data mining and analysis services. Will it let me to things like projections & forecasts based on historical transaction data cont...more >>

Can any one tell me how I choose a data mining technique Does anyone have examples of when they think they have applied the wrong tecnique ...more >>

Can some one give me a brief list of data mining techniques and when they are useful. Please if you can keep it basic. Im not very Bright ...more >>

Hi, I am using SQL Server 2000 on Windows 2000 server. Here is my problem: @String = 'word1word2word3word4word5' - This value is passed to Stored Procedure from the script. Column1 in a table1 has many rows with "words" . One row in this column1 will have 'word3'. Notice that this 'word3' i...more >>

Hi Jamie MacLennan , Hi, I have a question???The name of my model is intrusion(name of the decision tree )Where should i execute this query.. select * from intrusion.PMML Itried executing in query analyzer it gave me a error then i tried in mdx but it also gave me a error.Pleas...more >>

Hi Jamie MacLennan , Thanks for helping me....I have one more question..I have just created the tree using decision algorithm.I have not formed the cube.....should i form a cube compulsorily for doing a predicting model?? I dont know if u will be able to help me for this que...more >>

Please could some one tell me of a good web source that would help get an introduction to the data mining techniques and when they are supposed to be used ...more >>

Hi Jamie MacLennan , Can i use PMML for connecting to analysis server 2000.I have a decision tree.But i dont know xml.Can i use PMML for creating a web based application.If so please tell me how should i proceed.Please tell me some materials which will describe about this. Thank...more >>

hi, i am using sql server 2000 and have already generated a decision tree using Analysis Manager Decision Tree Mining Model approach. I wanted to know the different ways in which the user can use the rules of the mining model to do some prediction which the above mentioned server supports. I w...more >>

I'm attempting to write a query that pulls data from two tables in a really complex way, and I can't figure a way around it. Because of the architecture in use, it has to be done in a single query, without using a stored procedure. This is a simplified version of what I'm doing: Let's say I ha...more >>

Hi Jamie MacLennan, I want to make use of the rules to a user given input.I have uploaded the kddcup1999 intrusion detection dataset and i have generated a tree using decision tree algorithm which is in graphical format.I want to make use of these rules to the user given input.I a...more >>

Hi, I use Microsoft SQL Server Beta 2. When I compare mining model prediction for table I see other predicted values as I get with Singleton Query in Business Intelligence Development Studio. Simply I have same input but different prediction....more >>

In MSDE the DSO object was used to program the analysis services What object should be used with the SQLEXPRESS. When I am using the DSO in order to connect to the SQLExpress I get an "Internal Error". ...more >>

Hi, I am doing a data mining project.I am using sql server 2000.I have applied decision tree algorihtm to my dataset. Can anyone tell me how can i make use of these rules in the front end. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get...more >>

I have Four tables: Hours, Sales, Employees, Stores Hours = Date; Hours; EmployeeID; StoreID Sales = Date; Sales; EmployeeID; StoreID Employees = EmployeeID; Level Store = StoreID; StoreName; StoreAddress Each day, each employee that works in each store gets one record in the Hours table. ...more >>

hi all, i need to direct query to the AS, i had created the mining models in the AS using wizard, but the given sample query is using openrowset to predict the data. i hope someone can help me translate it to direct query. for example: "select * from [model].content" which will show ...more >>

Hi, all i want to do is get all rows from a table that meet a condition and execute a command for each one of them and i would like to have it all in a stored procedure. My first problem is that i can't get the table to a variable and my second one is that i don't now how to go through a table a...more >>