Can confirm with Jeff, sorry if I sounded a bit salty up there 🙂

How often does this data need to be replicated? Why do you feel the need to drop the development database to refresh the data?  Are there permission differences between the...

I call it a pound sign or a sharp sign.   The original name for it was a pound sign.. the origins of the "octothorp" which, btw, isn't even recognized by...

Never in my life have I heard somebody call a pound sign an octothorp .. spell check doesn't even recognize it as a word.

Interesting, returns some Null for me where there shouldnt be, but It makes sense..  I would point out that would necessarily give you the MAX it just gives you what...

My query should work for you then, hopefully somebody will come by with a smarter/more efficient query though.. I'd be interested in seeing the right way to do it.

If you do need the max value instead of the last value.. here is a very ugly query that somebody should probably yell at me for writing, its just the...

From my understanding, that is correct, SQL will use all the memory you allow it to use, if you want to know if you're allocating the proper amount there are...

Makes sense, I messed with that for a second but I was being dumb about it.

I'm learning myself but from my understanding, in doing this you're giving every iteration of that error message an assigned row number 1...2...3...4. depending on how many times it appears,...

This might not be 100% correct, but this seems to work for me but as a note, basically whats going to happen here is if the error occurred on multiple...

Just to clarify, when you say distinct errors are you wanting each individual error type to only show up once?  With the way this is written if you have the...

So you want to show only orders where all items of the order have the status of shipped?

This might not be the "correct" way which may have been mentioned above...

If you already have a strong knowledge of SQL you can skip the MTA, I took it a couple years back and its  very much for beginners.   If you want...

Just as a side note, you can sometimes check if somebody or something else has the file open by going to Computer Management-> Shared Folder-> Open Files.