- Feature Articles
- CodeSOD
- Error'd
-
Forums
-
Other Articles
- Random Article
- Alex's Soapbox
- Announcements
- Best of…
- Best of Email
- Best of the Sidebar
- Bring Your Own Code
- Coded Smorgasbord
- Mandatory Fun Day
- Off Topic
- Representative Line
- News Roundup
- Editor's Soapbox
- Software on the Rocks
- Souvenir Potpourri
- Sponsor Post
- Tales from the Interview
- The Daily WTF: Live
- Virtudyne
Admin
Bah, this is simply a case of formatting. Here, let me fix that for you.
AND CASE WHEN @c_usergroup = 50 AND NOT EXISTS( SELECT 1 FROM l_appl_client lac WHERE lac.f_application = fa.f_application AND lac.c_linktype = 840 AND lac.stat = 0 AND CASE WHEN ISNULL(lac.f_client,0) <> @f_client_user AND ISNULL(lac.f_c_f_client,0) <> @f_client_user THEN 0 ELSE 1 END = 1 ) THEN 0 ELSE 1 END = 1 -- 07.09.2022
See? Now it's clear as day. (/jk, I still have no idea what's going on)
Edit Admin
It could be worse... Imagine a prefix "ch_" and a column for, well, for changes.
(Sorry)
Addendum 2026-03-05 09:22: I'd also like to offer my apologies to David Bowie if he's watching us from "up there"...
Admin
I always check closely at the code snippets to see if someone inherited code from somewhere I used to work. I don't have to worry about Python, PHP, or C/C++ but TSQL like this makes me nervous until I verify it's not something that can be traced back to me.
Admin
"Qaudruple"?