when you delete a file, regardless of the recycle bin, the file is still there, but the disk space it used is open for use by other programs...if you hurry...

this was a neat question; you could schedule the procedure I made belowto run every thirty minutes, and query the table WHORESULTS on demand:

[font="Courier New"]CREATE PROCEDURE PR_CAPTURESP_WHO

AS

BEGIN

  SET NOCOUNT ON

  IF NOT...

maybe a comma in the exisitng data is affecting the real data you are looking at...

Can you search the file for a pre-existing commas before you replace the tabs with...

well your example shows up just fine for me...

renamed the file to "Artists_mini.csv" ,as only one period is allowed to exist for a text server to see it:

selected...

thomas.lemesurier (8/28/2008)

---

Hmmm, sorry that this is dragging on everyone, now that I have the files in the right place (;)) the tables are being picked up. However, when I open...

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 table...

so...

not enough information I think...Can you post the full CREATE FUNCTION statement you are using?

I'm guessing from what you posted the "parameter" you are trying to pass is a tablename...

the...

Rbarryyoung is exactly right...typically, the account used for running the SQL server service never logs into the domain, and so does not have permissions/cannot browse to a different machine on...

maybe you need to filter so you get JUST the parent records?

slight change by adding a WEHRE clause, and changing which Oid to select like this?:

[font="Courier New"]

SELECT

  o.Oid,

  x.employeeID,

  o.changedate,

  e.followupdate,

  o.date

FROM...

it's just your INNER JOIN at the very end that is exluding the records you were looking for; simply change to this i think:

[font="Courier New"]

SELECT

  x.Oid,

  x.employeeID,

  o.changedate,

  e.followupdate,

  o.date

FROM

  (SELECT

    ...

aww too bad your on 2000; I found Jack's suggestion really interesting and slapped this together real quick and it gave me promising results:

[font="Courier New"]

SELECT

DB_NAME(database_id) AS dbname,

OBJECT_NAME(OBJECT_ID,database_id) AS tablename,

SUM(user_seeks) AS...

yeah, looking at it again, i might suggest assuming just 5 characters:

JOIN ON LEFT(tbl1.ZIPCODE,5) = LEFT(tbl2.ZIPCODE,5)

that way you ignore bad data, as well as 9 digit zipcodes.

I'm...

ctics112 (8/20/2008)

---

Greetings,

I am trying to join two tables AgentAddresses and ZipCodes on a field called zipcode in to create another table named Agents however several thousand fields in Agent Addresses...

well, avoiding SSIS, this seems to work; in order to gett his to work, i had to enable xp_cmdshell, and change the credentials for the account that sql server runs...