patriklindstrom

USE [datamart]
GO

/****** Object:  Table [dbo].[dim_time]    Script Date: 5/14/2024 5:44:04 PM ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[dim_time]') AND type in (N'U'))
DROP TABLE [dbo].[dim_time]
GO

/****** Object:  Table [dbo].[dim_time]    Script Date: 5/14/2024 5:44:04 PM ******/
SET ANSI_NULLS ON

patriklindstrom

# It might work in 4, but I'm not testing there. Lower you'll have to tweak code
#requires -Version 5.0
param(
    # Your Live ID for MSDN login
    [Parameter(Mandatory)]
    [PSCredential]
    [System.Management.Automation.CredentialAttribute()]
    $Credential,

    # Pick a browser to use. Defaults to Firefox (which doesn't seem to require an external Driver file) 

patriklindstrom

$CSharpLinqMojo = @"
using System.Collections.Generic;
using System.Linq;
namespace CompareTool
{
    public class DictCompareOnKeyOnly : IEqualityComparer<KeyValuePair<string, string>>
    {
        public bool Equals(KeyValuePair<string, string> x, KeyValuePair<string, string> y)
        {
            return x.Key.Equals(y.Key);

patriklindstrom

using System;
using System.Runtime.InteropServices;
using System.IO;
using System.Text;
using System.Security.Cryptography.X509Certificates;
namespace PKI
{
	class Results : IEquatable<Results>
	{
		internal static readonly Results NotFound = new Results

patriklindstrom

<#
SYNOPSIS
Converts on or many Markdown textfiles to html. Uses githubs restservice.
.DESCRIPTION
All files  ending with .txt or md1 or md will recursivly be run against githubs restservice api.github.com/markdown. Default is that it will be put in same directory with htm as extension.
.EXAMPLE
 runs .\ConvertFrom-Markdown.ps1 -FilePath readme.md
.EXAMPLE
Pipe directory "C:\projdocumentation" | .\ConvertFrom-Markdown.ps1  -OutputPath "c:\projdoc_html"
.EXAMPLE

patriklindstrom

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

// to use close xml use nuget Package Manager Console:  Install-Package ClosedXML
// example from http://closedxml.codeplex.com/wikipage?title=Showcase&referringTitle=Documentation
// This example is to prove that closedXML has no problem with strings containing å ä ö swedish letters with umlauts and circles.
// it adds  person with name Tösse Långbänk

patriklindstrom

  public class PageTextElement
    {
        public string Page;
        public string Token;
        public string Webtext;
        public string Language;
        public string Translator;
        public DateTime CreationTime;
        
    }