jkriddle

UPDATE USER_INFO SET STATE='AL' WHERE STATE='Alabama';
UPDATE USER_INFO SET STATE='AK' WHERE STATE='Alaska';
UPDATE USER_INFO SET STATE='AZ' WHERE STATE='Arizona';
UPDATE USER_INFO SET STATE='AR' WHERE STATE='Arkansas';
UPDATE USER_INFO SET STATE='CA' WHERE STATE='California';
UPDATE USER_INFO SET STATE='CO' WHERE STATE='Colorado';
UPDATE USER_INFO SET STATE='CT' WHERE STATE='Connecticut';
UPDATE USER_INFO SET STATE='DE' WHERE STATE='Delaware';
UPDATE USER_INFO SET STATE='DC' WHERE STATE='District of Columbia';
UPDATE USER_INFO SET STATE='FL' WHERE STATE='Florida';

jkriddle

/****** Object:  StoredProcedure [dbo].[sp_GetRecommendedProducts]    Script Date: 02/27/2013 11:40:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[sp_GetRecommendedProducts]
  -- Add the parameters for the stored procedure here
  @productID int

jkriddle

var l = new LegendApp;
  
if(window.FB)
{
		facebookInit();
}
else
{
		window.fbAsyncInit = facebookInit;
}

jkriddle

/*!
 * Bootstrap v2.2.2
 *
 * Copyright 2012 Twitter, Inc
 * Licensed under the Apache License v2.0
 * http://www.apache.org/licenses/LICENSE-2.0
 *
 * Designed and built with all the love in the world @twitter by @mdo and @fat.
 */
.tbs article,

jkriddle

var keyName = @"HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\IIS Extensions\MSDeploy\2";
const string valueName = "InstallPath";
var kVal = Registry.GetValue(keyName, valueName, "").ToString();
if (string.IsNullOrEmpty(kVal))
{
    keyName = @"HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\IIS Extensions\MSDeploy\1";
    kVal = Registry.GetValue(keyName, valueName, "").ToString();
}
if (string.IsNullOrEmpty(kVal)) return;
var targetName = Environment.MachineName;