lundeen-bryan

@rem Do not use "echo off" to not affect any child calls.
@setlocal

@rem Get the abolute path to the parent directory, which is assumed to be the
@rem Git installation root.
@for /F "delims=" %%I in ("%~dp0..") do @set git_install_root=%%~fI
@set PATH=%git_install_root%\bin;%git_install_root%\mingw\bin;%PATH%

@if not exist "%HOME%" @set HOME=%HOMEDRIVE%%HOMEPATH%
@if not exist "%HOME%" @set HOME=%USERPROFILE%

lundeen-bryan

Environment Variables	Values (may vary)
%ALLUSERSPROFILE%	C:\ProgramData
%APPDATA%	C:\Users(user-name)\AppData\Roaming
%CD%	(command prompt only) Current directory full path
%CMDCMDLINE%	(comma

lundeen-bryan

Attribute VB_Name = "mod_TableInWord"
''===========================================================================================
'' Procedure: ......... TableInWord.bas/SizeTable
'' Description: ....... Create table if none, size all tables based on user input
'' Module URL: ........ https://gist.github.com/lundeen-bryan/3bcd197d287e1cc08957dd0c52337d50
'' Version: ........... 1.0.0 - major.minor.patch
'' Created: ........... 2022-02-20
'' Updated: ........... 2022-02-20
'' Compatibility: ..... Word
'' Install: ........... Save this as ".bas" file or copy and paste text to a module in vba IDE

lundeen-bryan

Attribute VB_Name = "fnc_ReturnMyDocsPath"
' namespace=vba-files/Modules
' filename=fnc_ReturnMyDocsPath.bas

Option Explicit

Const sep As String = "\"

Public Function ReturnMyDocsPath_fnc() As String

lundeen-bryan

Key	CMD	HINT
S	SELECT	SWEATY
F	FROM	FEET
W	WHERE	WILL
G	GROUP BY	GIVE
H	HAVING	HORRIBLE
O	ORDER	ODOR

lundeen-bryan

/*
	Filename: ...: SQL_Pivot_Table_Walkthrough.sql
	Date ........: 05-May-2022
	Time ........: 08:11
	Desc ........: Shows how to make a pivot tbl in SQL
	Notes........:
		1. See MSDN documentation for PIVOT at https://archive.ph/wip/VK8aD
    2. Most code modified from Travis Cuzick's SQL course on Udemy
*/
USE [AdventureWorks2019]

lundeen-bryan

{
	"Tips":{
		"prefix": "b'sqltips",
		"body": [
	    "--Sweaty(SELECT) Feet(FROM) Will(WHERE) Give(GROUP BY) Horrible(HAVING) Oder(ORDER BY)",
			"--SELECT",
			"--FROM",
			"--WHERE",
			"--GROUP BY",
			"--HAVING",

lundeen-bryan

Start with the power query below:

let
    Source = SourceData,
    //the source needs to be a table that is in powerquery
    #"Counted Rows" = Table.RowCount(Source),
    #"Converted to Table" = #table(1, {{#"Counted Rows"}}),
    #"Renamed Columns" = Table.RenameColumns(#"Converted to Table",{{"Column1", "Total_records"}}),
    #"Added Custom" = Table.AddColumn(#"Renamed Columns", "Last_Refresh", each DateTime.LocalNow()),
    #"Added Custom1" = Table.AddColumn(#"Added Custom", "Date", each DateTime.Date([Last_Refresh])),

lundeen-bryan

import os
from os import path, sys

def read_file(file_name):
  file_name = os.path.join(sys.path[0], file_name)
  if path.isfile(file_name):
    with open(file_name, mode="r") as file:
      contents = file.readlines()
      return contents
  else:

lundeen-bryan