andy-uq

using System;

namespace Terabyte.Data
{
	/// <summary>Guid utilities</summary>
	public static class GuidHelper
	{
		/// <summary>Given a string returns a Guid. </summary>
		/// <remarks> Returns <c>Guid.Empty</c> if s is null.</remarks>
		/// <param name="s">Any parsable guid, or the return value from <see cref="GuidToString"/></param>

andy-uq

DECLARE @nodeId uniqueidentifier
SELECT @nodeId = 0 -- Put your node Id here

	WITH NodeTree(ID, ParentID, [Level])
	AS
	(
		-- The immediate Node we're getting (which will be excluded in the final query)
		SELECT a.ID, a.ParentID, 0
			FROM Node a
			WHERE ID = @nodeId 

andy-uq

public static class Placeholder
{
	private static readonly ILoremContent Lorem = new ZombieLorem();
	private static readonly ILoremContent AlternateLorem = new KittenLorem();

	private static readonly Random _random = new Random();

	public static string ImageUrl(int width, int height = 0)
	{
		if ( height == 0 )

andy-uq

git clone file://%1

andy-uq

using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;

namespace PatchLiveServer
{
	class Program
	{

andy-uq

MERGE CasualRosterAllocation AS D
			USING 
			(
				SELECT x.Id, Date, Shift.Id AS ShiftId, Casual.Id AS CasualId, PlaceHolderCount,
					(SELECT MAX(RosterAllocationHeader.Id) 
					 FROM RosterDetail 
						INNER JOIN RosterAllocationHeader ON RosterAllocationHeader.RosterId = RosterDetail.Id
					 WHERE RosterDetail.Guid=RosterGuid) AS RosterAllocationHeaderId
				FROM (VALUES (@0, @1, @2, @3, @4, @5)) x (Id, RosterGuid, Date, ShiftGuid, CasualGuid, PlaceHolderCount)
					INNER JOIN Shift ON Shift.Guid = ShiftGuid

andy-uq

EXEC sp_change_users_login 'Auto_Fix', 'user'

andy-uq

The Patterson cylindrical projection “falls between the popular Miller 1, which excessively exaggerates the size of polar areas, and the Plate Carrée, which compressess the north-south dimension of mid latitudes.”

andy-uq

public static string GetBuildDirectory()
{
	var solution = Environment.GetEnvironmentVariable("NCrunch.OriginalSolutionPath");
	if (!string.IsNullOrEmpty(solution))
		return Path.GetDirectoryName(solution);

	var teamCityLocation = Environment.GetEnvironmentVariable("teamcity.build.checkoutDir");
	if (!string.IsNullOrEmpty(teamCityLocation))
	{
		return teamCityLocation;

andy-uq

CAST(CAST(newid() AS binary(10)) + CAST(GETDATE() AS binary(6)) AS uniqueidentifier)