Gluttony

I don't know what's involved in your detailed work patterns, so I don't know if you can replace it. My guess would be that you could, but I can't...

Morel

Risotto 😀

Wheat

I don't see SQL Server going anywhere any time soon.

I worked in Oracle for about 15 years and it's a fine product. Our last purchase was also brutally expensive...

This query will show you what will be deleted:

WITH cte AS (

SELECT UnitNumber,

ROW_NUMBER() OVER(PARTITION BY UnitNumber ORDER BY DischargeDateTime DESC) row_num

...

I haven't either. I'd use TOP myself, but this is another nice tool to have...

Let me first compliment you on not just installing them blindly in production and hoping for the best. You should test them and make sure they work first. ...

Your table and columns didn't match between the DDL and DML, so I made a few adjustments to create the sample data. This is so you can see what...

MS Access is a fine program for small databases, but once you start growing, you'll run into problems quickly. Yes, upgrading to SQL Server gives you an awful lot...

Going off your existing query, I presume you're using saved_datetime to determine which row is the last one. If that's true, then this should get you the most recent...

Pain

Sean Lange (10/2/2014)

Ed Wagner (10/2/2014)

Sean Lange (10/2/2014)

Corduroy...

As promised a couple weeks ago, here's a picture of my friend's smoker. He actually made another one. They're a little over 6 feet tall and handle almost...