This week I write about a situation I encountered at work. Duplicate records needed to be removed and this is what we did. … More Delightfully Delving into Deleting Duplicates via CTE
I proved you can perform updates using CTEs. This week I show you how to perform inserts using a CTE. … More Insert This, Insert That: Inserting with CTEs
Did you know that you can actually update records using a CTE? If you said “no, really?” then read on! It’s pretty nifty, in my opinion. … More Yes! You Can Update with CTEs!
Ever wonder what the heck a CTE is? Haven’t even heard of it? Then read on and hopefully you’ll learn something new! 🙂 … More Demystifying CTEs