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.

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 ...

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

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 have a Stored Procedure:
SELECT cost_center,account,employee_number,sum(reg_hrs)
as RH,sum(ot_hrs) as OH,sum(reg_pay) as RP, sum(ot_pay)
as OP

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]

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

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

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;

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.

I tried various ways to format my result for the count, to no avail.  Can
someone help me out?  I am using SQL Server 6.5 and am doing a COUNT after
the count I would like to format the result in SQl such as, if the result is
25 to add three zeros after it?

the subject says it all,
thanks for the help
WStoreyII

I declare a VARIABLE number of columns, in this case, days of a month, and
display the amounts of product orders, something like:
                    Jun,18     Jun,19     Jun,20     Jun,21      Jun,22    
     Jun,23