dir is an ms - dos commande.

That's where the path goes. Google it for full list of options.

Once you have a list of files to process just go at...

Did the row really insert?

Trigger deleting the row?

transaction not closed?

This would also be a much smarter way to go. List the files that are actually in the folder. And only try to import those :

IF...

DECLARE @counter AS int

DECLARE @folderpath AS varchar(255)

DECLARE @fullpath AS varchar(4000)

DECLARE @sqlstring AS varchar(4000)

SET @folderpath = 'D:\Mijn Documenten\Documents\DWCoureurLocaleData\Irfanview_26012011'

SET @counter = 670

WHILE @counter < 671

BEGIN

SET @fullpath = @folderpath + '\' +...

You're not listening.

Kill the loop for now (or only 1 iteration).

PRINT the code and see what's wrong within 1 iteration.

You're getting 1000s of errors because you are looping 11000+ times.

I've coded on asp .net app in c# once before and I had to use the reportviewer control to make the connection between ssrs and the web.

Maybe that exists in...

The annoying answer is whatever sp will work for your application. So yes that means testing them all.

As for time issues. It'll take just about the same time...

Another golden nugget.

Instead of running the code print it (select with output to text mode rather than grid), then copy paste back into ssms and check syntaxe there and then...

Post both query plans (fast and slow).

Can you also test at which point you start getting the bad plan (3,4,5,6 days??).

If the query is not going to be run very...

He wants you to test out something. Can you just humor him for 1 second instead of wasting...

venoym (4/18/2011)

---

um... why not force the insert script into a known data type? I'm assuming you are using the insert script to create the table #TOTAUX...

Something like:

SELECT ALIMENTER_ID,CAST(SUM(BILAN)...

BTW, in SSMS, you can double-click the error in the output window and it'll bring you in the code in the region of the error. Sometimes right on it.

In...

OPENROWSET( Bulk ''

That needs a 3rd quotation.

GilaMonster (4/18/2011)

---

Ninja's_RGR'us (4/18/2011)

---

GilaMonster (4/16/2011)

---

Yup, that's pretty much what I was thinking about.

Just one comment, if the session_id>50 is supposed to filter out system processes, remove it as it won't necessarily...

parthi-1705 (4/18/2011)

---

It is a very good practice to have column name even though there is a single column ,I just said because TheSQLGuru has stated that it will not work.In...