I'm watching this thread because others more knowledgable than me might throw something out there.

As far as I know, you can capture the print messages from an application, but not...

i can emulate the same error if the payments table has a row with nulls in the REFERENCE column.

other than that, maybe it's a difference in coallation between the two...

two things i see...can reference be null in the payments? also i prefer to use a left join syntax instead..

1a - select * from import_cc_requests where reference not in (select...

yeah i think we need to see the trigger code itself...it might not be designed to handle multiple rows on insert or something basic like that.

show us the code so...

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