kenny-evitt

## Regex for strings that do not begin with specific text
^(?:(?!Something\s\-\s).)*$

## Regex for strings that do not end with specific text
^(?:.(?!config$))*$

## Regex for strings that do not contain specific text but do end with specific text
^(?:(?!\\Configs\\).)*\.config$

## FogBugz text snippets
-----Original Message-----

<span style="background-color:WhiteSmoke;border:1px dotted Black"></span>

## Visual Studio source control "Configure User Tools" dialog field values for Compare It!
Command:
C:\Program Files (x86)\Compare It!\wincmp3.exe

Arguments:
%1 /=%6 %2 /=%7

## Generate table of dates from numbers (T-SQL)
SELECT NumberedDate = DATEADD( day, DATEDIFF(day, 0, GETDATE()) - Number + 1, 0 )
INTO #lastSixtyDays
FROM dbo.Numbers
WHERE Number < 62;

## Git commands
# Remove a file from the repository, but not the file system; the 'f' option forces the removal; the 'r' option performs a recursive removal (if a directory is specified)
git rm -f -r --cached './Mri.Web.Mvc/DocumentArchiveErrors_*.xls'

# Fix commits (not already pushed to a remote repository); also, see the much more verbose example below
git rebase --interactive $parent_of_flawed_commit
git rebase --interactive flawed_commit_hash^        # Note the '^'

# Change message of last commit; this is only safe is it has not already been pushed to a remote repository
git commit --amend -m "New commit message"

## gist:9121755
exec sp_executesql N'SELECT this_.ThingId as ThingId261_0_, this_.SomethingRelatedId as SomethingRelatedId261_0_, this_.Label as Label261_0_, this_.IsAwesome as IsAwesome261_0_, this_.IsAmazing as IsAmazing261_0_, this_.IsCool as IsCool261_0_, this_.FriendlyName as FriendlyName261_0_, this_.TypeId as Ty8_261_0_, this_.StatusId as StatusId9_261_0_, this_.LastUpdatedUserId as LastUpdatedUserId261_0_ FROM Things this_ WHERE this_.ThingId in (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14)',N'@p0 int,@p1 int,@p2 int,@p3 int,@p4 int,@p5 int,@p6 int,@p7 int,@p8 int,@p9 int,@p10 int,@p11 int,@p12 int,@p13 int,@p14 int',@p0=9436,@p1=9411,@p2=8905,@p3=8829,@p4=8803,@p5=8804,@p6=8683,@p7=8930,@p8=10012,@p9=10012,@p10=10012,@p11=8449,@p12=8470,@p13=8461,@p14=8443

## gist:8e2da026122fbc1825ef

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                kenny-evitt
                / gist:8e2da026122fbc1825ef
            
            
              Last active
              August 29, 2015 14:01
            
              
                Stack Overflow search for inactive questions with few answers, none of which have been accepted
              
          
    The following search should return questions tagged sql', with three answers or less, none of which have been accepted, and last active on the specified date.
[sql] answers:..3 lastactive:2014-04-16 hasaccepted:0

  
## wrapping-function.clj
(defn f [a b & c]
  (* a (apply + `(~b ~@c))))

(f 1 2 3) ; -> 5


;; Wrapping the function

(defn wrapping-f [a b & c]
  (apply f `(~a ~b ~@c)))
	-----Original Message-----

	<span style="background-color:WhiteSmoke;border:1px dotted Black"></span>
	Command:
	C:\Program Files (x86)\Compare It!\wincmp3.exe

	Arguments:
	%1 /=%6 %2 /=%7
	SELECT NumberedDate = DATEADD( day, DATEDIFF(day, 0, GETDATE()) - Number + 1, 0 )
	INTO #lastSixtyDays
	FROM dbo.Numbers
	WHERE Number < 62;
	# Remove a file from the repository, but not the file system; the 'f' option forces the removal; the 'r' option performs a recursive removal (if a directory is specified)
	git rm -f -r --cached './Mri.Web.Mvc/DocumentArchiveErrors_*.xls'

	# Fix commits (not already pushed to a remote repository); also, see the much more verbose example below
	git rebase --interactive $parent_of_flawed_commit
	git rebase --interactive flawed_commit_hash^ # Note the '^'

	# Change message of last commit; this is only safe is it has not already been pushed to a remote repository
	git commit --amend -m "New commit message"
	(defn f [a b & c]
	(* a (apply + `(~b ~@c))))

	(f 1 2 3) ; -> 5


	;; Wrapping the function

	(defn wrapping-f [a b & c]
	(apply f `(~a ~b ~@c)))