Steven Hollidge stevenh77

stevenh77 / sqldatacompare.bat

Created April 8, 2016 15:46

	sqldatacompare
	/Project:"C:\FolderName\FileName.sdc"
	/Out:"C:\FolderName\Output.txt"
	/Export:"C:\FolderName" /force

stevenh77 / sql-pivot.sql

Created April 8, 2016 15:10

	select * from Source_Table;

	select * from
	( select
	person,
	country,
	'country' + cast(rank()
	over (partition by person order by id)
	as varchar(10))
	as countryrank

stevenh77 / sql-pivot.sql

Created April 8, 2016 15:09

	select * from
	( select
	person,
	country,
	'country' + cast(rank()
	over (partition by person order by id)
	as varchar(10))
	as countryrank
	from dbo.Source_Table) as rankedSource
	pivot

stevenh77 / constvsvalue

Created May 29, 2015 14:33

	//define module
	var app = angular.module('app', []);

	//define constant
	app.constant("mynumberValue", 200);

	//define value
	app.value("numberValue", 100);
	app.value("objectValue", { name: "dotnet-tricks.com", totalUsers: 120000 });

stevenh77 / angular-watch

Created May 29, 2015 13:32

	<!doctype html>
	<html ng-app="Demo">
	<head>
	<title>Scope $watch() vs. $watchCollection() In AngularJS </title>
	</head>
	<style type="text/css">
	a[ ng-click ] {
	cursor: pointer;
	text-decoration: underline;
	}

stevenh77 / angular-d3

Created May 29, 2015 11:15

	<!doctype html>
	<html>
	<head>
	<script src="https://cdnjs.cloudflare.com/ajax/libs/angular.js/1.4.0-rc.1/angular.min.js"></script>
	<script src="https://cdnjs.cloudflare.com/ajax/libs/d3/3.5.5/d3.min.js"></script>

	<script>
	'use strict';

	var app = angular.module('app', []);

stevenh77 / angular-d3

Created May 29, 2015 10:49

	<!doctype html>
	<html>
	<head>
	<script src="https://cdnjs.cloudflare.com/ajax/libs/angular.js/1.4.0-rc.1/angular.min.js"></script>
	<script src="https://cdnjs.cloudflare.com/ajax/libs/d3/3.5.5/d3.min.js"></script>

	<script>
	'use strict';

	var app = angular.module('app', []);

stevenh77 / simple hyperlink directive

Created February 12, 2015 18:00

	.directive('hyperlink', function(){
	return {
	transclude: true,
	replace: true,
	template: '<a ng-transclude></a>',
	}
	})

stevenh77 / hyperlink directive

Created February 12, 2015 17:55

	.directive('hyperlink', function(){
	return {
	restrict: 'E',
	transclude: true,
	link: function (scope, element, attrs, ctrl, transclude) {
	transclude(scope, function (clone) {
	var anchorTag = angular.element("<a href='" + attrs.ngHref + "'></a>");
	anchorTag.append(clone);
	element.append(anchorTag);
	});

stevenh77 / ngPubSub

Created November 22, 2014 11:52

	// publishing up the scope chain
	$scope.$emit('eventWithString', 'message');

	// publishing down the scope chain
	$scope.$broadcast('eventWithObject', {
	text: 'message'
	});

	// event subscription
	$scope.$on('eventWithObject', function (event, data) {