Re: SQL Statement dumping data

2002-03-08 Thread Clint Tredway
Do you mean delete all the data or Export the data? Clint - Original Message - From: Jason Larson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 08, 2002 10:22 AM Subject: OT: SQL Statement dumping data I was wondering if anybody had the sql statement that will

Re: SQL Statement dumping data

2002-03-08 Thread Stephen Moretti
err... DELETE FROM tablename Is that what you mean? - Original Message - From: Jason Larson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 08, 2002 4:22 PM Subject: OT: SQL Statement dumping data I was wondering if anybody had the sql statement that will allow

RE: SQL Statement dumping data

2002-03-08 Thread Jason Larson
- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 9:26 AM To: CF-Talk Subject: Re: SQL Statement dumping data Do you mean delete all the data or Export the data? Clint - Original Message - From: Jason Larson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent

RE: SQL Statement dumping data

2002-03-08 Thread Christopher Olive
you an do a DTS to a text file, if that's what you're after. alternately, check www.swynk.com. they have a FANTASTIC script library for SQL server. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original

Re: SQL Statement dumping data

2002-03-08 Thread Paul Giesenhagen
If dump means delete delete from tablename Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder - Original Message - From: Jason Larson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 08, 2002 10:22 AM Subject: OT: SQL

RE: SQL Statement dumping data

2002-03-08 Thread kbutterly
if you mean delete all the data, use the Purge command. It is very fast. Kathryn Butterly Web Developer Washington Mutual Finance 813 632-4490 [EMAIL PROTECTED] -Original Message- From: Jason Larson [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 11:23 AM To: CF-Talk Subject:

RE: SQL Statement dumping data

2002-03-08 Thread Christopher Olive
[mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 11:31 AM To: CF-Talk Subject: RE: SQL Statement dumping data What I am trying to accomplish is: I have a client that will be pushing up a csv file to a site and then I will setup a autmoated task that will dump all the data in a table

RE: SQL Statement dumping data

2002-03-08 Thread Chris Terrebonne
TRUNCATE TABLE MyTable Chris -- Original Message From: Jason Larson[EMAIL PROTECTED] Subject: RE: SQL Statement dumping data Date: Fri, 8 Mar 2002 09:30:54 -0700 What I am trying to accomplish is: I have a client that will be pushing up a csv file

RE: SQL Statement dumping data

2002-03-08 Thread Jason Larson
-Original Message- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 9:50 AM To: CF-Talk Subject: RE: SQL Statement dumping data set up a DTS package to import the CSV file. create an SP to run the DTS package. use SQL Agent to schedule the SP. christopher olive cto

RE: SQL Statement dumping data

2002-03-08 Thread Shawn Grover
site, then you are placing unnecessary load on your servers. My thoughts, not yours Shawn Grover -Original Message- From: Jason Larson [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 10:01 AM To: CF-Talk Subject: RE: SQL Statement dumping data WOW!!, I haven't worked with DTS

RE: SQL Statement dumping data

2002-03-08 Thread Mark A. Kruger - CFG
manually for even further control. Mark -Original Message- From: Jason Larson [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 9:01 AM To: CF-Talk Subject: RE: SQL Statement dumping data WOW!!, I haven't worked with DTS packages and not much with stored procedures. I will do some

RE: SQL Statement dumping data

2002-03-08 Thread Mark A. Kruger - CFG
PS - Chris, do you have an example of an SP that executes a DTS package? I would find that useful if you do. Mark -Original Message- From: Jason Larson [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 9:01 AM To: CF-Talk Subject: RE: SQL Statement dumping data WOW!!, I haven't

Re: SQL Statement dumping data

2002-03-08 Thread Stephen Moretti
WOW!!, I haven't worked with DTS packages and not much with stored procedures. I will do some research. You think that this is a better solution then building a cf template and setup an automated task to run the cf template (in order to process the csv file)? Yes that will be much better.

RE: SQL Statement dumping data

2002-03-08 Thread Christopher Olive
- From: Jason Larson [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 12:01 PM To: CF-Talk Subject: RE: SQL Statement dumping data WOW!!, I haven't worked with DTS packages and not much with stored procedures. I will do some research. You think that this is a better solution then building

RE: SQL Statement dumping data

2002-03-08 Thread Christopher Olive
. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 2:24 PM To: CF-Talk Subject: RE: SQL Statement dumping data PS - Chris, do you have an example of an SP that executes a DTS package? I would find