It probably still looked better than the crap that GoLive! produces...
matthewr81
@matthewr81
Best posts made by matthewr81
-
RE: Fake ASP WTF
Latest posts made by matthewr81
-
Awesome Try/Catch
Though an empty Catch is clearly not helpful, found this in a core library today that the team who owns the code was complaining that their process fails but they have no idea why.... (and I have no idea why they did it this way)
Catch ex As Exception
Dim s As String = ex.Message
End Try -
RE: Nested Case Statements
Totally agree with the _tbl, to be fair, that was not him, that was the original designer 15 years ago who did not know any better and being replaced (all of the fields have the type as well...)
The format was exactly as I posted it as well... just formatting it better makes it easier to read, but wanted to capture the whole "OMG What is this?" feeling I got when I opened it.
-
Nested Case Statements
Had to share this snippet of SQL eyesore from our "Senior Reporting Analyst"...
CASE WHEN RTRIM(inv_unit_dtl_tbl.Description_vc) = 'Energy-Fixed Price Fixed Volume Off Peak' THEN 'Off Peak Contract Quantity'
ELSE CASE WHEN RTRIM(inv_unit_dtl_tbl.Description_vc) = 'Energy-Fixed Price Fixed Volume On Peak' THEN 'On Peak Contract Quantity'
ELSE CASE WHEN RTRIM(inv_unit_dtl_tbl.Description_vc) = 'Energy-Day Ahead Price On Peak' THEN
CASE WHEN SUM(inv_unit_dtl_tbl.Volume_n) >= 0 THEN 'On Peak Over Usage'
ELSE 'On Peak Under Usage' END
ELSE CASE WHEN RTRIM(inv_unit_dtl_tbl.Description_vc) = 'Energy-Day Ahead Price Off Peak' THEN
CASE WHEN SUM(inv_unit_dtl_tbl.Volume_n) >= 0 THEN 'Off Peak Over Usage'
ELSE 'Off Peak Under Usage' END
ELSE RTRIM(inv_unit_dtl_tbl.Description_vc) END END END END) AS Description_vc
-
Why do I even try?
TESTER A [3:37 PM]:
where would I look for that info? it does not show in the files that I sent to you.ME [3:37 PM]:
in [application name]?TESTER A [3:37 PM]:
If I look at the accounts in both Prod and Test - they are the sameME [3:49 PM]:
yeah if you look at the sheet that was sent, that one did not changeTESTER A [3:57 PM]:
Do you need me to test one that changed? -
RE: Security Taken Literally
The security was already entered for the new application. Our security can dictate that some EXEs have to be run from a certain location. This one can be run from multiple servers so per our standards given to us by the team that handles the security, for folder location we put "N/A". The application was moved to production, but when I went to run it, we get this error. So instead of turning off that security check... the person was not thinking and entered "N/A" for the folder location for this to run from. Get it?
-
Security Taken Literally
I know this was probably a result of a late afternoon of entering forms (though why we enter paper forms for an automated process?)... but still got me a laugh when instead of allowing my program to run from any directory, the security instead insisted:
[GenMEMktProfile.exe] is running in [Prod] from [D:\ESI\GenMEMktProfile\] and MasterApplication says it should run from [N/A] for [Prod].
Resolution: Run your application from [N/A] or Contact the DB Team with the updated directory. -
RE: Our Poor Help Desk
I guess I should add... he sent the last one after receiving a large number of "reports" of the first email within that first 5 minutes.
-
Our Poor Help Desk
Amused me in a sad way, hope you enjoy it as well...
Email #1 (from corporate help desk):
From: _Corporate Communications
Sent: Wednesday, January 28, 2009 10:12 AM
Subject: Warning: Be alert for "Wells Fargo" spam e-mails
Good morning:
An e-mail is being received in parts of the company with the Subject line: New Online Security Measures. It contains a link to what looks like a Wells Fargo site. This is spam. Do not open the e-mail or click the link. Delete the e-mail from your Active and Deleted e-mail folders.
If you have already clicked on the link, do not provide any information that's requested. If you have already provided information, you should contact your bank to let them know what has happened.
There do not seem to be any viruses associated with this spam, but we are looking into that and will provide more information if necessary. If you have any concerns, please contact the appropriate ITS Help Desk.
Thank you.Email #2 (from our own Help Desk, not Corporate)
If you have received an email like this, please forward the email to TEGE Help Desk (IT). IBS is working to resolve this problem and needs to be aware of the extent of the issue so that they may take approrpiate corrective action. Thank you.
John Doe
Help Desk SpecialistEmail #3 (from our own Help Desk again, 5 minutes later)
A point of clarification:
We want to know if you received a "Wells Fargo" email, not the one from _Corporate Communications. I apologize if I did not communicate this clearly. -
RE: 9 levels of nested subqueries
wow, looks like some stuff we see out of our reporting service interns.
-
RE: I guess that is more secure?
@vt_mruhlin said:
Yeah, that email clearly has your address in the "from" header. It couldn't have possibly been from somebody else. SMTP is so very secure.
Yeah, you can forge caller ID almost as easily, but maybe he needed to ask you questions whose answers you'd rather not have stored in a mail server somewhere?
Good call, I did not think about that. I just decided to walk around the wall and introduce myself (he really did not know who I was...)