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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|