that's actually a good question.

It kind of depends on your data...

I'm still playing with Jeff Moden's awesome example, but with the openrowset function, I think you need to know the...

here's just a couple of things that I see wrong with your on-the-fly code:

1. SET "@TblName = (your code) would return null if a full part tablename wasn't passed...

make sure your data fields are NVARCHAR, not plain old varchar.

after that, make sure when you are inserting the data that you specifically cast them as nvarchar...selecting a varchar into...

it looks like you are just trying to make a single procedure return a variety of different values...sort of a do-all proc.

I would suggest getting rid of the case...

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