menacestudio’s gists

menacestudio / dynamic_cursor_sample.sql

Created November 13, 2014 03:11

Dynamic and cursor sample

	CREATE TABLE #codes ( code VARCHAR(10))
	INSERT INTO #codes( code )
	SELECT distinct c.someCode FROM dbo.tbl_Sample c WITH(NOLOCK) WHERE c.isDeleted=0 AND NOT ISNULL(c.parts,'')='C'
	AND c.someDate1 >= @anotherDate AND c.someDate1 <= @endDate
	AND c.providerID IN (SELECT userId from #tmpTable)
	ORDER by c.someCode


	-- Temp table for output
	CREATE TABLE #tbl_Sample2 (userid INT, employee VARCHAR(200), type VARCHAR(150), results INT null)

menacestudio / sample_cte_paging.sql

Created November 13, 2014 03:19

Sample paging in TSQL using common table expression (CTE)

	-- Calculate paging
	DECLARE @topRecord VARCHAR(20) = CAST(((@pageSize+@offset)+1) AS VARCHAR)
	DECLARE @cte_query NVARCHAR(MAX)

	SET @cte_query = WITH cte_res
	AS ( SELECT ROW_NUMBER() OVER(ORDER BY ['+@sortBy+'] '+@sortDir+') AS rowid, count() over() as TotalRecords, from (SELECT * FROM #someTable WITH(NOLOCK)) as table1)
	select rowID, TotalRecords, id, someField from cte_res with(nolock) where rowid>'+ CAST(@offset AS VARCHAR) +' and rowid< ' + @topRecord

	EXECUTE sp_executesql @cte_query

menacestudio / controller.js

Last active August 29, 2015 14:10

Angular using Angular directives for Bootstrap

	(function(app) {

	app.controller('Ctrl', Ctrl);
	app.controller('CtrlModal', CtrlModal);

	//Ctrl.$inject = ['$scope', '$modal', 'dataservice'];

	function Ctrl($scope, $modal, dataservice) {
	var vm = this;

menacestudio / service.js

Created December 7, 2014 09:46

Angular ngResource sample

	angular.module("exampleApp", []).service('exampleService', ["$http", "$q" ,function ($http, $q) {
	var service = {
	returnedData: [],
	dataLoaded:{},
	getData = function(forceRefresh)
	{
	var deferred = $q.defer();

	if(!service.dataLoaded.genericData \|\| forceRefresh)
	{

menacestudio / index.html

Created December 9, 2014 05:20

Angular CRUD

	<!DOCTYPE html>
	<html>
	<head>
	<script data-require="angular.js@*" data-semver="1.3.5" src="https://code.angularjs.org/1.3.5/angular.js"></script>
	<script src="https://code.angularjs.org/1.3.5/angular-route.js" data-semver="1.3.5" data-require="angular-route@*"></script>
	<script data-require="[email protected]" data-semver="1.3.5" src="https://code.angularjs.org/1.3.5/angular-resource.js"></script>
	<link href="style.css" rel="stylesheet" />
	<script src="script.js"></script>
	</head>

menacestudio / scoreDirective.js

Created March 13, 2015 21:35

An AngularJS directive for handling score input.

menacestudio / sortableGrid.js

Created March 13, 2015 21:37

An AngularJS directive to add sorting capability to table headers.

menacestudio / datepickerFormatter.js

Created March 13, 2015 21:39

An AngularJS decorator directive to apply automatic formatting to Angular UI datepickers.

	function datepickerPopup() {
	return <ng.IDirective>{
	restrict: 'EAC',
	require: 'ngModel',
	link: function ($scope, $element, $attrs, controller) {
	controller.$formatters.shift();
	}
	}
	}
	angular.module('app').directive('datepickerPopup', datepickerPopup);

menacestudio / numericOnly.ts

Last active August 29, 2015 14:17

An AngularJS decorator directive to only allow numeric values.

	numericOnly.$inject = ['$log'];
	function numericOnly(
	$log: ng.ILogService): ng.IDirective {

	return <ng.IDirective>{
	restrict: 'A',
	scope: true,
	link: link
	};

menacestudio / slider.ts

Created March 17, 2015 22:47

An AngularJS slider directive

Dennis Rongo menacestudio