|
|
|
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 do Ignore lowercase data in the where clause Posted by Phillip at 2/28/2005 7:34:23 AM I have a table with values in a name field that are both lowercase and
uppercase. I want to select the records that only have uppercase names.
How do I do this?
I didn't see a sqlserver.query group so I figured this was the right
one.
Thanks,
Phil
...more >>
Cannot save object inside a Decision Support Objects (DSO) transaction. Posted by John Jayaseelan at 2/25/2005 7:08:03 AM Hi,
The mining model returns the following error while processing from
Analysis Manger-> Mining Model -> right click -> Process, but processing
from the edit screen does not give error.
'Cannot save object inside a Decision Support Objects (DSO)
transaction.'
Thanks,
*** Sent via ...more >>
Collation Problem any help Posted by Rani at 2/22/2005 1:35:14 PM Hello all :
My problem is like the following I have an online databse with a latin
collation, this database is using ntext and nvarchar values that was with our
previous admin ok the problem is in the data is stored should use another
collation (the arabic collation) ok ... now I want to u...more >>
Unable to connect to Posted by Jacky Foo at 2/19/2005 9:37:38 AM in order to connect to Analysis Server thru ASP.net, i
need msolap.asp to be copied to the default website.
however, my registry do not have msolap registered at
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Provider
s\MSOLAP], i cant run http://localhost/msolap.asp on my
server.
i ha...more >>
Predicting numeric values Posted by B.J. at 2/19/2005 8:17:04 AM Hi,
Can I predict numerical column in SQL Server ? (Input columns are also
numerical).
Thanks...more >>
COLLATION PROBLEM CAN ANY ONE HELP Posted by Rani at 2/18/2005 7:05:03 AM Hello every one :
This is my case : I have a Latin collation database that contains data in
another sorting order using the enterprise manager it looks like garbage
mining data in ASP it looks ok my problem that i'm doing a data transform to
another database with another collation !!! I can't...more >>
Reprocessing a mining model Posted by d.kiesling at 2/17/2005 8:22:28 AM I'm currently developing a user registration prototype.
The aim is to classify certain types of users. However,
after the registration I query a decision tree model in
Analysis Services with DMX and I want to send the user
data into the warehouse to improve the mining model with
new data t...more >>
Update serial number in database Posted by AK Yeoh at 2/16/2005 3:55:35 PM Hi,
I want to update specific fields in a existing table in SQL database as
below example:
L240100001-LG
L240100002-LG *serial number is difficult to update one by one
L240100003-LG
L240100004-LG
L240100005-LG
change to
L240100001-L
L240100002-L
L240100003-L
L240100004-L
L240...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Trying to cut down query times Posted by Atley at 2/16/2005 1:51:38 PM I have a query that is based on two other queries that are based on tables
in a database.
All of the queries that are used for this final query use grouping and
totals.
In the application I am making, I need to choose a date range to select the
subset of the data I need. This is done in th...more >>
Newbie question Posted by J DUDLEY at 2/13/2005 6:23:17 PM I have SQL Server 2000. What add-ons do I need to try data mining, and
where do I best go for resources/references?
...more >>
Scripting data mining Posted by B.J. at 2/10/2005 11:25:02 AM Hi,
Can I execute from code refreshing of data and full processing of Mining
Model ?
And also execute prediction query on this mining model with client input ?
Thank you...more >>
Downloading File located in SQL Server with ASP Posted by fibreiv at 2/10/2005 6:11:05 AM I have a SQL 2000 Standard server setup and I have a table in one of my
databases to store files in. I am using asp code to retrieve the files from
the database. I can download txt, bmp files just fine but when it comes to
pdf documents it just hangs at the downloading the file screen and th...more >>
Paging in SQL Server, an overview of some available approaches Posted by Stefan Rosi at 2/8/2005 1:12:22 PM Hallo everybody,
The question sounds very simple, but as I think it's not!
I searched about this subject a lot and I found the following approaches,
and I really don't know which is the best or at least when to use each
approach.
The first one and most used (as I noticed ) is to copy all...more >>
Joining a table and a view with identical column names? Posted by Rory at 2/4/2005 5:55:27 PM I am trying to join a view and a table that share common column names. I
have a view named SC_Computer_MaintenanceServerUptimeReport_View (I know,
can I make it any longer) and a table called uptime. The columns in
SC_Computer_MaintenanceServerUptimeReport_View are:
ComputerDomain, ComputerNa...more >>
Updating a recordset within a Self Join Posted by Chris at 2/3/2005 9:15:07 AM Hi
I have a software table with a million records. I need to elimante all the
older version of IE that may be in the table.
This is the SQL I am using. The duplicate field is bit.
UPDATE software
SET Duplicate = 1
WHERE EXISTS (SELECT *
FROM Software AS sf2
...more >>
SQL Timeout Error Posted by 11Oppidan at 2/2/2005 12:12:21 PM Hi,
I have a curious situation which I have failed to resolve.
I have a program written in VB .NET which uses ADO.NET to populate a dataset
from MS SQL using a Sqlconnection and a Sqldataadpter. For 99% of the time
it works fine. For 1% of the time an exception is thrown on fill due to a...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |