Skip to content

Instantly share code, notes, and snippets.

View erjjones's full-sized avatar

Eric Jones erjjones

  • Indianapolis, Indiana
View GitHub Profile
@erjjones
erjjones / Contacts.sql
Created August 29, 2012 04:04
Sample Contacts Table for the Get Collection Store Procedure
CREATE TABLE dbo.Contacts (
ContactID int IDENTITY (1,1) NOT NULL,
FirstName nvarchar(64) NULL,
LastName nvarchar(64) NULL,
Phone nvarchar(50) NULL,
[Address] nvarchar(128) NULL,
City nvarchar(50) NULL,
[State] nvarchar(50) NULL,
Zip nvarchar(50) NULL,
Country nvarchar(128) NULL,
@erjjones
erjjones / ContactsTest.sql
Created August 29, 2012 04:05
Sample Contacts Testing Script
DECLARE @Count int, @Sort NVARCHAR(45), @Direction BIT, @Page INT, @PageSize INT
/* ---------------------------------------
USE THE VARIABLES BELOW TO TEST
CHANGE THEM TO SEE HOW THE RESULT
SET CHANGES ...
--------------------------------------- */
SET @Sort = 'FirstName'
SET @Direction = 0 -- ASC = 1, DESC = 0 OR NULL
@erjjones
erjjones / ContactsPrimeScript.sql
Created August 29, 2012 04:03
Sample Prime Script for the Contacts Example
DECLARE @Date SMALLDATETIME,
@NumberOfContacts INT,
@Cntr INT,
@ContactID INT,
@FirstName NVARCHAR(64),
@LastName NVARCHAR(64)
/* ------------------------------------- */
/* -- DEFINE THE NUMBER OF CONTACTS ---- */
/* ------------------------------------- */
@erjjones
erjjones / Jekyll-Post-Config.html
Created March 22, 2012 03:01
Jekyll-Post-Config
---
layout: post
title: Part two on how I built my blog
category: Coding
tags: jekyll github rss
year: 2012
month: 3
day: 22
published: true
summary: A follow up post on how I built my blog
@erjjones
erjjones / Jekyll-Tags-List-Post.html
Created March 22, 2012 02:41
Jekyll-Tags-List-Post
<i class="icon-tags"></i> {% for tag in page.tags %} <a href="/tags/{{ tag }}" title="View posts tagged with &quot;{{ tag }}&quot;"><u>{{ tag }}</u></a> {% if forloop.last != true %} {% endif %} {% endfor %}
@erjjones
erjjones / tag_index.html
Created March 22, 2012 02:07
Jekyll-Tag-Include
<h2>{{page.title}}</h2>
<table class="table table-striped">
<tbody>
{% for post in site.posts %}
{% for tag in post.tags %}
{% if tag == page.tag %}
<tr>
<td>
<h3><a href="{{ post.url }}">{{ post.title }}</a></h3>
<p><strong>{{ post.date | date: "%B %e, %Y" }}</strong> . {{ post.category }} . <a href="http://erjjones.github.com{{ post.url }}#disqus_thread" data-disqus-identifier="{{ post.url }}"></a>
@erjjones
erjjones / tag_gen.rb
Created March 22, 2012 02:04
Jekyll-Tags
module Jekyll
class TagIndex < Page
def initialize(site, base, dir, tag)
@site = site
@base = base
@dir = dir
@name = 'index.html'
self.process(@name)
@erjjones
erjjones / atom.xml
Created March 13, 2012 02:49
SetupRSSfeed
---
layout: nil
---
<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
<title>Eric Jones</title>
<link href="http://erjjones.github.com/atom.xml" rel="self"/>
<link href="http://erjjones.github.com/"/>
<updated>{{ site.time | date_to_xmlschema }}</updated>
@erjjones
erjjones / readme.html
Created March 13, 2012 03:11
ReadMeMd
## Erjjones.Github.com
This is my GitHub user page made with Jekyll, and Twitter Bootstrap. Download it, fork it, follow it, give it away...
Have any feedback for me? [File an issue on this
project](https://github.com/erjjones/Feedback/issues/new) and I will get back to
you as soon as I can.
@erjjones
erjjones / DisqusComments.html
Created March 13, 2012 01:45
ResolvedDisqusCommentsCounter
<script type="text/javascript">
/* * * CONFIGURATION VARIABLES: EDIT BEFORE PASTING INTO YOUR WEBPAGE * * */
var disqus_shortname = 'ericjones'; // required: replace example with your forum shortname
var disqus_identifier = '{{ page.url }}';
var disqus_url = 'http://erjjones.github.com{{ page.url }}';
/* * * DON'T EDIT BELOW THIS LINE * * */
(function () {
var s = document.createElement('script'); s.async = true;
s.type = 'text/javascript';