I've never imported images using that method so I can't offer much advice.

The only thing I can offer is simply this : instead of guessing at the files in the...

You need a calendar table.

The final query should be select from calendar left join (dataset)

That will make sure you get all the dates available.

Flush the insert command and rerun the loop for a couple rows, maybe 5 or 10. See what is being selected. That should give you the answer.

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