all groups > sql server data mining > december 2006
For/Next loop to process INSERT INTO statement
Posted by Doctorjones_md at 12/19/2006 11:48:52 AM
I reposted this because I was unable to achieve desired results from
previous recommendations.
Previous Post:
===================
I have the following code which does the following:
1. Deletes all rows having a value of "0" in column C
2. Uploads the data in Row 2 to my SQL Server
Wh... more >>
Virtual Cubes 2005
Posted by somuthomas NO[at]SPAM gmail.com at 12/15/2006 4:04:08 AM
Hi,
I am working on creating virtual cubes in Analysis Services 2005. I
dont know where to create virtual cubes from a regular cubes. I
searched the internet to know more but all they say is Analysis Manager
Tree pane, right click select virtual cube. I dont understand where
the Analysis ... more >>
Error using OPENROWSET
Posted by larclap NO[at]SPAM yahoo.com at 12/15/2006 12:40:19 AM
I have the following statement:
INSERT INTO MailHouse2.dbo.ClientUseCode
(ClientID, CountyFips, UseCode)
SELECT *
FROM OPENROWSET('SQLOLEDB.1','Provider=sqloledb.1;Data
Source=(localhost);Initial Catalog=MailHouse;uid=uid;pwd=pwd;',
'select 1 as ClientID,u.countyfipsid as Coun... more >>
SQL 2000 as Web Search Engine
Posted by Oren Levy at 12/12/2006 5:51:01 PM
Hi All
I’m trying to write a SQL statement for a web search engine, it should do
the following:
Break down the search string into individual words (for example: “500 MHz
microprocessor USBâ€) and do a Full Text Search on a catalogue for each
individual word and sort it by the rank.
I... more >>
Report Server and Data Mining Connection error
Posted by Erhan Erisken at 12/11/2006 4:32:08 PM
hi all,
I am using AnalysisServices namespace to get a list of cluster names in my
model and to access cluster discrimination of clusters.
Below is how I use this namespace functionality:
CALL
System.Microsoft.AnalysisServices.System.DataMining.Clustering.GetClusters('PersonelCluster1MM')... more >>
DMX Content Query
Posted by Erhan Erisken at 12/11/2006 12:00:00 AM
hi all,
I want to write a content query against my Clutsering model...
I have figured out smt like this:
SELECT FLATTENED
(SELECT ATTRIBUTE_NAME, ATTRIBUTE_VALUE, [SUPPORT], [PROBABILITY]
FROM NODE_DISTRIBUTION ) AS d
FROM PersonelCluster1MM.CONTENT
WHERE Node_Type = 5 AND NODE_CAPTION = 'C... more >>
|