Kshitij klimaye
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [color] | |
| ui = auto | |
| [color "branch"] | |
| current = yellow reverse | |
| local = yellow | |
| remote = green | |
| [color "diff"] | |
| meta = yellow bold | |
| frag = magenta bold | |
| old = red bold |
klimaye
/ itemAtIndexInASplitString
Created
December 27, 2013 13:56
sql scaler function to return an item at a specific index in a split string. Was useful to me in a select clause parsing a value like Age_0_14
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE FUNCTION dbo.itemAtIndexInASplitString( @stringToSplit VARCHAR(MAX), @delimiter VARCHAR(5), @indexToReturn int) | |
| RETURNS | |
| varchar(max) | |
| AS | |
| BEGIN | |
| DECLARE @returnList TABLE ([ID] int, [Name] [nvarchar] (500)) | |
| DECLARE @name NVARCHAR(255) | |
| DECLARE @pos INT | |
| DECLARE @index INT | |
| DECLARE @return_value varchar(max) |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #under ~/.profile | |
| alias gst='git status' | |
| #on command prompt for colors | |
| git config --global color.ui true | |
| #more to come. |