While running setup for the Business Scorecard Manager 2005 Beta 2, when I get to the feature requirements analysis under web parts, I get the message "Failed Microsoft SharePoint Extended Site" How do I go about this in order to continue? Regards, Sam. *** Sent via Developersdex...more >>

There are 7 mining algorithms in sql server 2005. (Decision Trees, Association Rules . . .) How many the next version?...more >>

Hi, I got a number different selections for the same schema and table and I want to join them on the primary key to see if any row will show up in more then one selection. Is this possible? Thanks in advance! Oscar ...more >>

In this post I am going to try to simply a question that I posted earlier. Can I use VFP to access a SQL Database? If so what is the command? What is the best software for creating applications to work with SQL? I am just getting my feet wet with SQL so please take it easy on a rookie. ...more >>

I keep getting this error when i send a large document into sql server with ADO.NET System.Data.SqlClient.SqlException: XML parsing error: Not enough storage is available to complete this operation. I have about 8 gigs of memory on the machine and sql server isnt using even half of it. any way to...more >>

Hello , I have created a scorecard and want to map it to the analysis cubes. The scorecard has 2 Perspectives whose KPIs are to get their values from 2 different cubes in analysis services. The problem is when I go to map the scorecard to the views, I can only select one cube and use ...more >>

Hi there, I know there is a book on this topic, BUT is a star schema the optimal data model design for data mining ? I assume so since 3NF or highly normalized models are more complex to query.. any thoughts would be appreciated. Thank you, Jack ...more >>

Hello Other than the following character:' are there ay other character that may cause a problem in SQL Server specifically invisible characters? Thank you, Shmuel Shulman SBS Technologies LTD (UK) ...more >>

I've created a view joining (in essence) customers with sales. I am then trying to predict sales amount (continuous) by customer attribute inputs. I selected DISCRETIZED(EQUAL_AREAS,4) for the predicted variable (sales amount). What I don't understand is what "value" is telling me in the mod...more >>

I've created a view joining (in essence) customers with sales. I am then trying to predict sales amount (continuous) by customer attribute inputs. I selected DISCRETIZED(EQUAL_AREAS,4) for the predicted variable (sales amount). What I don't understand is what "value" is telling me in the mod...more >>

I have create an asp.net(.aspx) page, with a PivotTable control. I noticed that, I can't reference it in my code-behind(.aspx.vb), because it doesn't has the line 'Protected WithEvents PivotTable1 As OWC10.PivotTable' as creating other controls, liked Label, Button, ... Can anybody teach m...more >>

shopper_tracking shopper_id tracking_num closed date_entered 12345 1za45690987 1 8/15/2005 65984 1za45690988 1 8/15/2005 23569 1za45690990 1 8/15/2005 25648 1za45690991 1 8/15/2005 25648 ...more >>

I am wondering about the availability of the analytic functions LAG and RANK within SQL Server 2000. THese are available in Oracle, but I was wondering about SQL Server. Please help...more >>

I'm stumped with trying to create a dynamic query against items in two many-to-many relations that are both related to a single features table. For simplicities sake, I'll say we've got a table called FEATURES, to which we can add "features" for a specific critter. It would have a PK and a ...more >>

Hi, I am trying to make a calculation, which requires me to work out the average of the lowest 6 numbers of 12 numbers. Can anyone assist me in how to create the select statement? Thanks in advance ...more >>

Hi, I've a dialog form which interacts with a stored procedure to select a range of dates. A command moves the data to a report, in theory, but it's not working. SELECT dbo.CLAIMS.CLAIM_ID, dbo.CLAIMS.NAME, dbo.CLAIMS.DATE_IN, dbo.CLAIMS.SALE...more >>

I want to know how to retrieve records from a SELECT command in sections. I mean, if total records of a SELECT command is 100,000, I want to use SELECT that retrieves me them in 20 "sections" of 5000 : first 5000, second 5000, sixth 5000 or the last (20th) 5000 according what section I want. C...more >>

Hi, I am trying to read column description through SQL query. Basically I am designing a search box with one combo box and one text box. The combo box holds the column names from the specified table, but actually the column names are abrivated therefore I want to load the column descriptions...more >>

Hi, I am having a problem with a SELECT Command. I am wanting to search unique queries from TableA where Field1 = "specific Criteria" and Field2 = "Another Specific Criteria. The string that I have is as follows: SELECT DISTINCT * FROM Table WHERE fld1 = 'opt1' AND WHERE fld2 = 'opt2'; ...more >>

Dear All, The SQL Server 2000 in my network is hosting many database for many business units within the organization. The server is heavily used for data collection and web hosting. One of the .LDF file has grown very fast and I am very sure that it is impossible for the file to grow tha...more >>