|
|
|
January 2003 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 |
Filter by week: 1 2 3 4 5 Import Human-Readable text file into SQL Server 2000 Posted by sstorhaug NO[at]SPAM webuniverse.net at 9/30/2003 10:03:01 PM Hello,
I am receiving a text file that is produced from a mainframe that is
out of my control. I am attempting to find a (hopefully clean) way to
import it into a SQL Server database in an automated fashion. I am
not really concerned about how many tables it requires or what the
schema look...more >>
FoxPro Index called from SQL Server Posted by Steve Perry at 9/30/2003 6:54:46 PM Hi,
I have a large FoxPro table with an index that I need to be Queried from SQL
Server by OLE.DB or ODBC. If I query the DBF directly a search takes 1
Minute +. Is there a way I can call the data from the table and use the
existing FoxPro Index?
Thanks
Steve
...more >>
Retrieve One Row at a time Posted by chris NO[at]SPAM dagran.com at 9/30/2003 5:43:13 PM Hi,
I am going to be difficult here... How do I retrieve one row at a
time from a table without using a cursor?
For example, I have a table with 100 rows. I want to retrieve the
data from row 1, do some stuff to it and send it on to anther table,
then I want to grab
row 2, do some stuff ...more >>
Calculating Time Difference Posted by Shaun at 9/30/2003 4:02:58 PM Hi,
I have a table called Bookings which has two important columns;
Booking_Start_Time and Booking_End_Time. These columns are both of type
DATETIME. Given any day how can I calculate how many hours are available
between the hours of 09.00 and 17.30 so a user can see at a glance how many
hour...more >>
Return Value in a Stored Procedure Posted by frank niedermeyer at 9/30/2003 3:49:50 PM Hello Newsgroup !
My Tools are:
Windows 2000, VBA(Access 2000) and MS SQL Server 7.0
I wrote in an *.adp project (Access 2000) a Stored Procedure "xyz"
with parameters a,b
In my VBA Code i wrote:
Dim par As New ADODB.Parameter
Cmd.CommandType = adCmdStoredProc
Cmd.CommandText = "[p...more >>
how to add column in database at runtime. Posted by NetPointer at 9/30/2003 3:00:02 PM Hello all,
I m trying to add a column in my database (it is a csv file)
but it is giving me following exception.
------exception------------
{System.Data.OleDb.OleDbException}
ErrorCode: -2147467259
Errors: {System.Data.OleDb.OleDbErrorCollection}
HelpLink: Nothing
InnerException: Nothing
...more >>
TEMPDB now at 4 GB Posted by steve.archer NO[at]SPAM deaconessokc.org at 9/30/2003 2:05:04 PM I have shut down the SQL agent, rebooted the box and still my TEMPDB
is at 4 GB plus. Is there any way to shrink it another way?...more >>
Cannot convert Varchar to Numeric issue Posted by Michel at 9/30/2003 1:34:21 PM Hi again all,
I have a small issue. Here's an example dataset :
F1 F2 F3
1 0.58 Hi
2 0.70 Hello
3 Fail Bye
4 <Null> Hi
When I write this statement :
SELECT SUM(CONVERT(DECIMAL(16,8),F2)) MySum
FROM T1
WHERE IsNumeric(IsNull(F2,'X'))=1
I get "Can...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQL Server Hogs 100% CPU Posted by abbasrazam NO[at]SPAM yahoo.com at 9/30/2003 12:28:03 PM I am running a t-sql script which makes a bunch of calls to stored
procedures, updates few tables and inserts records. I do this in Begin
Tran and commit. The problem I am having is that SQL Server hogs 100%
of cpu. This degrades the performance of other applications obviously.
The memory it use...more >>
Looping database queries Posted by julian.rickards NO[at]SPAM ndm.gov.on.ca at 9/30/2003 10:58:09 AM Hi, newbie here:
I have created a small (5 fields) Access table which I will be
converting to MS-SQL Server format when the ASP code has been
completed. It is basically a collection of links to news releases from
mining companies. The group of people who will be browsing this
database want to...more >>
Many fields update from a Group by Clause Posted by Michel at 9/30/2003 9:26:29 AM Hi All,
In Oracle, I can easily make this query :
UPDATE t1 SET (f1,f2)=(SELECT AVG(f3),SUM(f4)
FROM t2
WHERE t2.f5=t1.f6)
WHERE f5='Something'
I cannot seem to be able to do the same thing with MS-...more >>
Connection.CommandTimeout Posted by peter.dawson NO[at]SPAM kingsch.nhs.uk at 9/30/2003 6:33:02 AM Running VB6 with SQL Server 7, opening a connection and setting this
parameter by Conn.CommandTimeout does not always seem to force a
command (stored procedure) executed through Conn.Execute to timeout
after the specified period. Is anybody able to suggest what may be
going on here.
Thanks...more >>
where clause messed up Posted by PipHans at 9/29/2003 9:31:36 PM Hi,
Consider this (light example):
SELECT [template].[id], [template].[navn], [tvalues].[id]
FROM template LEFT JOIN Tvalues ON [tvalues].[templateid]=[template].[id]
This returns ok. But I have a clause on the Tvalues like this:
WHERE [tvalues].[nr]=1;
Now I dont get what I want any...more >>
Cursor, Query, View and Recordset Posted by sci at 9/29/2003 7:07:14 PM Could someone help me by answering the questions below?
What's a cursor?
What's difference between Query and View?
Is a RecordSet just part of a table? Can it be part of a query of view?
If the content in a table changed, is it necessary for a old recordset to
renew itself by do "Requery()"?...more >>
About virus Posted by ALEX KLEIN at 9/29/2003 5:15:48 PM During last 10 days I receive a lot of viruses in my email. Analysis showed
me that this virus touched all users that participate in news server.
Article http://update.internetweek.com/cgi-bin4/DM/y/ec5O0B4qcg0V30B85D0Ap
that I read today proved this.
I recommend to everybody who care about his...more >>
Select, insert and delete queries timing out Posted by Simon Withers at 9/29/2003 2:01:57 PM I am using a sql server 2000 database to log the results from a monitor
that I have running - essentially every minuite, the table described
below has a insert and delete statements similar to the ones below run
againt it.
Everything is fine for a few weeks, and then without fail, all accesses...more >>
Rows as Columns Posted by Guinness Mann at 9/29/2003 12:30:53 PM I know this is a self join, but I can't remember exactly how it goes.
Could someone help me out?
create table A
{
int idA,
varchar(30) dataA
}
create table B
{
int idB,
varchar(30) dataB
}
create table A_B
{
int idA references A(idA),
int idB references B(idB)
}
inse...more >>
SQL Server Monitoring Posted by rsanderson NO[at]SPAM allmerica.com at 9/29/2003 11:19:31 AM I am currently evaluating Quest (Foglight & Spotlight) vs. BMC (Patrol
& DBXray) and I am soliciting feedback from the community on these two
products or any others that I should check out. Any success stories,
shortcomings or anything else that you may be able to contribute to my
Proof of Conce...more >>
SELECT a random row for each different Type Posted by Yannick Turgeon at 9/29/2003 9:43:07 AM Hello all,
I'm using SS 2000
Based on the following table and data:
CREATE TABLE T (
F1 VARCHAR(1),
F2 INT,
F3 INT)
/* T has no unique key */
/* The data */
INSERT INTO T
SELECT 'A' AS F1, 1 AS F2, 10 AS F3
UNION ALL
SELECT 'B', 2, 12
UNION ALL
SELECT 'B', 3, 11
...more >>
multi-thread tasks using a single connection object concurrently Posted by hui_km NO[at]SPAM star-quest.com at 9/29/2003 6:56:45 AM is it possible to use a single connection object shared by several
tasks where each task is handled by a thread? these tasks call stored
procedures that return record sets, no editing, update or delete.
my objective is that db connection is expensive and each user can only
have 1 connection ob...more >>
Order by clause Posted by romeo9225 NO[at]SPAM yahoo.com at 9/29/2003 6:54:40 AM If I use the order by clause to sort on a date, where the date and
time stamp are the exact same for multiple records, how does SQL
output the data?
At random... or does it look at the primary key?...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |