I am newbie to Data Mining..I have executed the following DMQuery in DMSamp.exe and I got the result SELECT t.group1BounceAnotherCaller ,t.group1RespondToIntro FROM [Paid Minutes Predictor]
Is there a way to calculate two rows in a table? I know that I can calculate two columns, but I'm looking for two rows. If the two rows = 0, don't include in results. Anyone know how I can do this? TIA
Now I download the sql2kdatamining(Preparing and Mining Data with Microsoft SQL Server 2000 and Analysis Services) from Microsoft SQL Server 2000. I read this code and do not know how to setup it. I have read the "setup" that
I am wanting to get the name of the user logged into a SQL db from sql. I want the login column from sp_who2, or something better if you know of it, but I must be able to get it easily in a single select statement. I searched the @@variables, but the only thing I see is spid ...
I am new to Data mining . I have created a data mining mode in MS Analysis Service. Now I want to predict the future with the past data. For that I searched the net and I downloaded DM Samples Application. I dont know how to
I'm trying to write an update query by joining two tables together on a common field and updating the field in one table using the values in a field of the second table. However, I am unable to use more than one table when