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 3 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 3 years, 2 months ago by Phil Parkin.

If you remove the existing data from the Excel file, does the new data get written to the file?

What happens when you run this? Does the existing data in Excel get overwritten, or does the Excel file remain unchanged?

Good tip....

Are you sure you want duplicate rows repeated?

A combination of GROUP BY and COUNT will get you the results you need.

Do all of your existing FULLNAME values conform in format exactly to the two examples you have provided? I ask because names are usually much more complicated to fix than...