|
|
|
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 |
how to get the PMML xml content? Posted by XP at 12/30/2003 5:53:13 PM I want to read the pmml xml about model,show the decision tree in my UI =
control.
how to do? =20
Can i use ADO or jdbc do that?...more >>
Data Mining Web Client Posted by Alex at 12/26/2003 2:23:52 PM Hi,
Where I can find commercial or free Web Client for browsing the Data Mining
Data.
Alex
...more >>
NEW TO MINING Posted by JEG at 12/25/2003 8:04:07 AM Hi all,
I am new to mining.Advice me regading where to
start with .I have AS2K with SP3 and SqlServer2k + SP3 ..
How can we access DataMinig from dotnet..Any Ideas
highly valued..
Regards
Jeg...more >>
GROUP BY WITH ROLLUP issue Posted by BobM at 12/21/2003 4:40:07 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
FROM Payfile
WHERE week_end_date=@WEDate
GROUP BY cost_center,account,employee_number
WITH ROLLUP
The query runs fine, EXCEPT the totals rec...more >>
Calling Calculated fields in the same Query? Posted by Richard Morey at 12/17/2003 2:24:20 PM I am trying to run this query:
select address1,
charindex(',',address1,0) as st,
charindex(',',address1,charindex(',',address1,0)+1) as fn,
substring(address1,st,fn-st) as city
from tableHouses
where address1 like '%,%'
But I get this error:
Server: Msg 207, Level 16, State 3, Line 1
...more >>
Sql Server Error 3242 Posted by Lalit Kumar at 12/16/2003 11:08:29 PM Hi
My hard disk got crashed. With the help of third party
software i took backup of my corrupted database but now as
i am trying to restore the database it gives me error the
file --- is not valid microsoft tape format.
Thanks
Lalit Kumar
...more >>
Convert decimal value to time format Posted by Joe at 12/15/2003 2:36:05 PM Hi
I am querying a timesheet database and am pulling out decimal values that need to be converted to time format HH:MM
I have used the CAST command to change these values. The problem is if any time value is >24, I get a format in microsoft excel of HH:MM:SS not HH:MM.
CASE WHEN CAST(SUM(ti...more >>
Reporting Services! Posted by Petrucci2000 at 12/15/2003 10:37:56 AM Hi All, Does anyone know the release date for Beta2 of the SQLServer
Reporting Services?
TIA
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Help me combine / delete duplicates across two tables.. Posted by Richard Morey at 12/12/2003 3:03:00 PM Hi,
I am at a total loss as to how to accomplish a task..
I have one table with two sets of values.. like this
1000,september
1234,september
1566,september
2000,october
2010,october
2022,october
and a second table with one set of values
1000
1234
1000
1566
1000
2000
2010
2...more >>
Update query Posted by Luiz Horacio at 12/12/2003 12:01:23 AM Hi,
I'm having a problem to update values in one table.
I have one table:
table1.login_id
table1.pat_id.
I have another table:
table2.login_pat
table2.pat_id.
Table2.pat_id has values that I need to update in table1.pat_id, where
table1.Login_id = table2.login_pat
Tried a lot, bu...more >>
Arithmetic overflow error converting numeric to data type numeric. Posted by Richard Morey at 12/11/2003 10:31:18 AM Hi,
I am trying to move data from an old Access db into SQL 2000.
I have imported the old Access db into SQL and now I am running queries to
move the data from the old tables to the new tables. If I run this
statement:
SELECT CONVERT(NUMERIC,LEFT(GARAGE,3)) AS GARAGECARS FROM OLD_HOUSMAIN...more >>
Collecting data from multiple tables into one Posted by Daniel Jonsson at 12/10/2003 5:01:13 AM Hi!
I'm quite new to SQL Server, but has worked with Access for some time.
I receive datafiles once every day, in textfiles. I've set up a DTS import of the files and now I want to merge the data.
I have three different tables containing products that I would like to merge into one table. Als...more >>
Select Top not working Posted by Shirley Vickers at 12/7/2003 2:58:29 PM Is there a server setting which affects whether
the 'Select Top n ...' statement can be used? We have SQL
Server Developer Edition 8.00 on two servers - the same
statement works on one server but not the other.
The statement:
select TOP 3 * from generators
Gives an error message:
Se...more >>
DISTINCT and Duplicates Posted by George Antoniou at 12/5/2003 6:17:00 AM Hello!
I have to make a query,that combines two views,and gives
me result about IDs and Origin!
However,one of my two views has for one ID number,2
different Origins!
As a result,when I run my query,I get a number of results
that is far greater than it should be, because it returns
twice ...more >>
sum Posted by stermic NO[at]SPAM gw.co.jackson.mo.us at 12/4/2003 8:00:01 AM i'm trying to run a crystal report with a sum of a certain column of
dollar amounts. the problem is that there are certain instances where
some of the records are duplicated and unfortunately the duplicated
dollar amount is added into the total at the end. i'd like to know how
to prevent this fr...more >>
Find specific Text String in all database at once Posted by Qslx at 12/2/2003 7:56:05 AM Hello
I'd like to find a specific text string in all database tables. Is there a way to make only one query to all tables at the same time
Thank you very much for your attention
Qslx...more >>
multifactor regression Posted by tc at 12/1/2003 9:16:45 AM Does anyone have tips on custom functions/3rd party
products to calculate multifactor regressions on data
contaiend in a SQL database, amd then store the regression
results (coefficients, t-stats, etc.) within an SQL
database?...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |