dcs619’s gists

dcs619 / removedupes.sql

Last active August 11, 2016 16:10

Remove Duplicates ex using CTE

	WITH duplicates (name, address, city, state, id)
	AS (
	SELECT name, address, city, state, ROW_NUMBER() OVER (
	PARTITION BY name, address, city, state
	ORDER BY address desc
	) AS id
	FROM source
	)
	DELETE FROM duplicates
	WHERE id > 1

dcs619 / gist:4251024

Created December 10, 2012 14:57

Date/Campus Ranking using CTE

	;with rankings as (
	select id, campus
	, dense_rank() over (partition by id, campus order by date desc ) /* frequency weight */
	* ( 6 - dense_rank() over (partition by id order by date desc)) /* date weight */
	as 'freqrank'
	from attendance
	),
	filter as (
	select id, campus, row_number() over (
	partition by id

dcs619 / checkboxchange.js

Last active December 12, 2015 07:09

Javascript function to toggle div dispaly

	<script type="text/javascript">

	$(document).ready(function () {

	var checkboxChange = function () {
	$(this).parent().next('div').toggle();
	}

	$('.togglePanel').on('change', checkboxChange);

dcs619 / confirmation.html

Created March 14, 2013 20:46

Alternative to building string confirmation message

	<!-- Standard HTML -->

	h3 class="header-text" >Confirm your Contribution: </h3>
	<p>

	<b>John Doe</b>, you're about to give <b>$400.00</b> to the <b>General Fund</b> and <b>$50.00</b> to the <b>Building Fund</b>.

	Your total gift of <b>$450.00</b> will be given using a <b>Visa</b> credit card ending in <b>3456</b>.

	</p>

dcs619 / fix.js

Created December 22, 2013 21:21

keep console.log from crashing

	if (typeof console === "undefined" \|\| typeof console.log === "undefined") {
	console = {};
	}

dcs619 / CompareTables.sql

Last active August 29, 2015 14:00

Compare rowcounts in two SQL tables with the same schema. Note: tables must have one or more primary keys.

	DECLARE @OldDatabase varchar(50)
	DECLARE @NewDatabase varchar(50)

	SELECT @OldDatabase = '4-22-NS'
	SELECT @NewDatabase = '4-25-NS'

	;WITH tableSchema AS (
	SELECT k.* FROM information_schema.columns c
	INNER JOIN information_schema.key_column_usage k
	ON c.column_name = k.column_name

dcs619 / GetRowCount.sql

Created April 30, 2014 15:48

Get row counts from a corrupt database (via sys.objects)

	DBCC UPDATEUSAGE(0) WITH COUNT_ROWS, NO_INFOMSGS

	SELECT DBName = DB_NAME(),
	SchemaName = USER_NAME(so.UID),
	TableName = so.Name,
	TableID = so.ID,
	MinRowSize = MIN(si.MinLen),
	MaxRowSize = MAX(si.XMaxLen),
	ReservedKB = SUM(CASE WHEN si.IndID IN (0,1,255) THEN si.Reserved ELSE 0 END) * pkb.PageKB,
	DataKB = SUM(CASE WHEN si.IndID IN (0,1 ) THEN si.DPages ELSE 0 END) * pkb.PageKB

dcs619 / createResults.coffee

Created July 10, 2014 15:30

local value changes after findOne

	for request in requests

	console.log( request.queries.request[0].siteSearchFilter )
	isQueryInclusive = request.queries.request[0].siteSearchFilter is 'i'

	Results.findOne({
	'_query': query._id
	'isInclusive': isQueryInclusive
	}, (error, result) ->

dcs619 / stash.coffee

Last active August 29, 2015 14:03

isQueryInclusive scoping issue

	# src/server/app/methods/stash.coffee

	###

	Saves the original search result to the DB

	####

	Query = require('../models/search').Query
	Results = require('../models/search').Results

dcs619 / result.json

Created July 21, 2014 19:53

Google search result

David Stevens dcs619