Viewing 15 posts - 301 through 315 (of 607 total)
October 24, 2018 at 10:24 am
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,...
October 24, 2018 at 9:16 am
"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/
October 24, 2018 at 6:39 am
October 19, 2018 at 7:17 am
October 11, 2018 at 8:22 am
Scroogled is not just a good read...
October 9, 2018 at 12:37 pm
The corollary could be - are there any actual...
September 24, 2018 at 6:51 am
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,...
September 24, 2018 at 6:47 am
"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...
September 21, 2018 at 12:32 pm
September 21, 2018 at 12:24 pm
September 21, 2018 at 12:18 pm
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...
September 21, 2018 at 9:37 am
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....
September 20, 2018 at 6:40 pm
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...
September 20, 2018 at 1:33 pm
I did this recently when I needed to fix a naming convention, maybe something like this would work for v+1(very simplistic):
September 20, 2018 at 10:56 am
Viewing 15 posts - 301 through 315 (of 607 total)