On a totally different subject, but something you should starting thining about. You need to get away from using three (and possibly) four part naming conventions iin your SELECT lists and such.

Using three and four part naming has been depreciated in SQL Server and may not be supported in future versions. Here is what that means:

SELECT

dbo.tablename.columnname1

FROM

dbo.tablename

WHERE

dbo.tablename.columnname2 = 'somevalue';

may no longer work in future versions. You need to start looking at writing queries and such like this:

SELECT

tablealias.columnname1

FROM

dbo.tablename tablealias -- or dbo.tablename as tablealias

WHERE

tablealias.columnname2 = 'somevalue';