gistfile1.sql

CREATE VIEW [dbo].[vw_Property_Advertising_Contract_Management]

AS
/********************************************************************************************************
Name         : dbo.vw_Property_Advertising_Contract_Management
Description  : Generic view on top of the table dbo.Property_Advertising_Contract_Management

Revision History
----------------------------------------------------------------------------------------------------------
Date        Name                 Description
----------------------------------------------------------------------------------------------------------
12/04/2012  Bruce Pinto          View created
01/07/2013  Bruce Pinto          TFS 17875: add new column "vw_Property_Advertising_Contract_Management"

Sample Execution: 
   SELECT * 
   FROM dbo.vw_Property_Advertising_Contract_Management

*********************************************************************************************************/

SELECT property_advertising_contract_management_id
      ,property_id
      ,contract_renewal_month
      ,contract_renewal_day
      ,created_by
      ,created_on
      ,updated_by
      ,updated_on
      ,contract_annual_renewal_rate
FROM dbo.Property_Advertising_Contract_Management