First, Get rid of all the "dbo." from the query. Then, the dateadd is wrong here: DATEADD(HOUR,@__timezoneoffset,(SELECT dbo.v_ClientAdvertisementStatus.laststatustime)) AS 'Last Status Time' It should be: DATEADD(HOUR,@__timezoneoffset,v_ClientAdvertisementStatus.laststatustime) AS 'Last Status Time' I would make your "FROM" statement like so: FROM v_r_system and left join dbo.v_AdvertisementInfo instead. Also, your LEFT OUTER joins should just be LEFT joins. nick