I used to leave my name, personal cell # and an apology at the top of any of my dynamic SQL queries. I know what its going to be like, man, I wrote that shit. I’m so sorry.
(Public sector, if this stuff goes down people don’t get their heart meds so I don’t overly mind the stale followup calls. Tho I’ll be shocked if any of that code is still in use, most of it was being obsoleted even back when I still worked there)
I wish I was working on your stuff back when I supported stinky 2008 T-SQL where everything was dynamic and sequential. I would have called you just for moral support
Just to be clear, I think T-SQL is fine and apparently they added some string agg function so you don’t have to hack XML_agg so… Something improved. But stinky spaghetti SQL is unfixable
dynamic SQL. I remember those days. I once got criticized by colleagues for “breaking” a dynamic SQL search query - you know the one - because I realized that it wasn’t building most of the query. I have no idea how it worked, but I made it put out actually valid SQL and it took forever. I forget if we rolled that back. We were using MS TFS, so probably not haha
I used to leave my name, personal cell # and an apology at the top of any of my dynamic SQL queries. I know what its going to be like, man, I wrote that shit. I’m so sorry.
Bold move… Hopefully you’re not getting calls in 10 years when stuff breaks and you’re at a different company
(Public sector, if this stuff goes down people don’t get their heart meds so I don’t overly mind the stale followup calls. Tho I’ll be shocked if any of that code is still in use, most of it was being obsoleted even back when I still worked there)
Plus then you can bill as an independent contractor.
I wish I was working on your stuff back when I supported stinky 2008 T-SQL where everything was dynamic and sequential. I would have called you just for moral support
Comon over to Tsql 2022! Nothing has changed, except the AI is writing the dynamic SQL now so you don’t have to! It’s going great!
Just to be clear, I think T-SQL is fine and apparently they added some string agg function so you don’t have to hack XML_agg so… Something improved. But stinky spaghetti SQL is unfixable
dynamic SQL. I remember those days. I once got criticized by colleagues for “breaking” a dynamic SQL search query - you know the one - because I realized that it wasn’t building most of the query. I have no idea how it worked, but I made it put out actually valid SQL and it took forever. I forget if we rolled that back. We were using MS TFS, so probably not haha