Viewing 15 posts - 1,501 through 1,515 (of 9,399 total)
May 30, 2017 at 5:50 pm
Without any DDL for the table and data, I made this:
IF OBJECT_ID('dbo.Admissions', 'u') IS NOT NULL DROP TABLE dbo.Admissions;
CREATE TABLE dbo.Admissions (
AuthCaseID...
May 30, 2017 at 5:45 pm
May 30, 2017 at 3:01 pm
If the goal is to terminate all processing, why not just exit the procedure?
IF (SELECT COUNT(*) FROM #TmpErrorLog) = 0
BEGIN
RETURN;
END;
May 30, 2017 at 2:53 pm
There was only one that made me stop and think for a minutes. Thanks, Stanley.
May 30, 2017 at 2:46 pm
May 30, 2017 at 2:42 pm
May 30, 2017 at 2:38 pm
May 29, 2017 at 6:49 pm
Do you deliver? If you come all the way here, the pasta and vegetable courses are on me and the beer is on Jeff. 😀😀😀
May 29, 2017 at 2:40 pm
Agreed - the easiest one in a long time. And 94% got it right, which is encouraging.
May 29, 2017 at 12:28 pm
Glad I didn't see the previous version. I found myself really thinking it through because I never use it.
May 29, 2017 at 12:26 pm
Jeff, if you are running this regularly,...
May 29, 2017 at 12:24 pm
Viewing 15 posts - 1,501 through 1,515 (of 9,399 total)