Tutorial by Examples: st

WITH cte AS ( SELECT ProjectID, ROW_NUMBER() OVER (PARTITION BY ProjectID ORDER BY InsertDate DESC) AS rn FROM ProjectNotes ) DELETE FROM cte WHERE rn > 1;

The Kernel#require method will load files only once (several calls to require will result in the code in that file being evaluated only once). It will search your ruby $LOAD_PATH to find the required file if the parameter is not an absolute path. Extensions like .rb, .so, .o or .dll are optional. Re...

DECLARE @DateFrom DATETIME = '2016-06-01 06:00' DECLARE @DateTo DATETIME = '2016-07-01 06:00' DECLARE @IntervalDays INT = 7 -- Transition Sequence = Rest & Relax into Day Shift into Night Shift -- RR (Rest & Relax) = 1 -- DS (Day Shift) = 2 -- NS (Night Shift) = 3 ;WITH roster AS ...

Requirements: Docker can be installed on any Linux with a kernel of at least version 3.10. Docker is supported on the following 64-bit versions of Ubuntu Linux: Ubuntu Xenial 16.04 (LTS) Ubuntu Wily 15.10 Ubuntu Trusty 14.04 (LTS) Ubuntu Precise 12.04 (LTS) Easy Installation Note: Installi...

import { Pipe, PipeTransform } from '@angular/core'; import { DatePipe } from '@angular/common' @Pipe({name: 'ifDate'}) export class IfDate implements PipeTransform { private datePipe: DatePipe = new DatePipe(); transform(value: any, pattern?:string) : any { if (typeof value === ...

Custom sigils can be made by creating a method sigil_X where X is the letter you want to use (this can only be a single letter). defmodule Sigils do def sigil_j(string, options) do # Split on the letter p, or do something more useful String.split string, "p" end # Use t...

Visual Studio Code is an open-source and feature-rich code editor from Microsoft. To set it up it for NativeScript development, open the Command Palette (F1 or ⌘+Shift+P) and type ext install NativeScript. Once the NativeScript extension is installed, the debugger should allow you to set breakpoint...

template<class InputIterator, class Function> Function for_each(InputIterator first, InputIterator last, Function f); Effects: Applies f to the result of dereferencing every iterator in the range [first, last) starting from first and proceeding to last - 1. Parameters: first, last -...

//Swift let fooViewController = UIViewController() navigationController?.pushViewController(fooViewController, animated: true) //Objective-C UIViewController *fooViewController = [[UIViewController alloc] init]; [navigationController pushViewController:fooViewController animated:YES];

Installing Rails on Ubuntu On a clean ubuntu, installation of Rails should be straight forward Upgrading ubuntu packages sudo apt-get update sudo apt-get upgrade Install Ruby and Rails dependecies sudo apt-get install git-core curl zlib1g-dev build-essential libssl-dev libreadline-dev libyam...

Corner radius for all 4 edges: UIBezierPath* rectanglePath = [UIBezierPath bezierPathWithRoundedRect: CGRectMake(x,y,width,height) cornerRadius: 11]; [UIColor.grayColor setFill]; [rectanglePath fill]; Corner radius for top-left edge: UIBezierPath* rectanglePath = [UIBezierPath bezierPat...

Consider a simple rectangle that is drawn by the bezier path. UIBezierPath* rectanglePath = [UIBezierPath bezierPathWithRect: CGRectMake(x,y,width,height)]; [UIColor.grayColor setFill]; [rectanglePath fill]; Basic Outer-fill shadow: CGContextRef context = UIGraphicsGetCurrentContext();...

Realm currently does not support storing a list of primitives. It is on their todo list (GitHub issue #575), but for the meantime, here is a workaround. Create a new class for your primitive type, this uses Integer, but change it for whatever you want to store. public class RealmInteger extends Re...

Detailed instructions on getting unicode set up or installed.

Given a string, strspn calculates the length of the initial substring (span) consisting solely of a specific list of characters. strcspn is similar, except it calculates the length of the initial substring consisting of any characters except those listed: /* Provided a string of "tokens&quo...

Calling the dependencies task allows you to see the dependencies of the root project: gradle dependencies The results are dependency graphs (taking into account transitive dependencies), broken down by configuration. To restrict the displayed configurations, you can pass the --configuration opti...

This example shows how to open a default dialer (an app that makes regular calls) with a provided telephone number already in place: Intent intent = new Intent(Intent.ACTION_DIAL); intent.setData(Uri.parse("tel:9988776655")); //Replace with valid phone number. Remember to add the tel: pr...

One way to mock a function is to use the create_autospec function, which will mock out an object according to its specs. With functions, we can use this to ensure that they are called appropriately. With a function multiply in custom_math.py: def multiply(a, b): return a * b And a function...

When using prompt a user can always click Cancel and no value will be returned. To prevent empty values and make it more persistent: <h2>Welcome <span id="name"></span>!</h2> <script> // Persistent Prompt modal var userName; while(!userName) { userN...

The code below will prompt for numbers and continue to add them to the beginning of a linked list. /* This program will demonstrate inserting a node at the beginning of a linked list */ #include <stdio.h> #include <stdlib.h> struct Node { int data; struct Node* next; }; ...