Skip to content

Instantly share code, notes, and snippets.

DECLARE @TABLE_NAME varchar(255), @TABLE_SCHEMA varchar(255), @sql varchar(max) = ''
, @insert_sql varchar(max) = '', @select_sql varchar(max) = ''
, @with_sql varchar(max) = '', @TableNameLast varchar(16);
DECLARE tables CURSOR FOR
select TABLE_NAME, TABLE_SCHEMA
from information_schema.tables
where TABLE_NAME like '%[TABLE_FILTER]%'
declare @TBL as Table(
[DEF] VARCHAR(MAX),
@framingeinstein
framingeinstein / arduino
Created January 21, 2019 00:49
arduino
int potpin = 0;
int switchpin = 7;
int enablepin = 11;
int in1pin = 10;
int in2pin = 9;
int statuspin= 13;
void setup() {
function initialize () {
/*
Here is the issue... this assumes a carousel will exist on the page.
*/
if(!carousel && _satellite.getVar('pageName') !== "dealer/gallery"){
//console.log('Initialization Delayed 250ms...');
setTimeout(initialize, 250);
return;
}
function parseQuery(href){
var qo = {};
var parts = href.split('?');
var query = [];
if(parts.length > 1){
query = parts[1].split('&');
}
if(query.length > 0){
if(query[0] == ""){
function fib(maximum){
var n0 = 1, n1 = 2, next = 0, sum = 1;
console.log(n0, n1)
next = n0 + n1;
while(next < maximum){
n0 = n1; n1 = next;
if(next % 2 !== 0){
sum = sum + next;
}
next = n0 + n1;
#change for By centering
reflectHorizontal <- function(R, z){
return (-1 * as.numeric(z) + 2 * as.numeric(R))
}
jgc <- function()
{
.jcall("java/lang/System", method = "gc")
}
function parseQuery(href){
var qo = {};
var parts = href.split('?');
var query = [];
if(parts.length > 1){
query = parts[1].split('&');
}
if(query.length > 0){
if(query[0] == ""){
//for i in *.csv; do zip -r $(echo "$i" | tr '.csv' '.zip') "$i"; rm -rf "$i"; done
//find data -type f -name '*.inc' -print0 | xargs -0 rename 's/.inc$/.json/'
//for file in ./**/*.inc; do mv "$file" "${file%.inc}.json"; done
var csv = require('csv');
var fs = require('fs');
var async = require('async');
var glob = require('glob');
function pad(num, size) {
{
"name": "saint-automate",
"version": "1.0.0",
"description": "CSV to SAINT file translator",
"main": "process.js",
"scripts": {
"test": "echo \"Error: no test specified\" && exit 1"
},
"dependencies": {
"async": "^2.0.0",
@framingeinstein
framingeinstein / adobe-plugins-sample.js
Created February 16, 2017 15:00
Sample Implementation
/* Visit Number */
/* s.prop58=s.eVar58=s.getVisitNum(); */
s.prop58=s.getVisitNum();
/* Time Parting (prop59,evar59=Hour of Day;prop60,evar60=Day of Week;prop61,evar61=Weekend or Weekday) */
s.prop59=s.getTimeParting('h','-5');
s.eVar59=s.getValOnce(s.prop59,'s_evar59',0);
s.prop60=s.getTimeParting('d','-5');
s.eVar60=s.getValOnce(s.prop60,'s_evar60',0);
s.prop61=s.getTimeParting('w','-5');