|
|
|
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 |
Summarizing data, grouping by time period. Posted by Nevyn Twyll at 12/31/2004 1:44:01 PM I have a table of student incidents, including absences from school, listing
the student ID, the date of an incident, and whether it was an absence.
I want to get a result set from this table showing me ON ONE ROW, the
studentID, and the absences split up by term.
Table: [Incidents]
Perti...more >>
cluster viewer question (yukon beta3 AdventureWorksDW) Posted by hari at 12/28/2004 11:56:48 AM Here is a snippet from beta3 booksonline (Viewing with Cluster Viewer)
that I can't understand:
"The location of clusters in the diagram represents their similarity.
The shading of the line connecting the clusters represents the strength
of the similarity. If the line shading is light to nonex...more >>
Half Hour Time Intervals Posted by Kent Prokopy at 12/28/2004 7:41:01 AM I have a table that stores three fields of information.
(AgentID Int, Orig DateTime, Term DateTime)
Example:
AgentID = 1, Orig = '12/27/2004 9:00:00 AM', Term = 4:59:59 PM
I would like a t-sql that will display this data in half hour intervals for
me.
Example:
AgentID = 1, Orig_Interva...more >>
Passing parameters to a view from ASP.NET Posted by James at 12/22/2004 5:19:31 PM Hia,
I have 2 tables, and i would like to create a view which shows all of
the names that are stored in one table, and next to each name (stored in
the first table TBL_TECHNICIANS) shows what job the person named has to
do on a specific day (stored in the second table TBL_SCHEDULE). I need
t...more >>
Adding a new cube to an existing virtual cube ??? Posted by Bob.Segrest NO[at]SPAM BSegE.com at 12/20/2004 5:49:43 PM Hello Everyone,
I need to learn how to add a new cube to an existing virtual cube using Visual
Basic or VBA.
Can anyone point me in the right direction?
Is this the right place to ask?
Is there an Analysis Server news group somewhere?
Bob Segest, PMP...more >>
open source software for CART and PCA Posted by Leo at 12/20/2004 5:49:19 PM I need open source software, or however a free software (i would download
and use it without pay!), for manage data with CART or Principal Component
Analysis. Tipically Matlab is the best software solution, but it isn't free!
GNU Octave is free but not more powerful! Then, please, could you he...more >>
Mining Wizard Posted by Rebekah at 12/16/2004 11:45:01 PM Hi,
When tried to run the Wizard, I encountered the error below:
"Unable to get the list for data Mining Algorithms....
Operations is not allowed when the object is closed..."
Any ideas what is that ? tks......more >>
syntax? Posted by ae at 12/14/2004 10:01:04 AM Can someone show me how to get the proper syntax working on this? It doesn't
update correctly, and I'm thinking it the Commision updates to PaymentAmount,
but it's real erractic and can't troubleshoot. TIA
UPDATE [Revenue Processing]
SET [Revenue Processing].[Commission] = [PAYMENTAMOUNT]-...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Need help with SQL Statement Posted by Kent Prokopy at 12/14/2004 7:31:03 AM I have a table that stores when an agent logs on and off a phone. The data
looks like this.
DATE, AGENT_ID, TIME_IN, TIME_OUT
1/1/04, 123, 12:05:00 PM, 12:37:00 PM
How can I write an sql statement that will show me the following:
DATE, INTERVAL, AGENT_ID, DURATION
1/1/04, 12:00:00 PM, 1...more >>
2005 data Mining tutorial? Posted by Datasort at 12/9/2004 7:43:03 PM Has anyone seen Doc regarding using the new data mining tools with the 2005
beta. The doc that come with the disk say “to be installed laterâ€. I am
looking for a tutorial for possible purchase of the product.
Links to the docs would be great
Thanks in Advance,
Stewart Rogers
...more >>
Primary key in sys* tables Posted by David Roy at 12/7/2004 6:39:05 AM What sys* tables contain the primary key indicator for the columns?
I need to do a select statement, however, I do find sp_pkeys function,
if I am correct, it is getting the value from sysname but I do not have
sysname....more >>
Help needed joining tables Posted by Icwicks at 12/7/2004 1:55:24 AM Hi please read through and be patient as I am a bit of a
novice.I am trying to create what I think should be a
simple query, but I seem to be making a pigs ear of it.
Here is the query;
select contact1.company, (contsupp.contsupref where
contsupp.contact like 'E-Mail Address' and contsup...more >>
How To Use Parameters in a View Posted by WStoreyII at 12/6/2004 6:59:03 PM the subject says it all,
thanks for the help
WStoreyII...more >>
ORDER BY question. Posted by Greg Collins [InfoPath MVP] at 12/2/2004 2:31:05 PM I have some data that I want to select with an ORDER BY statement and be =
able to have it sorted in a hierrarchical order.
There will be essentially 1) and ID, and 2) a ParentID.
I would like to have the data returned sorted such that any row with a =
ParentID =3D to an ID is under that ID
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |