INF: How to Remove Duplicate Rows From a Table
SELECT col1, col2, count(*)
FROM t1
GROUP BY col1, col2
HAVING count(*) > 1
SELECT col1, col2, col3=count(*)
INTO holdkey
FROM t1
GROUP BY col1, col2
HAVING count(*) > 1
DELETE t1
FROM t1, holdkey
WHERE t1.col1 = holdkey.col1
AND t1.col2 = holdkey.col2
INSERT t1 SELECT * FROM holdkey
After today’s release of the
I’m now a Gunnery Sergeant and unlocked the DAO-12, G36C, PKM, and L85A1. This leaves me with only the M95 sniper rifle and the Mk3A1 shotgun left to unlock. I’m so happy that finally I don’t have to hunt down those stupid points so much anymore.
This is now the 3rd or 4th flat tire I’ve had on my new car in the past year. It’s really starting to piss me off. I refuse to believe that I just have crappy tires. It must be the fact that my car spends 90% of its time parked on crappy-ass gravel parking lots with lots of debry such as nails, metal pieces, and god knows what else, all intend on poking my tires. I’m sick of it! I’m going to put my name in for the next available underground parking spot at work. And there goes another $20 getting the tire fixed (if they can).
This is now the 3rd or 4th flat tire I’ve had on my new
I went out golfing today for the first time all year. It was a department thing from work. And while I almost got called back in to work to fix a problem, I did have a great round. I shot a 78 (+15) over the 18 holes at Michaelbrook Ranch Golf Club. It was a ton of fun and it’s really too bad that I don’t have time or money to do it more often. Well, maybe next year…
