Problem Statement Getting data loaded into your SQL Server tables can come in a variety of methods. There

__CONFIG_colors_palette__{"active_palette":0,"config":{"colors":{"d4288":{"name":"Main Accent","parent":-1},"f2d45":{"name":"Accent Transparent","parent":"d4288","lock":{"lightness":0,"saturation":0}}},"gradients":[]},"palettes":[{"name":"Default Palette","value":{"colors":{"d4288":{"val":"var(--tcb-skin-color-29)"},"f2d45":{"val":"rgba(240, 218, 92, 0.8)","hsl_parent_dependency":{"h":51,"l":0.65,"s":0.83}}},"gradients":[]},"original":{"colors":{"d4288":{"val":"rgb(19, 114, 211)","hsl":{"h":210,"s":0.83,"l":0.45,"a":1}},"f2d45":{"val":"rgba(19, 114, 211, 0.8)","hsl_parent_dependency":{"h":210,"s":0.83,"l":0.45,"a":0.8}}},"gradients":[]}}]}__CONFIG_colors_palette__
Read More

Problem You want to round up to the nearest integer. Background Suppose you have a list of final

__CONFIG_colors_palette__{"active_palette":0,"config":{"colors":{"d4288":{"name":"Main Accent","parent":-1},"f2d45":{"name":"Accent Transparent","parent":"d4288","lock":{"lightness":0,"saturation":0}}},"gradients":[]},"palettes":[{"name":"Default Palette","value":{"colors":{"d4288":{"val":"var(--tcb-skin-color-29)"},"f2d45":{"val":"rgba(240, 218, 92, 0.8)","hsl_parent_dependency":{"h":51,"l":0.65,"s":0.83}}},"gradients":[]},"original":{"colors":{"d4288":{"val":"rgb(19, 114, 211)","hsl":{"h":210,"s":0.83,"l":0.45,"a":1}},"f2d45":{"val":"rgba(19, 114, 211, 0.8)","hsl_parent_dependency":{"h":210,"s":0.83,"l":0.45,"a":0.8}}},"gradients":[]}}]}__CONFIG_colors_palette__
Read More

Recently a student asked me how he could calculate a Moving Median.  It’s not as easy as you

__CONFIG_colors_palette__{"active_palette":0,"config":{"colors":{"d4288":{"name":"Main Accent","parent":-1},"f2d45":{"name":"Accent Transparent","parent":"d4288","lock":{"lightness":0,"saturation":0}}},"gradients":[]},"palettes":[{"name":"Default Palette","value":{"colors":{"d4288":{"val":"var(--tcb-skin-color-29)"},"f2d45":{"val":"rgba(240, 218, 92, 0.8)","hsl_parent_dependency":{"h":51,"l":0.65,"s":0.83}}},"gradients":[]},"original":{"colors":{"d4288":{"val":"rgb(19, 114, 211)","hsl":{"h":210,"s":0.83,"l":0.45,"a":1}},"f2d45":{"val":"rgba(19, 114, 211, 0.8)","hsl_parent_dependency":{"h":210,"s":0.83,"l":0.45,"a":0.8}}},"gradients":[]}}]}__CONFIG_colors_palette__
Read More

Problem You need use SQL to calculate the Median of a result from SQL Server. Background Suppose you

__CONFIG_colors_palette__{"active_palette":0,"config":{"colors":{"d4288":{"name":"Main Accent","parent":-1},"f2d45":{"name":"Accent Transparent","parent":"d4288","lock":{"lightness":0,"saturation":0}}},"gradients":[]},"palettes":[{"name":"Default Palette","value":{"colors":{"d4288":{"val":"var(--tcb-skin-color-29)"},"f2d45":{"val":"rgba(240, 218, 92, 0.8)","hsl_parent_dependency":{"h":51,"l":0.65,"s":0.83}}},"gradients":[]},"original":{"colors":{"d4288":{"val":"rgb(19, 114, 211)","hsl":{"h":210,"s":0.83,"l":0.45,"a":1}},"f2d45":{"val":"rgba(19, 114, 211, 0.8)","hsl_parent_dependency":{"h":210,"s":0.83,"l":0.45,"a":0.8}}},"gradients":[]}}]}__CONFIG_colors_palette__
Read More