Click here to Skip to main content
15,887,135 members

The Weird and The Wonderful

   

The Weird and The Wonderful forum is a place to post Coding Horrors, Worst Practices, and the occasional flash of brilliance.

We all come across code that simply boggles the mind. Lazy kludges, embarrassing mistakes, horrid workarounds and developers just not quite getting it. And then somedays we come across - or write - the truly sublime.

Post your Best, your worst, and your most interesting. But please - no programming questions . This forum is purely for amusement and discussions on code snippets. All actual programming questions will be removed.

 
GeneralRe: Freestanding Color Picker Programs Pin
Herman<T>.Instance28-Jun-18 23:36
Herman<T>.Instance28-Jun-18 23:36 
PraiseUsing the JavaScript Console Methods To Be a More Effective Debugger PinPopular
David A. Gray14-Jun-18 7:33
David A. Gray14-Jun-18 7:33 
GeneralRe: Using the JavaScript Console Methods To Be a More Effective Debugger Pin
Marc Clifton14-Jun-18 8:42
mvaMarc Clifton14-Jun-18 8:42 
GeneralRe: Using the JavaScript Console Methods To Be a More Effective Debugger Pin
sibling12315-Jun-18 0:29
sibling12315-Jun-18 0:29 
GeneralRe: Using the JavaScript Console Methods To Be a More Effective Debugger Pin
David A. Gray15-Jun-18 5:52
David A. Gray15-Jun-18 5:52 
GeneralRe: Using the JavaScript Console Methods To Be a More Effective Debugger Pin
GuyThiebaut18-Jun-18 3:13
professionalGuyThiebaut18-Jun-18 3:13 
GeneralRe: Using the JavaScript Console Methods To Be a More Effective Debugger Pin
David A. Gray21-Jun-18 7:09
David A. Gray21-Jun-18 7:09 
GeneralSemi-major Win For Me Today Pin
#realJSOP14-Jun-18 4:38
mve#realJSOP14-Jun-18 4:38 
So we have this SSRS report that is supported via several SQL jobs that do exactly the same thing for a specific set of facilities, each with their own ID. Each job is comprised of about a dozen steps representing a mic of SSIS packages and plain old sql. As you might guess, each job has its own facility id hard-wired into each of its steps. On Friday, I was tasked with adding support for an additional facility ID (and adding support for a new column in the source data).

Today, I generalized all of it by creating stored procs that accept the facility ID as a parameter (to replace the sql steps), and a single ssis import package that accepts the facility id on the command line.

The result is a single job that performs work for all desired facility id's (five steps per facility ID), and it only takes about five minutes to add support for additional facility IDs instead of the better part of two hours to create and test a whole new set of packages and associated SQL agent. The real silver lining is significantly eliminating the possibility of copy/paste errors when creating the steps.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

GeneralRe: Semi-major Win For Me Today Pin
MarkTJohnson14-Jun-18 4:57
professionalMarkTJohnson14-Jun-18 4:57 
GeneralRe: Semi-major Win For Me Today Pin
RickZeeland14-Jun-18 7:03
mveRickZeeland14-Jun-18 7:03 
PraiseRe: Semi-major Win For Me Today Pin
Slacker00714-Jun-18 7:23
professionalSlacker00714-Jun-18 7:23 
GeneralRe: Semi-major Win For Me Today Pin
Rick York14-Jun-18 8:05
mveRick York14-Jun-18 8:05 
GeneralRe: Semi-major Win For Me Today Pin
Marc Clifton14-Jun-18 8:40
mvaMarc Clifton14-Jun-18 8:40 
GeneralRe: Semi-major Win For Me Today Pin
David A. Gray25-Jun-18 10:45
David A. Gray25-Jun-18 10:45 
GeneralRe: Semi-major Win For Me Today Pin
Gerry Schmitz15-Jun-18 10:37
mveGerry Schmitz15-Jun-18 10:37 
GeneralRe: Semi-major Win For Me Today Pin
Dr.Walt Fair, PE6-Oct-18 11:39
professionalDr.Walt Fair, PE6-Oct-18 11:39 
PraiseC# Compiler Support for ReadOnlyReferences Pin
David A. Gray13-Jun-18 8:11
David A. Gray13-Jun-18 8:11 
GeneralRe: C# Compiler Support for ReadOnlyReferences Pin
Richard Deeming13-Jun-18 8:19
mveRichard Deeming13-Jun-18 8:19 
GeneralRe: C# Compiler Support for ReadOnlyReferences Pin
David A. Gray13-Jun-18 8:43
David A. Gray13-Jun-18 8:43 
GeneralRe: C# Compiler Support for ReadOnlyReferences Pin
Richard Deeming13-Jun-18 9:17
mveRichard Deeming13-Jun-18 9:17 
GeneralRe: C# Compiler Support for ReadOnlyReferences Pin
David A. Gray13-Jun-18 12:17
David A. Gray13-Jun-18 12:17 
RantRe: C# Compiler Support for ReadOnlyReferences Pin
megaadam13-Jun-18 22:49
professionalmegaadam13-Jun-18 22:49 
GeneralRe: C# Compiler Support for ReadOnlyReferences Pin
David A. Gray14-Jun-18 8:09
David A. Gray14-Jun-18 8:09 
GeneralRe: C# Compiler Support for ReadOnlyReferences Pin
Clifford Nelson14-Jun-18 9:13
Clifford Nelson14-Jun-18 9:13 
GeneralRe: C# Compiler Support for ReadOnlyReferences Pin
David A. Gray14-Jun-18 13:00
David A. Gray14-Jun-18 13:00 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.