Hi,

sorted it with the help of a colleague. Makes use of SELECT statement in LEFT JOIN that returns the records that have been downloaded.

Has anyone got anything more concise?

Cheers

/*...

Oopps,

Replace

EXEC @rc = [FDRC_Labour].[dbo].[usp_InsertSurveyAnswers]

with your own DB name for testing.

Hi,

Not sure if the problem was due to the usual panic we sometimes encounter when this site is the last resort, but there were quite a few syntax errors...

All,

thanks very much for all the advice, and supporting me in the trauma of having to use the "c" thing

Serqiy, I did consider...

David,

personally I was thinking of using a temp table, and then iterating through each row to update the row count. Then at the end I could do a single SELECT...

P.S. Forgive the winks in the SQL code...too quick on the mouse clicks

Jeff,

Yes, I did not really give a full explanation. Maybe the best thing is if I attach the actual tables.

In terms of UI I will have:

a) Summary page listing all...

Hi Jeff,

Great article that truly highlights and explains the issues.

In relation to your observation about using Temp table to store interim results, to which you then apply set-based logic, I...

....he he he he. Now that is the ONLY thing I did not check. The schedule was in fact disabled. Thanks for that. Seems like a good question of the day...

Yup, tried the refresh too, but no luck. Still need to go back and check all the various accounts, but not sure how/why that would affect ONLY 1 of the...

That is what I immediately thought to check. But ithe job is both enabled and scheduled, and to double-check I just run it manually and the quirk still persists.

Phil,

I assume in your test you ran sp_attach_single_file_db given that you only had the MDF?

I'll try the test myself.

Mauro

Yes I agree, I suspect that the detach process might have actually caused the problem. Unfortunately the customer did not have a regular backup job running...and so I would suspect...

Hi,

Picking up on the previous conversation, I too am having the same problem. Unfortunately it's with a client database for which we have been sent the MDF, which we assume...

Thanks for the feedback, but I do still have some questions.

Vichka, not sure about what you propose. Are you saying that switching the OPTIONS Recovery Model from Simple to Full...