Mohammad Arifur Rahaman marifrahman

## gist:600b0b24cd1f88b79c077bdede99b937
##Update last git commit command and pust it

git commit --amend -m "some comment that to be updated to"
git push --force-with-lease

## Update proof seed data
PRINT 'Seeding MyTest statuses.';

BEGIN TRY
	BEGIN TRANSACTION

	CREATE TABLE [MyTest].[#Status] (
		[Id]			int		NOT NULL,
		[StatusLabel]	varchar	(50)  NOT NULL
	);

## cmd to get file list
dir /b *.pdf >filelist.txt

## getGithubProjects.js
// Inspired by the code from http://jointheconversation.org


jQuery.githubUser = function(username, callback) {
  jQuery.getJSON("https://api.github.com/users/" + username + "/repos?callback=?", callback);
}

jQuery.fn.loadRepositories = function(username) {
  this.html("<span>Querying GitHub for repositories...</span>");

## Excel VSLOOKUP example
=IF(ISERROR(VLOOKUP(A14,Sheet2!B:B,1,FALSE)),"FILTER ME OUT","KEEP ME")

## index.html
<!DOCTYPE html>
<html>
<head>
<meta name="description" content="jQuery Multiple email address Validation" />
<script src="http://code.jquery.com/jquery-2.1.1.min.js"></script>

<script src="http://ajax.aspnetcdn.com/ajax/jquery.validate/1.8/jquery.validate.js"></script>

  <meta charset="utf-8">
  <title>JS Bin</title>

## jsbin.AVOseno.css
body {
background-image: url('http://lorempixel.com/output/technics-q-c-1244-1096-2.jpg');
background-repeat: no-repeat;
background-size: cover;
text-align:center;
}

#maindiv {
width:900px;
height:500px;

## jsbin.IfiheQu.css
* {
    margin: 0;
    padding: 0;
}
body {
    background: url(http://i47.tinypic.com/2090r3c.jpg) no-repeat;
}
h1 {
    font:small-caps bold 25px Times New Roman;
    text-transform:capitalize;

## SQL_Single _from_multiple_row
Scenario :
SubjectID       StudentName
----------      -------------
1               Mary
1               John
1               Sam
2               Alaina
2               Edward

To

## SQL_server_get_duplicate
use *DATABASE_NAME*
go
SELECT     *YOUR_FIELD*, COUNT(*) AS dupes
FROM         *YOUR_TABLE_NAME*
GROUP BY *YOUR_FIELD*
HAVING      (COUNT(*) > 1)
	##Update last git commit command and pust it

	git commit --amend -m "some comment that to be updated to"
	git push --force-with-lease
	PRINT 'Seeding MyTest statuses.';

	BEGIN TRY
	BEGIN TRANSACTION

	CREATE TABLE [MyTest].[#Status] (
	[Id] int NOT NULL,
	[StatusLabel] varchar (50) NOT NULL
	);
	// Inspired by the code from http://jointheconversation.org


	jQuery.githubUser = function(username, callback) {
	jQuery.getJSON("https://api.github.com/users/" + username + "/repos?callback=?", callback);
	}

	jQuery.fn.loadRepositories = function(username) {
	this.html("<span>Querying GitHub for repositories...</span>");
	<!DOCTYPE html>
	<html>
	<head>
	<meta name="description" content="jQuery Multiple email address Validation" />
	<script src="http://code.jquery.com/jquery-2.1.1.min.js"></script>

	<script src="http://ajax.aspnetcdn.com/ajax/jquery.validate/1.8/jquery.validate.js"></script>

	<meta charset="utf-8">
	<title>JS Bin</title>
	body {
	background-image: url('http://lorempixel.com/output/technics-q-c-1244-1096-2.jpg');
	background-repeat: no-repeat;
	background-size: cover;
	text-align:center;
	}

	#maindiv {
	width:900px;
	height:500px;
	* {
	margin: 0;
	padding: 0;
	}
	body {
	background: url(http://i47.tinypic.com/2090r3c.jpg) no-repeat;
	}
	h1 {
	font:small-caps bold 25px Times New Roman;
	text-transform:capitalize;
	Scenario :
	SubjectID StudentName
	---------- -------------
	1 Mary
	1 John
	1 Sam
	2 Alaina
	2 Edward

	To
	use DATABASE_NAME
	go
	SELECT YOUR_FIELD, COUNT(*) AS dupes
	FROM YOUR_TABLE_NAME
	GROUP BY YOUR_FIELD
	HAVING (COUNT(*) > 1)