Recently I came across a stored procedure I had written a few years ago, when I first started as a …