I need to create the following table 'MyNewTable' based on TableA and TableB:
MyNewTable:
MyVal1  MyVal3  MyVal4  MyVal5    MyVal6    ----
44    66    77    88    99    ----

Greetings All,
I have a table that records the sales by product by week.
I would like to show this week sales vs. last week sales within one query.
I have partially managed to achieve this.

Does Analysis services 2005 support import of custom mining algorithms defined in PMML? If so, where can I find basic information on how to do this?

please can anyone tell me where to find a good tutorial on Data Mining in
SQL Server 2005 that covers the whole process of data mining, from preparing
the data, models to testing and deploying a model on a new data set and
creating reports?

Hi to all
I want to know how achieve the following scenario, I will highly encourage if anyone knows
the solution please mention it through steps. The scenario is I have a table  named
?CreditCardTable ? with following schema , the table is pretty much what one expect from a

I am new to Data mining environment,during my regular eventviewer checkup I found that the following error occured frequently..
"Relational data provider reported error: [The field is too small to accept the amount of data you attempted to add.  Try inserting or pasting less data. ...

    I am working in Share point service now. I created a website using
share point.
I am having a forecasting model developed using Time series algorithm in
Sqlserver 2005.

As a Data Mining newbie I need to know whether I am on the right track ...
I have an external RSS feed which I show on a website. I would like to parse
the title of each item for data matches in our own database and then show
'related information' next to each item when it is ...

Have a complex (for me) query which combines several subqueries and tables
to get the following information:
Agent_ID, Agent_Name, (and their expenses) Transportation, Salary, Meals..
(and their incomes) Commissions, bonus,..and dates.

I have the following statement:
INSERT  INTO MailHouse2.dbo.ClientUseCode
          (ClientID, CountyFips, UseCode)
SELECT *

I am just getting into writing these queries and am trying to test with
a simple MDX query against my Sales cube that I've been working with
through the SQL Server 2000 Analysis Services tutorial:
SELECT Measures.MEMBERS ON COLUMNS, {[Store].[Store

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