Skip to content

Instantly share code, notes, and snippets.

/// <summary>
/// Easily get access to embedded resources
/// </summary>
internal static class EmbeddedResource
{
/// <summary>
/// Return a resource stream
/// </summary>
/// <param name="assembly">The assembly the resource is embedded in</param>
/// <param name="name">FQDN or the resource</param>
@kiwipiet
kiwipiet / 0_reuse_code.js
Created October 16, 2015 01:21
Here are some things you can do with Gists in GistBox.
// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console
CREATE FUNCTION [dbo].[GetWellingtonHolidays]
(
@startdate DATE,
@enddate DATE
)
RETURNS TABLE
WITH SCHEMABINDING
AS RETURN
(
WITH alldates ([date]) AS (
@kiwipiet
kiwipiet / GetIntegerSequence
Created August 19, 2014 04:22
Get a sequence of integer numbers, from 1 to @count
CREATE FUNCTION [dbo].[GetIntegerSequence]
(
@count INT
)
RETURNS TABLE
WITH SCHEMABINDING
AS RETURN
(
WITH C0 (c) AS (SELECT 1 UNION ALL SELECT 1)
,C1 (c) AS (SELECT 1 FROM C0 AS A CROSS JOIN C0 AS B)
CREATE FUNCTION [dbo].[GetAge] (
@DOB AS DATE
,@EndDate AS DATE = NULL
)
RETURNS TINYINT
AS
BEGIN
DECLARE @Result AS TINYINT
IF (@EndDate IS NULL)