brentmaxwell

Sub ChangeDoubleStraightQuotesToSmartQuotes()
    Selection.Find.ClearFormatting
    Selection.Find.Replacement.ClearFormatting
    With Selection.Find
        .Text = """"
        .Replacement.Text = """"
        .Forward = True
        .Wrap = wdFindContinue
        .Format = False
        .MatchCase = False

brentmaxwell

CREATE PROCEDURE GenerateDataDictionary
	@TableName NVARCHAR(MAX)
AS
BEGIN
	SELECT 
		c.name AS ColumnName,
		CASE
			WHEN c.max_length = -1 THEN dt.name + '(max)'
			WHEN dt.name = 'nvarchar' THEN dt.name + '('+CAST(ISNULL(c.max_length,0)/2 AS NVARCHAR)+')'
			WHEN dt.name = 'varchar' THEN dt.name + '('+CAST(ISNULL(c.max_length,0) AS nvarchar)+')'

brentmaxwell

public class AutoMapperConfig
{
    /// <summary>
    /// Function that is called in the Global.asax file
    /// Runs through and calls each of the functions below, registering the various mappings
    /// </summary>
    public static void Execute()
    {
        RegisterOtherMaps();
        RegisterMapperHelpers();

brentmaxwell

<?php
	$aprs_php_ver = "0.1";
	$aprs_is_url = "http://srvr.aprs-is.net:8080";
	 
	date_default_timezone_set('UTC');
	$defaultSSID = "10";
	$defaultPath = "APRS,WIDE2-2,TCPIP*";

	if($_SERVER["REQUEST_METHOD"] == "POST")
	{

brentmaxwell

CREATE FUNCTION [dbo].[DelimitedStringToTable]
(
        @String nvarchar(MAX),
        @Delimiter nvarchar(1)
)
RETURNS @Items TABLE
(
        Item nvarchar(50)
)
AS

brentmaxwell

pm list packages -f

brentmaxwell

This Gist confirms the Linked Identity in my OpenPGP key, and links it to this GitHub account.

Token for proof:
[Verifying my OpenPGP key: openpgp4fpr:48fcfd01403cf2ad5b242924755d89895912d6fa]

brentmaxwell

Keybase proof

I hereby claim:

• I am brentmaxwell on github.
• I am brentmaxwell (https://keybase.io/brentmaxwell) on keybase.
• I have a public key whose fingerprint is 48FC FD01 403C F2AD 5B24 2924 755D 8989 5912 D6FA

To claim this, I am signing this object:

brentmaxwell

namespace System
{
    public static class GpsTime
    {
        public static int ToGpsTimeWeekNumber(this DateTime datetime)
        {
            DateTime datum = new DateTime(1980, 1, 6, 0, 0, 0);
            TimeSpan difference = datetime.Subtract(datum);
            return (int)(difference.TotalDays / 7);
        }

brentmaxwell

CREATE FUNCTION [StringIpToBin]
(
        @StringIp VARCHAR(15)
)
RETURNS BINARY(4)
AS
BEGIN
        RETURN
                CAST(CAST(PARSENAME(@StringIp,4) AS INT) AS BINARY(1)) +
                CAST(CAST(PARSENAME(@StringIp,3) AS INT) AS BINARY(1)) +