Recently I had the necessity to retrieve a concatenated string of values as a column for a report. This can be achieved quite simply by creating a UDF that returns the concatenated string and calling within the SELECT statement. However, I do not like using UDF’s within SELECT statements due to performance issues. So I started searching the net for a possible alternative and came across the following: http://www.kodyaz.com/articles/concatenate-using-xml-path.aspx...
Tuesday, 22 February 2011
Tuesday, 15 February 2011
An Introduction to Using Patterns in Web Design
15
Feb, 2011
A fantastic article from Ryan Singer at 37 Signals. http://37signals.com/papers/introtopatterns/index The use of design patterns in web design can help developers tackle the tricky balance between user experience and business objectives....
Friday, 4 February 2011
SQL: OVER Clause
04
Feb, 2011
The OVER clause allows partitioning and ordering of the rowset. The syntax for this function: Ranking Window Functions < OVER_CLAUSE > :: = OVER ( [ PARTITION BY value_expression, ... [ n ] ] <ORDER BY_Clause> )Aggregate Window Functions < OVER_CLAUSE > :: = OVER ( [ PARTITION BY value_expression, ......
Tuesday, 1 February 2011
jQuery 1.5 Released
01
Feb, 2011
jQuery 1.5 was released for consumption today!
Grab jQuery 1.5 here
This release includes:
Complete rewrite of the Ajax module.
New feature: Deferred Objects
New method: jQuery.sub()
Performance improvements (Adjacent Traversal)
Bug Fixes - Approx ...
Subscribe to:
Posts (Atom)
