liuzy163

## gist:8b8f8c7119624b5bdbe30e133d5f5910

compile - Dependencies for source set 'main' (deprecated, use 'implementation ' instead).
+--- org.springframework.boot:spring-boot-starter-web:1.4.7.RELEASE
|    +--- org.springframework.boot:spring-boot-starter:1.4.7.RELEASE
|    |    +--- org.springframework.boot:spring-boot:1.4.7.RELEASE
|    |    |    +--- org.springframework:spring-core:4.3.9.RELEASE
|    |    |    |    \--- commons-logging:commons-logging:1.2
|    |    |    \--- org.springframework:spring-context:4.3.9.RELEASE
|    |    |         +--- org.springframework:spring-aop:4.3.9.RELEASE
|    |    |         |    +--- org.springframework:spring-beans:4.3.9.RELEASE

## Fighter.java
package zl.ca.test;

public class Fighter extends Person {
  private int power;

  public Fighter(String name, int age) {
    super(name, age);
  }

  public int getPower() {

## gist:56e1f8a52c6d3481863e
<!DOCTYPE html>
<html>
<head>
  <meta charset="UTF-8">
  <title>Nested Table</title>

  <style>
    table {
      border-collapse: collapse;
    }

## pivotExample.sql
CREATE TABLE OrderItem(
	lineItemId int IDENTITY(1,1) NOT NULL,
	orderid int NOT NULL,
	itemName nchar(10) NOT NULL,
	qty int NOT NULL
)
GO

INSERT INTO OrderItem (orderid,itemName,qty)
     VALUES (100, 'ipad', 4),

## gist:727c9c793f51a6288896
create procedure dbo.fixDuplication(@accountNumber varchar(255), @productId varchar(30))
as
begin
	WITH CTE as
	(
	select oli.id, oli.serialNumber, row_number()
	over (partoliion by serialNumber order by serialNumber) as rownumber
	from orderLineItems as oli
	join orders as o on o.id=oli.orderId
	where o.accountnumber = @accountnumber

## gist:6f24978e67cf18aac61e
<!DOCTYPE html>
<html>
<head>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.3/jquery.min.js"></script>
<script>
 function secretChanged(element){
    var currentRow = $(element).parents().parents("tr:first");
    $("#notes").slideUp(500);
    $("#notes").insertAfter(currentRow);
    $("#notes").slideDown(500);

	compile - Dependencies for source set 'main' (deprecated, use 'implementation ' instead).
	+--- org.springframework.boot:spring-boot-starter-web:1.4.7.RELEASE
	\| +--- org.springframework.boot:spring-boot-starter:1.4.7.RELEASE
	\| \| +--- org.springframework.boot:spring-boot:1.4.7.RELEASE
	\| \| \| +--- org.springframework:spring-core:4.3.9.RELEASE
	\| \| \| \| \--- commons-logging:commons-logging:1.2
	\| \| \| \--- org.springframework:spring-context:4.3.9.RELEASE
	\| \| \| +--- org.springframework:spring-aop:4.3.9.RELEASE
	\| \| \| \| +--- org.springframework:spring-beans:4.3.9.RELEASE
	package zl.ca.test;

	public class Fighter extends Person {
	private int power;

	public Fighter(String name, int age) {
	super(name, age);
	}

	public int getPower() {
	<!DOCTYPE html>
	<html>
	<head>
	<meta charset="UTF-8">
	<title>Nested Table</title>

	<style>
	table {
	border-collapse: collapse;
	}
	CREATE TABLE OrderItem(
	lineItemId int IDENTITY(1,1) NOT NULL,
	orderid int NOT NULL,
	itemName nchar(10) NOT NULL,
	qty int NOT NULL
	)
	GO

	INSERT INTO OrderItem (orderid,itemName,qty)
	VALUES (100, 'ipad', 4),
	create procedure dbo.fixDuplication(@accountNumber varchar(255), @productId varchar(30))
	as
	begin
	WITH CTE as
	(
	select oli.id, oli.serialNumber, row_number()
	over (partoliion by serialNumber order by serialNumber) as rownumber
	from orderLineItems as oli
	join orders as o on o.id=oli.orderId
	where o.accountnumber = @accountnumber