Skip to content

Instantly share code, notes, and snippets.

@monkeyhouse
monkeyhouse / identity_insert_copy_table.sql
Created October 22, 2018 14:32
Write statements to copy table data from source db to destination db for tables with identity inserts
declare @db_to varchar(100) = '[to].[dbo].'
declare @db_from varchar(100) = '[from].[dbo].'
declare @tables varchar(1000) = 'TABLE1,TABLE2,TABLE3'
declare @copy_scripts table
(
id integer identity(1,1),
table_name varchar(200),
copy_statement varchar(4000),
id_insert_on varchar(200),
@monkeyhouse
monkeyhouse / instructions.txt
Last active December 26, 2016 13:14
install aurelia-http-fetch steps
steps to install fetch
npm install whatwg-fetch --save
npm install aurelia-fetch-client --save
in aurelia.json, add thse to the vendor-bundle.js
"aurelia-fetch-client",
{
"name": "whatwg-fetch",
"path": "../node_modules/whatwg-fetch",
@monkeyhouse
monkeyhouse / app.html
Last active December 26, 2016 05:07
Aurealia Fa Icon Attribute - this attribute converts file extensions into the font awesome icon
<template>
<!-- require icon here or in resources file-->
<!-- this attribute converts file extensions into the font awesome icon, not comprehensive
basically copy pasta'd most of lookup table from elsewhere -->
<i class="fa fa-5x" icon="file-xls"></i>
</template>
@monkeyhouse
monkeyhouse / icon.ts
Last active December 24, 2016 06:29
Aurelia Icon Attribute
import {autoinject, bindable, bindingMode} from 'aurelia-framework';
/***
* created to : attach custom font-awesome class name to icon
* renders font-awsome class named based on parameters extension and type
* both parameters are required, always
*
* if you only need to bind a signle paremter, use the single value binding approach instead because its cleaner
* http://aurelia.io/hub.html#/doc/article/aurelia/templating/latest/templating-custom-attributes/4
@monkeyhouse
monkeyhouse / install + aurelia.json mods
Last active July 29, 2018 22:14
aurelia selectize simple custom element
npm install selectize - save
npm install jquery -save
add this to the aurelia.json file in the dependencies section of the vendor bundle
"jquery",
{
"name": "selectize",
"path": "../node_modules/selectize/dist",
<link rel="import" href="../polymer/polymer.html">
<polymer-element name="my-element">
<template>
<style>
:host {
position: absolute;
width: 100%;
height: 100%;