Lionel Clarke : November 2005

Home SQL .NET Exchange Opinion Blogs Forums About

Software Engineer - Red Gate Software

November 2005 - Posts

Sql Puzzle 3

Posted Tuesday, November 22, 2005 3:50 PM | 12 Comments

/* This puzzle is simple. Given the table below you have to output the words of the famous Christmas carol using a single select statement. Each line must be a separate row of the results set. I am also adding the restriction that you can not use Read More

by Lionel | 12 Comments | Comment on this post

Sql Puzzle 2

Posted Friday, November 04, 2005 4:46 PM | 2 Comments

/*Todays puzzle comes from Andras who incudentally got the best solution so far to the last puzzle.We have two tables a letters table and a numbers table. The letters tableis a letter followed by three numbers. The idea is to write a query that returns Read More

by James | 2 Comments | Comment on this post

Opinion Home

Opinion Pieces (96 articles)

Geek of the Week (37 articles)

Tony Davis - Editor (6 articles)

Phil Factor (41 articles)

Damon Armstrong (8 articles)

Douglas Reilly (40 articles)

Adrian Furnham (1 articles)

Claire Brooking

Richard Morris (34 articles)

Tim Gorman (1 articles)

Jesse Liberty (5 articles)

Sarah Blow (1 articles)

Anna Larjomaa (1 articles)

Gaidar Magdanurov (2 articles)

Regular Columnists (1 articles)

Ben Hall (2 articles)

Blogs Home

November 2005

Virtualizing Exchange: Pros and Cons

With the increasing acceptance of the use of Virtualization as a means of providing server... Read more...

Encouraging .NET Reflector Add-ins

Jason Haley is well-known for the resources he's provided to developers who wish to extend Reflector's... Read more...

Using .NET Reflector Add-ins

.NET Reflector by itself is great, but it really comes into its own with the help of some add-ins. Here... Read more...

Unique Experiences!

You'd have thought that a unique constraint was an easy concept - Not a bit of it; it can cause a lot... Read more...

Dynamic Data Templates in ASP.NET 3.5

Gayani gives an introduction to Dynamic Data Templates in ASP.NET 3.5 and explains how one can save a... Read more...

Site map | Become an author | Contact us