Frederico and I have both suggested solutions. Have you decided that they are not applicable in your case? If so, please explain why.

Can you demonstrate this issue by providing some consumable test data?

Hello and welcome to the forum.

As this is purely a SQL Server forum, you may find that you would get more help by posting in a MySQL forum instead.

No error was attached.

Are you talking about an error displaying a specific report (ie, a data source issue) or a problem accessing the report server URL?

If a table does not have DateCreated, how would 'the system' know which of its rows to select?

Have you tried checking for build warnings in SSDT?

Also, I think that 'SQL Death by a Thousand Cuts' would be a great article in its own right.

Trying to convince application developers that it's worth spending the time to...

My apologies... there's a missing word as follows....

"Each test will have the following nearly sections:" should have been "Each test will have the following nearly identical sections:"

And I left...

I just created a database containing the following:

• schemas tst and tst2
• table tst.Test1
• proc tst.SomeProc, which selects from tst2.Test1

Clearly, tst2.Test1 does not exist and this results (by default) in...

Yuck!

If you can't change that sync stuff, here is one idea.

Create a table called FileNamesProcessed (or whatever) and write the 'current' file name to that at the end of a...

Best practice is to archive unzipped files after processing them. Just move them to an Archive folder. That way, you know that anything in your updates folder has not yet...

--deleted

• This reply was modified 4 years, 2 months ago by Phil Parkin.

OK, you made it sound like this was something which used...

According to the MS documentation, error 3737 is "Could not delete file '%ls'. See the SQL Server error log for more information."

What error message are you seeing?

I will put this rather more forcefully than Steve Collins.

If the following code gives you a varchar/numeric conversion error, there is no doubt at all that the datatypes of the...

• This reply was modified 4 years, 2 months ago by Phil Parkin.