I see you check if the USERID exists, but I don't see where you're limiting the results to that USERID in your query string, it just says WHERE 1=1, which,...

"SQL Expert" can compare their credentials with Gail, I can already guess how that's going to pan out.
https://sqlinthewild.co.za/index.php/2009/08/17/exists-vs-in/

Scroogled is not just a good read...

You'd be better off setting a requirement that every meeting have an agenda, minutes and required vs optional attendees, where if not all required attendees are present (or their proxy,...

"I sometimes think I could do truly amazing stuff if I tried to do less stuff." ~ Grant Fritchey

New favorite quote. For Hugo/Grant, thank you for the 3rd...

There is a whole section in the Forums for that, https://www.sqlservercentral.com/Forums/Database-Design, which would be a good place to start, or go to the library and look up a...

True, but those are on my list of default tests I didn't include here, checking for existence, graceful failure on invalid data parameters, resultset within bounds of expected baseline, etc....

Right, but if I'm trying to code minimally in order to pass tests, even with test data, do you for instance just start with a shell for your SP that...

I did this recently when I needed to fix a naming convention, maybe something like this would work for v+1(very simplistic):

1. copy records in oldTable into newTable (with correct naming convention),...