Hi Everyone, I'm new to the SQL Server world. I am looking for a tool similar to SQL navigator in Oracle, that will optimize Sql queries for me. Any suggestions? - SM ...more >>

I have the following data RecordID EmpID LastName FirstName SomeDate 1 1234 Smith Bob 01/01/2003 2 1234 Smith Bob 01/02/2003 3 1234 Smith Bob 01/03/2003 4 1234 Smith Bob 01/04/2003 5 ...more >>

Hi Please help me URGENT How do i make an tableField with a Auto-Incr, the same like in an access DB where it's called AutoNumber Thanx in advance __________________________________________________________________ Flemming Paulsen ICQ#: 270065050 Current ICQ status: + More ways to contact m...more >>

Hi, I am using the built in Microsoft Decision Tree to perform some data mining task on my Analysis Server (SP3). I have some difficulty to understand how it pickes the node and how it splits and terminates, etc.. I'd really like to know how the algorithm works. Another question is: I...more >>

Hi, I am a programmer with resonable knowledge in SQL SERVER and DTS I am interested in expanding my knowledge in Datawarehousing, Cubes and OLAP Tools what would be the most logical step by step way to do this. What are the various books and websites that teach you these things What are t...more >>

Microsoft User this is the latest version of security update, the "September 2003, Cumulative Patch" update which eliminates all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now to ...more >>

It is bad enough that my email address got harvested for the fake Microsoft IE 4.01 product alert email that has a virus attachment as a security patch. But I think the posts should be more closely censored as you can see from some of the posts in this newsgroup. -- ***********************...more >>

My question is kinda long. Thanks for your patient. =) 1. I am using the OLEDB-DM-Doc.vbp to modify the customer segmentation of FoodMart 2000. I open the OLEDB-DM- Doc.vbp, and added the Microsoft Decision Support Object from the references. Other things such as decision tree code and lif...more >>

Hi, I was wondering if there's a way to put conditions within a select statement in a stored procedure. For example if I want to do different ordering depending on the input type - ALTER procedure test @inputType int AS BEGIN select * from someTable if (@inputType = 1) ...more >>

I am new to SQL server 2000. I want to make a database in SQL server. The data that I have is in a text file having field names at the top and the data is line by line delimited by pipe. I dont know how to upload the data and make a database. Any idea. Please help. Thanks....more >>

Is it possible to use a stored procedure that would select data, but the first column in the resultset would be the row index of the result set? like select (the row index),dataCol1, dataCol2 from tableName results: 1, dataCol1, dataCol2 2, datacol1, dataCol2 etc.. Thanks ...more >>

Hello. I get the following error when I try to generate a virtual cube from an MDT data mining model: Error(-2147221425): The object structure is not valid (The SourceTableFilter of a dimension of subclass type sbclsMining must be of the form "MSOLAP_MODEL_COLUMN='<column_name>'".); H...more >>

Is the materialised view maintenance done within the same transaction as of the operations on the base tables or is it done at a later point . Say an INSERT occurs on the base table will the materialized view be updated in the same transaction or will the update happen asynchronously a...more >>

Hi, I'm have an access db which I regularly import into SQLServer. The access db has new records added and some records taken off so I use the DTS wizard and delete all the records and then insert the new records. My current process needs changing as I need to add a couple of fields to t...more >>

Hi there, i am using the customer table from Food Mart 2000 to do data mining that is to segment the customer. I will be using VB and dso to create the mining model. Do i need to convert the FoodMart 2000 from access database (.mdb) to sql database in order to do the mining? thanks in ...more >>

Hi there i try to access the OLEDB for data mining resource kit in the FAQ section(Microsoft.public.sqlserver.datamining FAQ (Frequently Asked Questions and Answers)) but error page came out saying the link may already moved or not found. where is the actual link? Thanks a lot! ...more >>

I am in the process of designing a database for a client and am having a mental block on how to design and integrate the tables. The database will be used for inventory control and e-commerce. Here is a brief description of what is needed: He has 5 basic products. Each product has two par...more >>

Hi, I have an Excel Spreadsheet with data that I need to get into a SQL Database. What is the best way to do that? Thanks, Dan ...more >>

Need a little help. I am pulling data from an Oracle DB and need to limit the data pull to two responses per person. I have 75 Users, I pull 10,000 records for these users. I created a temp table and INSERTED User, responses, and Date. How do I Limit the results to get only two responses ...more >>

i facing below problem, but after i restart server, it will work = again... Microsoft OLE DB Provider for ODBC Drivers error '80004005'=20 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist = or access denied.=20...more >>

how to create running sum fiels in a sql server 7.0 view? i have a 5000 fields and i just want each of them to have a number starting from 1 to 5000 , i want to do this in a view. ...more >>

How can I get modify-date of table with SQL query ...more >>

Hi, I am stuck on the question how to use Query to retrieve the 'language' spoken by all the students from the following table: studentId language --------- ------- 10541000 English 10541000 French 10541012 German 10541012 French 10541012 English 10541023 Chines...more >>

I am trying to get the net monies recieved for any given month. A typicl transacyion looks like this ACNO TRNTYPE TRANDATE AMOUNT VATAMT MATCHDATE ------------------ ------- --------------------------- 217224 SIN 2003-06-30 -64.6500 -9.6300 2003-07-31 217224 MQR 2003-...more >>

is there an easier way to find if a field is lowercase other than: WHERE (CHARINDEX('a', [$WhereField]) <> 0 OR CHARINDEX('c', [$WhereField]) <> 0 OR CHARINDEX('d', [$WhereField]) <> 0 OR CHARINDEX('e', [$WhereField]) <> 0 OR CHARINDEX('f', [$WhereField]) <> 0 OR CHARIN...more >>

Hello, I use Access form1 to insert data into a table residing in SQL2k. When I use form2 to update the already saved data and 'SAVE' is executed, a window pops up stating that an other user has changed the data and suggests to save the changes in the Notepad for later view. But, it doesn't save...more >>

Hi, Having a problem. I have a table with users and responses. I need 2 distinct responses for every user in the table. Doing the SELECT TOP 2(candidate_ID), * only pulls 2 records from the first user. Putting the top 2 in the where clause doesn't work either. Totally having a brain cr...more >>

I need some help with a T-SQL statement. Any help would be greatly appreciated. Database has one table with two fields: FileName & FilePath. FileName and FilePath individually are not unique, but together they must be unique: FileName FilePath 1 "DailyReport" C:\......more >>

Is it possible to put a conditional statement in a select that assigns a value if one is not derived?...more >>

Hi Suppose i am using northwind database and that I want to use authors table in Pubs Database. How can I do that? Can I make a table link like I can do at Microsoft Access?? How is the best strategy? Thanks for your help...more >>