Category Archives: SQL

Anything to do with SQL

Recursive CTE's

Posted on 06/04/2010 by Bert

First, the problem: You have a table containing some kind of a hierarchy using parent IDs. You have to write some SQL to return all of this data in the hierarchy with each parent and then the child records. One … Continue reading →

Posted in SQL | Tagged , , | Leave a comment

Microsoft Certification 70-433: MS SQL 2008 Database Development

Posted on 31/10/2009 by Bert

A while ago my client decided to switch over from using Sybase ASE to MS SQL Server 2008. Having not used MS SQL for the past couple of years, I decided to go write the certification exam as a way … Continue reading →

Posted in Microfost Certifications, SQL | Leave a comment