| Groups | Blog | Home |
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by week: 1 2 3 4 5 Runtime error '91' Posted by Jasmine at 9/19/2003 7:15:27 PM 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 >>
conditions within stored procedure Posted by Wayne Hui at 9/19/2003 1:24:58 PM 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 >>
How to import data Posted by khan at 9/19/2003 11:16:35 AM 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 >>
Can I return the rowNumber in a select? Posted by Erik Jensen at 9/19/2003 9:11:31 AM 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 >>
Error when generating a virtual cube from an MDT model Posted by Taj Jessa at 9/18/2003 5:18:39 PM 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 >>
Materialized view maintenance Posted by Venkatesh at 9/18/2003 4:44:21 PM 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 >>
how to? append new records and delete missing Posted by Steve Chambers at 9/18/2003 6:54:15 AM 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 >>
Do i need to convert FoodMart 2000 from access to sql? Posted by Jasmine at 9/17/2003 7:34:18 PM 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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
Link not found Posted by siokping88 at 9/17/2003 7:26:45 PM 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 >>
Need help with database design Posted by Paul S. at 9/16/2003 9:16:14 PM 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 >>
Need help importing data to SQL Posted by Dan B at 9/16/2003 2:05:34 PM 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 to select 2 responses per person Posted by Will at 9/15/2003 1:51:51 PM 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 >>
|
| home · blog · groups | Questions? Comments? Contact the dn |