Jonathan Kim jon-kim

## CreateEmployeeTimetable_Pivot_Dynamic.SQL
CREATE TABLE #DATA (
      name VARCHAR(50),
      shift_start DATETIME,
      shift_end DATETIME
)
INSERT INTO #DATA VALUES ('Boony Antonchik', '2017-05-30 14:00', '2017-05-30 17:00')
INSERT INTO #DATA VALUES ('Toma Wittier', '2017-05-30 14:00', '2017-05-30 15:00')
INSERT INTO #DATA VALUES ('Genvieve Arends', '2017-05-30 8:00', '2017-05-30 13:00')
INSERT INTO #DATA VALUES ('Ulla Friatt', '2017-05-30 18:00', '2017-05-30 19:00')
INSERT INTO #DATA VALUES ('Giralda Ranfield', '2017-05-30 13:00', '2017-05-30 15:00')

## data.csv

          
            soundcloud
            different_url

            
              https://api.soundcloud.com/tracks/910291
              https://api.different-embed.com/12345

            
              https://api.soundcloud.com/tracks/5678
              https://api.different-embed.com/562222278

            
              https://api.soundcloud.com/tracks/12345
              https://api.different-embed.com/89999999

## ExtensionMethods_XamlClone.cs
public static class ExtensionMethods
{
    public static T XamlClone<T>(this T original) where T : class
    {
        if (original == null)
            return null;
        object clone;
        using (var stream = new MemoryStream())
        {
            XamlWriter.Save(original, stream);

## CreateEmployeeTimetable_Pivot.SQL
CREATE TABLE #DATA (
      name VARCHAR(50),
      shift_start DATETIME,
      shift_end DATETIME
)

INSERT INTO #DATA VALUES ('Boony Antonchik', '2017-05-30 14:00', '2017-05-30 17:00')
INSERT INTO #DATA VALUES ('Toma Wittier', '2017-05-30 14:00', '2017-05-30 15:00')
INSERT INTO #DATA VALUES ('Genvieve Arends', '2017-05-30 8:00', '2017-05-30 13:00')
INSERT INTO #DATA VALUES ('Ulla Friatt', '2017-05-30 18:00', '2017-05-30 19:00')

## autoCompleteLngLatGoogleMapApi.html
<!DOCTYPE html>
<html>
    <head>
        <script src="https://maps.googleapis.com/maps/api/js?v=3.exp&sensor=false&libraries=places"></script>
    </head>
    <body>
        <label for="locationTextField">Location</label>
        <input id="locationTextField" type="text" size="50">
        <div id="output" />
        <script>

## autoCompleteGoogleMapApi.html
<!DOCTYPE html>
<html>
    <head>
        <script src="https://maps.googleapis.com/maps/api/js?v=3.exp&sensor=false&libraries=places"></script>
    </head>
    <body>
        <label for="locationTextField">Location</label>
        <input id="locationTextField" type="text" size="50">

        <script>
	CREATE TABLE #DATA (
	name VARCHAR(50),
	shift_start DATETIME,
	shift_end DATETIME
	)
	INSERT INTO #DATA VALUES ('Boony Antonchik', '2017-05-30 14:00', '2017-05-30 17:00')
	INSERT INTO #DATA VALUES ('Toma Wittier', '2017-05-30 14:00', '2017-05-30 15:00')
	INSERT INTO #DATA VALUES ('Genvieve Arends', '2017-05-30 8:00', '2017-05-30 13:00')
	INSERT INTO #DATA VALUES ('Ulla Friatt', '2017-05-30 18:00', '2017-05-30 19:00')
	INSERT INTO #DATA VALUES ('Giralda Ranfield', '2017-05-30 13:00', '2017-05-30 15:00')
	soundcloud	different_url
	https://api.soundcloud.com/tracks/910291	https://api.different-embed.com/12345
	https://api.soundcloud.com/tracks/5678	https://api.different-embed.com/562222278
	https://api.soundcloud.com/tracks/12345	https://api.different-embed.com/89999999
	public static class ExtensionMethods
	{
	public static T XamlClone<T>(this T original) where T : class
	{
	if (original == null)
	return null;
	object clone;
	using (var stream = new MemoryStream())
	{
	XamlWriter.Save(original, stream);
	<!DOCTYPE html>
	<html>
	<head>
	<script src="https://maps.googleapis.com/maps/api/js?v=3.exp&sensor=false&libraries=places"></script>
	</head>
	<body>
	<label for="locationTextField">Location</label>
	<input id="locationTextField" type="text" size="50">
	<div id="output" />
	<script>