Snipplr

(SQL) Bulk insert/upload microsoft sql server (csv) - dego89

Fri, 17 May 2013 04:03:48 GMT

Bulk upload a CSV into Microsoft SQL Server

(Visual Basic) Linked Chart Update - sjmoorecouk

Thu, 25 Oct 2012 02:53:33 GMT

Relinks chart objects to a new source (where newfile is the variable containing that new full path/file source info)

(Visual Basic) Return File Reference - sjmoorecouk

Tue, 18 Sep 2012 23:01:12 GMT

Used to invoke a GetSaveAsFileName dialogue box

(SQL) Return last day of month - sjmoorecouk

Fri, 10 Aug 2012 00:10:43 GMT

Input: Month and year number Output: Last day of month

(CSS) Opacity CSS Microsoft Web Developer - flebber

Wed, 25 Jul 2012 18:02:21 GMT

Keep compatibility with micorosft validation in 2010.

(CSS) Opacity CSS Microsoft Web Developer - flebber

Wed, 25 Jul 2012 17:59:17 GMT

Keep compatibility with micorosft validation in 2010.

(Visual Basic) Splitting the words in a TitleCase string without using regular expressions (for VBA) - warwick-datum-process

Thu, 28 Jun 2012 03:16:13 GMT

Using VBA (Visual Basic for Applications) in MS Access, I needed to convert TitleCase to lower\_case, but did not have the regex enqine that's available in VB Script. This solution, based on a simple state machine model, splits the words in the string (converting to lower-case is trivial after that). It treats a block of upper-case letters as a single word, but the last letter of that block is the first letter of the next word; e.g., "VBAIsLame" becomes "VBA Is Lame". Because of this behaviour, if you subsequently convert to lower-case, you cannot reliably convert back to the original (all-upper-case words are indistinguishable from title-case words). To resolve this potential ambiguity, you can supply an "upper\_case\_indicator" that will be inserted before each capital letter that isn't the start of a word. So `TitleCaseSplit("VBAIsLame", "_", "-")` returns "V-B-A\_Is\_Lame".

(Visual Basic) Summary Numerical Count - sjmoorecouk

Fri, 17 Feb 2012 03:36:19 GMT

Counts numbers and places the result in row 1. To get this populated click an top row (any) cell and click Yes to the following dialogue box. Only uniquely counts number values, not text.

(PHP) Anti-Word Alert - travishines

Sat, 26 Nov 2011 05:37:37 GMT

I've yet to work on a WordPress site where at least once post wasn't copied from Microsoft Word, producing a mess of inline tags and awful markup. This helps prevent that, just a little.

(JavaScript) Convert rgba alpha value to microsoft gradient - inreflection7

Tue, 28 Jun 2011 07:26:50 GMT

A really fucking cool and easy way to calculate the alpha value for microsoft gradient using Javascript. Particularly useful in the Firebug console. Like a calculator.

(HTML) IE6Countdown Banner - EpiksolCreative

Wed, 16 Mar 2011 01:56:25 GMT

(Other) SSIS Log File Name - michanne

Thu, 23 Dec 2010 07:36:13 GMT

Basic Datetime format based on Package name. MyPackage_20101222-13_16_34.log.xml

(SAS) SAS Macros to Read data from MS Excel using DDE - sastechies

Thu, 07 Oct 2010 23:03:59 GMT

(Other) Inserting £ (pound sign) with US Microsoft keyboard - gotofritz

Thu, 22 Apr 2010 08:28:37 GMT

Must be the number pad or it won't work. Other sequences work for other characters

(SQL) Search Database for string - CDIDevs

Thu, 31 Dec 2009 10:50:23 GMT

(SQL) Search Database for Column Name - CDIDevs

Thu, 31 Dec 2009 10:49:04 GMT

(JavaScript) ASP.net & MS AJAX: Enabling WebKit support (chrome, safari) in MS AJAX (fixing webkit browser detection) - jink

Wed, 11 Nov 2009 22:18:34 GMT

Load this Javascript after the MS AJAX files have been loaded. In the example I am using jQuery to call the patchMicrosoftAjax() method, but you can use any method you desire.

(PHP) Replace MS Smart Quotes In PHP - SteveMcDaniel

Fri, 09 Oct 2009 18:16:31 GMT

(PHP) Downloadable Excel File with PHP - iTony

Sun, 02 Aug 2009 16:28:43 GMT

(SQL) Search stored procedures for string - charmcitycoder

Mon, 27 Jul 2009 15:37:23 GMT