Articles by Jörgen Andersson (Articles: 3, Tip/Tricks: 2)

Programming Languages
Visual Basic	Fluent Database Access 6 Oct 2014 Updated: 1 Mar 2016 Rating: 4.88/5 Votes: 33 Popularity: 7.41 Licence: CPOL Views: 67,155 Bookmarked: 60 Downloaded: 3,277 Please Sign up or sign in to vote. Fluent database access
	A generic Collection to DataTable Mapper 25 Mar 2015 Updated: 27 Apr 2015 Rating: 4.91/5 Votes: 24 Popularity: 6.78 Licence: CPOL Views: 34,844 Bookmarked: 45 Downloaded: 1,692 Please Sign up or sign in to vote. A high performance extension for creating a DataTable from a Generic collection.
Web Development
ASP.NET	A propertymapping Extension for DataReaders 26 Oct 2013 Updated: 26 Jan 2016 Rating: 4.91/5 Votes: 47 Popularity: 8.16 Licence: CPOL Views: 104,972 Bookmarked: 111 Downloaded: 3,724 Please Sign up or sign in to vote. A propertymapping extension for DataReaders

No blogs have been submitted.

Database Development
SQL Server	Stupid CTE tricks -- string concatenation [Tip/Trick] 3 Jan 2012 Updated: 7 Jan 2012 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 9,080 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. Pretty cool little trick you've made there.With the help of an analytic function, I've fixed the ordering, and as a byproduct it also scales better:WITH ranked AS ( SELECT make,model,Rank() over (PARTITION BY make ORDER BY model) Rnk FROM MakeModel ),cte...
Programming Languages
SQL	Finding the Lowest Common Ancestor in a tree [Tip/Trick] 23 Sep 2012 Updated: 23 Sep 2012 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 12,280 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. How to find the Lowest Common Ancestor in a tree.

No reference articles have been posted.

No projects have been posted.

Jörgen Andersson

Database Developer

Sweden

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.