|
|
|
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 |
Complex query question Posted by Waterboy at 1/30/2007 11:15:04 AM Hello all,
I have a stored proc that grabs a lot of data (4520) rows per day. I need to
pivot the data but the columns are not the same everytime its ran, it depends
on the asset i have selected. i need to covert the data to a csv file, which
im currently doing in the presentation side, bu...more >>
Create Table in SQL Server 2005 Posted by Sean at 1/29/2007 9:34:00 AM I need to create the following table 'MyNewTable' based on TableA and TableB:
MyNewTable:
MyVal1 MyVal3 MyVal4 MyVal5 MyVal6 ----
44 66 77 88 99 ----
TableA:
ID Type Value
1 A MyVal1
2 B MyVal2
3 A MyVal3
4 A MyVal4
5 A MyVal5
6 A MyVal6
- ----(etc...)
TableB:
ID Value
1 44
...more >>
RE: Free mp3's Posted by anonymous_user NO[at]SPAM sqlserverdatamining.com at 1/28/2007 11:00:05 PM >
> <HTML>
> <HEAD>
> <META NAME="GENERATOR" Content="Microsoft DHTML Editing Control">
> <TITLE></TITLE>
> </HEAD>
> <BODY>
> <P>And much more that that!</P>
> <P><A href="http://forum.saait.net/">http://forum.saait.net/</A></P>
> <P>This site offers free and legal mp3's, software, movies...more >>
Joining the same table Posted by MMouse99 at 1/26/2007 1:42:03 AM 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.
SELECT TblSub.SubName, TblWeekly.LineId, TblLine.LineDesc, TblWeekly.Unit,
TblWeekly_1.Unit, Tb...more >>
Import PMML defined model Posted by anonymous_user NO[at]SPAM sqlserverdatamining.com at 1/24/2007 3:40:06 PM 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?...more >>
tutorial question Posted by marko at 1/22/2007 10:19:40 AM Hi,
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?
or at least which book would you recommend ...more >>
How to Solve Simple Scenarion Using SQL 2005 Datamining Posted by razi rais at 1/22/2007 5:40:07 AM 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
simple cr...more >>
Can anyone help me Posted by anonymous_user NO[at]SPAM sqlserverdatamining.com at 1/19/2007 6:20:05 AM 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.;3163]."
Coul...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Playing w/queries Posted by Ron at 1/10/2007 11:57:30 PM Hi,
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'd like to create an output where vertically ...more >>
Right idea for data mining? Posted by javawzl at 1/10/2007 7:29:00 PM 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 shown on the sit...more >>
MDX newbie question please Posted by Buster Coder at 1/6/2007 6:20:51 PM Hello,
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
State].[CA], [Store].[Store State]....more >>
Code to include a one-up suffix to a field value Posted by Doctorjones_md at 1/4/2007 9:46:55 AM I have the following INSERT statement (which works fine) -- what I need is
to modify it so that the value of the field "Location" will be passed to SQL
server with a one-up suffix (example: on the 1st pass, append "1" to the
location Dallas, to get "Dallas 1" on the 2nd pass, Dallas 2, ect --...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |