Lowell (8/27/2008)

---

here's my suggestion:

add a folder which contains all of your .csv files as a linked server.

a text linked server will show evert .txt file and every.csv file as a...

Sergiy (8/27/2008)

---

Why don't you make this query a view and call that view via "Import data -> database query" in Excel?

It will allow users to refresh data instantly with single...

nimmi.smith (8/27/2008)

---

Excuse my stupidity.

I see that in my last post the data file had a comma missing between a field.

Here is my file:

"RECORD_ID","SOURCE_ID","MEDIA","CREATED_BY","DATE_ORD","AMT","F_NAME","ORD_TIME"

"MLMORD20140571","7499582HG","GVAUTO","NANCY",20080616,100.00,"WALLY","02:21:08 PM"

"MLMORD20141711","7504735LS18","GVAUTO","BILL",20080616,100.00,"ROB","11:17:13 PM"

Here is my format...

Heh... sorry Tomm... bet you've had "mo-den" enough of that 😛

Simon,

Now that Gus has replied, it's very good forum etiquette/good practice to let him know if it worked or not. If it didn't work, explain why with some good...

Good... Here's one more suggestion... don't edit your posts on something...

colin Robinson (4/20/2008)

---

i would also probably drop the table rather than truncate in this instance. You would then get the same Identity value for each date each time you ran...

Thanks for the feedback... Correct... no need to...

Tomm Carr (8/27/2008)

---

Actually, the code was "60 * 60" not "3600", meaning 60 minutes per hour times...

Heh... no... trust me... I just got done reducing/archiving a 131 million row table to a 44 million row table using the 20k method I spoke of... on a 24/7...

Heh... You...

rbarryyoung (8/26/2008)

---

Jeff, dude:

Jeff Moden (8/26/2008)

---

SELECT ROW_NUMBER() OVER (PARTITION BY ShiftID, TableID, StationID, EmployeeID, DATEADD(dd,DATEDIFF(dd,0,CounterDateTimeStamp),0)

...

Update:

What a huge PITA SQL Server 2000's TEXT data type is...

You can create a sproc with a TEXT datatype variable as one of the parameters. Trouble is, you can't...

Ummmm... nicely done, but be careful. If you take a look at the actual execution plan, there are two flow arrows of great concern......

Hi Simon,

You'd probably get a faster, better response if you put your data in a ready to use/test format. Take a look at the link in my signature line...