Skip to content

Instantly share code, notes, and snippets.

SELECT
Sum(l.cslbr_temp + l.cslbr_wkr) AS TTL,
Sum(l.cslbr_temp) AS Temp,
Sum(l.cslbr_wkr) AS Worker,
l.subprocess_id
FROM
vw_cslabor l,
vm_subprocess s
WHERE
s.SUBPROCESS_ID(+) = l.SUBPROCESS_ID
@nexocentric
nexocentric / hiawatha.conf
Created June 6, 2017 03:40
Default /etc/hiawatha/hiawatha.conf on Ubuntu
# From http://secure-ubuntu-server.blogspot.co.id/2015/05/howto-highest-secured-hiawatha-web.html and default conf
# Hiawatha main configuration file
# VARIABLES
# With 'set', you can declare a variable. Make sure the name of the
# variable doesn't conflict with any of the configuration options. The
# variables are case-sensitive and cannot be redeclared.
#
#set LOCALHOST = 127.0.0.0/8
$REGKEY="HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\WindowsUpdate"
$REGITEM = "DoNotConnectToWindowsUpdateInternetLocations"
function Set-RegistryItem {
param (
# Registry key to set
[Parameter(Mandatory=$true)]
[string]
$RegistryKey,
[PSCredential]::new(0, $SecurePassword).GetNetworkCredential().Password
code () { VSCODE_CWD="$PWD" open -n -b "com.microsoft.VSCode" --args $* ;}
https://www.youtube.com/playlist?list=PLVlY3_YU-89UlS0P9brotK8ZJ9gJywL7b
https://www.youtube.com/playlist?list=PLVlY3_YU-89XHn1YAqEBwj_Vy2zaN05Ss
https://www.youtube.com/playlist?list=PLVlY3_YU-89XtETidwxeOzjDkKsTWO7oE
https://www.youtube.com/playlist?list=PLVlY3_YU-89VUA53n-c6FhXqC9wBZOOrZ
https://www.youtube.com/playlist?list=WL
https://www.youtube.com/playlist?list=LL
https://www.youtube.com/playlist?list=PLVlY3_YU-89XHn1YAqEBwj_Vy2zaN05Ss
https://www.youtube.com/playlist?list=PLVlY3_YU-89XtETidwxeOzjDkKsTWO7oE
https://www.youtube.com/playlist?list=PLVlY3_YU-89VUA53n-c6FhXqC9wBZOOrZ
https://www.youtube.com/playlist?list=PLVlY3_YU-89WqOMhHeT3USWcqTJa09WgO
@nexocentric
nexocentric / youtube-knowledge-archive
Last active June 26, 2024 04:04
archiving-for-youtube
https://www.youtube.com/playlist?list=PLVlY3_YU-89VfjYH74RmrQDal7wMzZ7Yy
https://www.youtube.com/playlist?list=PLVlY3_YU-89XtETidwxeOzjDkKsTWO7oE
https://www.youtube.com/playlist?list=PLVlY3_YU-89UlS0P9brotK8ZJ9gJywL7b
https://www.youtube.com/playlist?list=PLVlY3_YU-89VUA53n-c6FhXqC9wBZOOrZ
https://www.youtube.com/playlist?list=PLVlY3_YU-89ViJTxCyEFfqsaf6_0DlxDa
https://www.youtube.com/playlist?list=PLVlY3_YU-89XLmDehHsBFWov9bcg0ZnhE
https://www.youtube.com/playlist?list=PLVlY3_YU-89XzzyZ0XcCMtNa_8EgM0JXG
https://www.youtube.com/playlist?list=PLVlY3_YU-89UXETF0IOn2SNitT5Rb40zt
https://www.youtube.com/playlist?list=PLVlY3_YU-89Vng_SVpXLUv_S978y2pXtf
https://www.youtube.com/playlist?list=PLVlY3_YU-89VIpZRqUIpgIZombFBKFQQj