Click here to Skip to main content
15,905,914 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
6 Oct 2014   Updated: 1 Mar 2016   Rating: 4.88/5    Votes: 33   Popularity: 7.41
Licence: CPOL    Views: 68,016     Bookmarked: 60   Downloaded: 3,278
Please Sign up or sign in to vote.
Fluent database access
25 Mar 2015   Updated: 27 Apr 2015   Rating: 4.91/5    Votes: 24   Popularity: 6.78
Licence: CPOL    Views: 35,254     Bookmarked: 45   Downloaded: 1,695
Please Sign up or sign in to vote.
A high performance extension for creating a DataTable from a Generic collection.
Web Development
ASP.NET
26 Oct 2013   Updated: 26 Jan 2016   Rating: 4.91/5    Votes: 47   Popularity: 8.16
Licence: CPOL    Views: 106,444     Bookmarked: 111   Downloaded: 3,726
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
3 Jan 2012   Updated: 7 Jan 2012   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: CPOL    Views: 9,240     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
23 Sep 2012   Updated: 23 Sep 2012   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: CPOL    Views: 12,320     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.
Database Developer
Sweden Sweden
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.