I have three tables: Products Table PID PName PType Linking Table LID PID CID Customers Table CID CName CPhone I am trying to make a single statement that will give me all the customers that haven't bought a certain single product so i can make a list of people to c...more >>

I have three tables: Products Table PID PName PType Linking Table LID PID CID Customers Table CID CName CPhone I am trying to make a single statement that will give me all the customers that haven't bought a certain single product so i can make a list of people to c...more >>

Hi all, I'm running SQL Reporting Services and my question is: Can I connect the datasource of my reports to a business logic object that returns a dataset instead of using a direct connection to a SQL Server? Anyone that knows if and how this can be done? Regards -Janne Hasslöf...more >>

I have the following table idProcessMember(PK) idProcessMemberGroup 0001 0002 ---------------------------------------- 0002 0003 ---------------------------------------- 0003 0004 ---------------------------------------- ...more >>

Are you certain that the database files are actually fragmented. i think SQL has a good way p of preventing fragmentation for that would seriously slow down the server. you could Stop Sql Server, off load the db files onto another drive. Either through backup and restore or as flat fil...more >>

Hello everyone, I've created a mining model using MS Decision Tree and trained it Now, i need to query it, the only codes i found was using an openrowset or Model Content, simply i need to check the category of certain conditions, as: SELECT <<prediction>> from MiningModel>> WHERE <<Mini...more >>

http://www.microsoft.com/sql/reporting/productinfo/trial.asp If you have a SQL 2000 license, you can use the software. I don't work for Microsoft, but I am excited enough to see this that I wanted to send out the link. I have been waiting a long time to move beyond the limits of Infomaker or...more >>

I am trying to defrag my Hard-disk drive. Windows 2000 Server does not defrag my drice compoletely as major portion is occupied by my SQL database whose size is around 2GB. The Defrag program on completion says that it cannot defrag the SQL Database files. Then how do I do it? Is there any way t...more >>

Hi, Can anyone help with how to query a mining model? SELECT * FROM MiningModel.Content this query returns the schema not the columns inside the model, so how can i select a statement for the columns in a mining model...more >>

hi, i'm using relational decision tree data mining model, i've used DSO to create the model and train it now i need to browse it at client, i've tried to use pivot table but each time i pass to it connection, it raises an exception: Not supported interface, when i tried to run it directly ...more >>

hi, can anybody help me with a code sample for retriving output from mining model! i need to determine what type of search categories is the output about? will you please help...more >>

I have a need to create an sp where inside that sp I make a call to another sp passing in the appropriate parameters then have that result set be used in a cursor set that I can then walk in the calling sp. Does anyone have any sample code I can see? Thanks!! -Richard K ...more >>

SET pRS = Connect.Execute("Select * FROM Product WHERE ItemNr in(Select ItemNr FROM Relation WHERE FuncID = "&Request.QueryString("funk")&" AND CatID = "&Request.QueryString("cat")&")") This query results in following message: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Mic...more >>

I need to know how to install arabic language in SQl 4.2 or how to migrate arabic data stored in SQL 4.2 to SQL 2000 or did any one have the following files : Common.loc & Server.loc...more >>

I need to know how to install arabic language in SQl 4.2 or how to migrate arabic data stored in SQL 4.2 to SQL 2000 or did any one have the following files : Common.loc & Server.loc ...more >>

Hi I am defining a new dimension. When I select a table as the source of the dimension and try to choose a columns of the table as dimension levels, any text based column of the source table dissappears from the list when I go to choose levels. The source tables come from DB2 for the AS...more >>

data in single cell / field of record has multiple rows. We are exporting data to text, however, there is a row delimeter within cell and it carries into the text. This of course is messing up the text file which needs to be tab delimited with one {cr}{LF} per record. Any ideas as to ho...more >>

I have a bunch of pictures that i would like to link to corresponding people. The pictures are located on a different drive and i am not sure how to tell my MS SQL 7 server how to locate the picters and tie them into the record. I would also like to have the pics displayed on the web. Thanks,...more >>

Hi.. I have a row in a table with 4 fields, for arguments sake, "FIELD1", "FIELD2", "FIELD3", and "FIELD4" I am working on a stored procedure and what I have so far is something like this.. declare @x as int declare @fieldName as char(6) declare @field1value as int declare @field2value...more >>

I have a table in which I have a date field and an identity field. I want to create values in an indexed bigint field consisting of the date in the form yyyyMMdd with the value of the identity column tacked on the end so that I can quickly identify the last record entered on any given date. I want...more >>

I need common.loc & server.loc files to add arabic language to my sql server...more >>

The FAQ (Frequently Asked Questions and Answers) for = microsoft.public.sqlserver.datamining has been updated and uploaded to = the MSN DM group site = (http://groups.msn.com/AnalysisServicesDataMining/faq.msnw). In this = FAQ, I have added 16 new items based on postings so far, updated = exist...more >>

The OLE DB for DM Sample Provider source code have been updated to be used with newer Platform SDK. The source code have been uploaded to http://download.microsoft.com/download/2/4/1/241c5e74-2275-470b-97c8-d3f4a210b9d3/DMSampleProvider.zip. Please read ReadMe.htm in the zip file for details. Th...more >>

Hello, Need some help: I want to convert the multiple records into one record by grouping. I have a table like this: person response 100 'R' 100 'A' 100 'B' 200 'R' 200 'A' : I want to convert them into a new table like: person response 100 ...more >>

Hi, I have a table containing 0.3 million records. I have to use a not exists / not in on this table for a set of conditions. I tried putting index on this table. Roughly my not in/not exists needs to fire six times. But even after creating an index, I am not able to see a performance im...more >>

I was trying to delete all but the first record with a duplicated email address. The following script did the trick, but for some reason, the WHERE clause didn't work. It also deleted NULLS. Any ideas how I can run this script without deleting nulls? Any counsel is very appreciated. - Justin ...more >>

Hi, Can anyone show an example of data mining model shcema of the "diaper and beer" cross sale. This model predict that people buy beer also buy diaper. Thanks alot. Noldz ...more >>

Hi, Is it possible to write back to an OLAP cube/data table from Excel? Sorry if the question is obvious. I am from Essbase background trying to learn SQL AS. I would appreciate very much if somebody can point me some links on this topic. Many thanks in advance. Regards, Yee ...more >>

H I need to get the table name(s) and the column name(s) present in a query before it is executed against the database. Are there any built-in functions (in SQL Server or in C#)? I came to know about "ODBC minimum SQL Grammar" from MSDN. Anyone knows whether it'll serve my problem TIA Arrun S...more >>

Hi, I'm just wondering if anyone can provide the actual formula that is used (by Microsoft SQL Server) to get probability, variance, adjusted probability, support, etc? Also, can anyone explain the difference between Probability and Confidence level? Thanks a lot! Poch ...more >>

I have address information that has been entered into a field that has just that, address info. The only problem is this: Some Company Some Address. So when i view the record it only shows the Some Company line until I arrow around inside that field. I need to know how to create a view that a...more >>

The below is a paste of a query within SQL2000 that works. I copy the query to VB6.0 and get the error further down. A copy of the table structure is below that. The Department and SectionNames tables are used to define the Department names and Section Names for people who want training...more >>

Hello, Happy New Year! We need help on some questions regarding the SQL Server data mining. I hope you can help us on this. Here are the questions: a.. In dependency browser, what does "strongest link" mean? a.. Does this mean that those with strongest links are the ones with the...more >>

First off, Is this the proper newsgroup for the question below? If so we are having problems migrating from ACCESS mySQL to SQL Server 2000. Until now we used a combination of mySQL statements and ASP code, now we need to know if we can do the following using only SQL statements. I have t...more >>

Hi I need to be able to pass data from one database (say called DBCapture1) running in one instance of sqlserver (say called DBServer1) to another another database (say called CompanyDB) running in another instance of sqlserver (say called DBServer2) What's the least troublesome way of doing it?...more >>

Computed Columns have no phisical space on Databases, only the formula result they represents, or not ?? Beforehand, thank you very much. LUIS...more >>

Happy New Year!!!! I want to know which is the best way to use the GrandTotal Column in a Database Table. Generally, GrandTotal is the result of a formula that involves other columns values: (SubTotal + Taxes) or (Price * Quantity * (Discount)), etc. 1.- Is it necessary to use a GrandTot...more >>