Click here to Skip to main content
14,979,837 members

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

Articles: 3, Tip/Tricks: 2

RSS Feed

Average article rating: 4.90

Programming Languages
Visual Basic
Posted: 6 Oct 2014   Updated: 1 Mar 2016   Views: 54,974   Rating: 4.88/5    Votes: 33   Popularity: 7.41
Licence: The Code Project Open License (CPOL)      Bookmarked: 60   Downloaded: 3,160
Please Sign up or sign in to vote.
Fluent database access
Posted: 25 Mar 2015   Updated: 27 Apr 2015   Views: 27,274   Rating: 4.91/5    Votes: 24   Popularity: 6.78
Licence: The Code Project Open License (CPOL)      Bookmarked: 45   Downloaded: 1,570
Please Sign up or sign in to vote.
A high performance extension for creating a DataTable from a Generic collection.
Web Development
ASP.NET
Posted: 26 Oct 2013   Updated: 26 Jan 2016   Views: 87,592   Rating: 4.91/5    Votes: 47   Popularity: 8.16
Licence: The Code Project Open License (CPOL)      Bookmarked: 112   Downloaded: 3,670
Please Sign up or sign in to vote.
A propertymapping extension for DataReaders

Average blogs rating:

No blogs have been submitted.

Average tips rating: 5.00

Database Development
SQL Server
Posted: 3 Jan 2012   Updated: 7 Jan 2012   Views: 7,950   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      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
Posted: 23 Sep 2012   Updated: 23 Sep 2012   Views: 11,150   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 1   Downloaded: 0
Please Sign up or sign in to vote.
How to find the Lowest Common Ancestor in a tree.

Average reference rating:

No reference articles have been posted.

Average project rating:

No projects have been posted.

Jörgen Andersson
Database Developer
Sweden Sweden
No Biography provided