Archived Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
all groups > sql server data mining > october 2004

DIFFICULT PROBLEM! SSL for SQL 2000 Server. MS Fix bulletin does not help at all.
Posted by Jason Robertson at 10/29/2004 1:32:58 AM
Hi, I have set up an Active Directory, Certificate Services on Windows 2003 Server. I am running SQL 2000 Server. AD and Certificate Services were installed correctly. My goal is to be able to use SSL when connecting to SQL Server via Query Analyzer. I also want to keep the SQL Server insta...more >>


clustering and decision tree
Posted by (z_abderrahman NO[at]SPAM lycos.com) at 10/27/2004 7:11:56 AM
Hi; I am undertaking an CRM analysis for a company. I want to know : 1- (in depth) the algorithms used in Clustering and Decision tree. 2- How can I select the "good cluster" and the best DT. 3- How to interpret the results. Note: I have read the tutor. I appreciate your help. Yours...more >>

Best Match
Posted by daven NO[at]SPAM cougar-automation.co.uk at 10/27/2004 2:59:36 AM
Hi all, i have a table which contains for arguments sake, beans - Table Beans BeanId DecriptionId DescriptionValue with values such as Harricot length 1.1 Kidney length 1.4 ...more >>

Any equivalent of "Create or Replace"?
Posted by Ram P. Dash at 10/22/2004 11:47:01 AM
Hi, Is there any equivalent in SQL server for oracle statement "Create or Replace" such as CREATE OR REPLACE PROCEDURE....... As far as I know, SQL Server doesn't support "CREATE OR REPLACE". Also a DROP and a CREATE can't reside in the same query batch file. I want to put the whole script ...more >>

Report Generation.
Posted by saomot2000 at 10/21/2004 6:29:02 AM
Hi Fellows, It's been quite sometime! Please I need your help as regards SQL Server 2000's Analysis Manager. After creating a mining model and browsing it, I want to generate a report-like detail of the rules on which the classification was made by the Analysis Manager. The model was created...more >>

Oracle 9i to SQL 2000 linked Server Problem..
Posted by Melih SARICA at 10/20/2004 3:55:05 PM
When i execute a Query from an Oracle Linked server i got 99 rows less then the original data. when i run The query in oracle i got 999 rows , when i run in SQL using openquery i got 900 rows. Any idea..? ...more >>

search mechanism
Posted by mathon at 10/16/2004 3:51:03 PM
Hello, I have a dataTable in my database with columns title, category, problem(description of the problem) and solution. I want to develop a good search mechanism for certain problems so that the user can search for problems – solutions, when he quotes a search term. But I think it is not...more >>

How to create table from existing table structure?
Posted by Sunny at 10/14/2004 12:59:51 PM
I have a table name Trxs, now I would like to create another table TrxHistory which should have exact same structure as Trxs. I want to create this table in the same database. Can anyone suggest me quick way? Thanks. ...more >>



Quaestion about stored procedures
Posted by Mike at 10/14/2004 1:31:28 AM
I'm new to SQL server technology (have been working only with MS Access databases), so, please, be indulgent to my question. When working with Access I often made queries processing records retrieved by another query. Now, in my Access database project I need to process records retrieved by ...more >>

search for a string in stored procedure
Posted by sudhakarp80 NO[at]SPAM gmail.com at 10/13/2004 4:34:27 PM
hi I have a very large database with several stored procedures. now, I need to find a stored procedure that does some calculation if that stored procedure has a string "MESSAGE"(just an example) in an IF statement somewhere down the procedure. currently i am opening every stored procedure,...more >>

question about the clustering algorithm
Posted by praveen konda at 10/10/2004 10:31:49 PM
hello everyone, i tried this question in olap room but there was no reply. i had a question regarding Expectation-Maximization algorithm used by microsoft for data mining in ole db. Does anyone know how good this algorithm is when compared to the latest clustering algorithms like chameleon, c...more >>

Using AMO object for Analysis Services - SQL Server 2005
Posted by anita at 10/8/2004 1:48:49 AM
Hi, I am trying to simulate mining model creation in SQL Server 2005, using C# in .NET. SQL Server 2005 has provided with AMO object model for this purpose. To use this object model, it is required to reference "Microsoft.AnalysisServices.dll" and "Microsoft.DataWarehouse.Interfaces.dll...more >>

Extracting by oldest date
Posted by IT-MAN at 10/3/2004 4:35:56 PM
How do I build query to extract the following columns from two tables? I need the following as a result: Order_History.Order_No, Order_History.Date_Changed, Employee.Emp_Name (Join on Emp_ID) Order_History Table: Order_No, Date_Changed, Emp_ID sample data .... 1001, 1/1/2000, aab 100...more >>

In a single query?
Posted by Tomislav Bilic at 10/2/2004 8:53:06 PM
Hello, Is it possible to make this on SQL server 2000? There is a table with a columns: SomeTime | SomeEvent 2004-09-22 08:00:00 | Event 1 2004-09-23 08:00:00 | Event 2 2004-09-24 10:00:00 | Event 3 2004-09-21 08:00:00 | Event 4 2004-09-22 08:00:00 | Event 5 2004-09-17 08:00:00 | Ev...more >>

Week values rolling over to new year. Help?
Posted by justino at 10/1/2004 5:56:32 PM
I have a report which shows quantities of items shipped in the 4 weeks prior to the date selected. Here is the formula I am using to calculate 1 week prior to the date parameter: If ({?ParamWeek}-1) <= 0 Then ({?ParamWeek}+52) Else ({?ParamWeek}-1) So I get: Week 1, Week 53, Week 52, Week 5...more >>


DevelopmentNow Blog