Articles by Mycroft Holmes (Articles: 6, Tip/Tricks: 7)

Articles: 6, Tip/Tricks: 7

Articles
Technical Blogs
Tips and Tricks
Reference Articles
Projects

Average article rating: 4.67

Database Development
SQL Server	Pivot two or more columns in SQL Server 2005 6 Dec 2008 Updated: 18 Dec 2008 Rating: 4.77/5 Votes: 22 Popularity: 6.31 Licence: CPOL Views: 172,719 Bookmarked: 58 Downloaded: 2,007 Please Sign up or sign in to vote. A workaround for the limitation of only being able to pivot one column.
Desktop Programming
Windows Forms	DataGridView Copy and Paste 31 May 2009 Updated: 31 May 2009 Rating: 4.75/5 Votes: 33 Popularity: 7.21 Licence: CPOL Views: 303,145 Bookmarked: 96 Downloaded: 17,020 Please Sign up or sign in to vote. Copy and paste between a DataGridView and Excel.
	Loading a TreeView using HierarchyID 5 Jun 2009 Updated: 5 Jun 2009 Rating: 4.55/5 Votes: 9 Popularity: 4.34 Licence: CPOL Views: 111,312 Bookmarked: 64 Downloaded: 5,060 Please Sign up or sign in to vote. Using SQL Server 2008 Hierarchy ID data type to populate a TreeView
Programming Languages
C#	Retain the size and position of forms and dialogs 5 Sep 2008 Updated: 5 Sep 2008 Rating: 4.25/5 Votes: 9 Popularity: 4.06 Licence: CPOL Views: 39,257 Bookmarked: 25 Downloaded: 178 Please Sign up or sign in to vote. Store and retreives the last position and size of a form using an XML file.
	CSV to Table to CSV 13 Sep 2008 Updated: 13 Sep 2008 Rating: 4.80/5 Votes: 11 Popularity: 4.80 Licence: CPOL Views: 71,127 Bookmarked: 50 Downloaded: 3,476 Please Sign up or sign in to vote. Utility class to import and export CSV files.
	DatGridView Filtering User Control 10 Jul 2009 Updated: 10 Jul 2009 Rating: 4.93/5 Votes: 12 Popularity: 5.13 Licence: CPOL Views: 70,413 Bookmarked: 72 Downloaded: 4,010 Please Sign up or sign in to vote. A user control that can be attached to any DataGridView that uses a DataTable as the DataSource.

Average blogs rating:

No blogs have been submitted.

Average tips rating: 4.36

Database Development
	Count Lines of code in a database [Tip/Trick] 10 Feb 2010 Updated: 26 Apr 2010 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 11,561 Bookmarked: 5 Downloaded: 0 Please Sign up or sign in to vote. Assuming that a carriage return represents a line of code, this will count the lines of code in a SQL 2008 database:SELECT ROUTINE_NAME,ROUTINE_TYPE,LEN(ROUTINE_DEFINITION )-len(REPLACE(ROUTINE_DEFINITION,CHAR(10),'')) LOCFROM INFORMATION_SCHEMA.ROUTINESCOMPUTE...
SQL Server	TSQL reparent an entire branch with hierarchyid [Tip/Trick] 18 Nov 2009 Updated: 18 Nov 2009 Rating: 3.86/5 Votes: 4 Popularity: 2.32 Licence: CPOL Views: 19,000 Bookmarked: 6 Downloaded: 0 Please Sign up or sign in to vote. Reparenting a Tree branch is a PITA using the HierarchyID functions. This reparents a branch by reformating the string representation of the HierarchyID. Supports moving the branch to the root node. I use an ID as the primary key so the proc expects the ID's of the node recordsDECLARE @NodeID INT
	Reporting Services Hide dulpicate row [Tip/Trick] 17 Mar 2010 Updated: 17 Mar 2010 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 27,370 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. When grouping data within a List control I need a header table and child table. The data comes from 1 datatable where the 1st #n columns are duplicated for each detail rows.The usual answer to this is to set the hide duplicates value in the textbox. This suppresses the text but the row is...
Programming Languages
SQL	SQL Get the last date of the month [Tip/Trick] 7 Sep 2009 Updated: 7 Sep 2009 Rating: 2.60/5 Votes: 3 Popularity: 1.24 Licence: CPOL Views: 12,000 Bookmarked: 8 Downloaded: 0 Please Sign up or sign in to vote. Select dateadd(day, -1, dateadd(month, 1, dateadd(day, 1 - day(@Date), @Date))
	Get the last working day of the month [Tip/Trick] 18 Jul 2010 Updated: 18 Jul 2010 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 26,503 Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. Gets the last week day of the month
	Using GetAncestor() in a join [Tip/Trick] 25 May 2010 Updated: 26 May 2010 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 16,560 Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. GetAncestor() requires a slightly unusual outlook to get the required results
	Combining Insert/Update to one Procedure [Tip/Trick] 11 Jul 2010 Updated: 14 Jul 2010 Rating: 4.09/5 Votes: 12 Popularity: 4.26 Licence: CPOL Views: 35,601 Bookmarked: 13 Downloaded: 0 Please Sign up or sign in to vote. Why do developers insist on separate procedures to do these jobs

Average reference rating:

No reference articles have been posted.

Average project rating:

No projects have been posted.

Mycroft Holmes

	Retired None
	Australia

Started my programming life writing Excel 1.0 macros, God what a long time ago.

Now I'm a dotnet developer, I get to influence direction, play with new toys, build stuff, life is wonderful.

Greatest buzz you can get, walk past a row of desks and see your application running on all of them (and getting paid).

Greatest irritant, pouring 12 months of knowledge and experience into an empty head only to have it leave.

And now I'm retired, no deadlines, no meetings, no managers (except the ONE) and no users!