Feeds:
Posts
Comments

Archive for May 20th, 2005

Common Table Expressions

Posted in Everything, Software Development, tagged , on May 20, 2005 | Leave a Comment »

Today I was delighted to learn about common table expressions in SQL Server 2005. Essentially, CTEs replace the need for cursors when executing statements against rows in a result set. Here are some examples… Let us assume that we have an employee table, and the employee table lists all employees in the company. Each employee [...]

Read Full Post »

Follow

Get every new post delivered to your Inbox.