[dbo].[al_bi_begin_end_date

[dbo].[al_bi_begin_end_date_view]

(local) > mdb > Views > dbo.al_bi_begin_end_date_view

Properties
Columns
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	7:00:37 PM Tuesday, April 26, 2011
Last Modified	7:00:37 PM Tuesday, April 26, 2011

Columns

Name
begin_date
end_date
curr_date

SQL Script

SET QUOTED_IDENTIFIER OFF
GO
CREATE VIEW al_bi_begin_end_date_view
AS
SELECT
DISTINCT CONVERT(datetime, '1970-01-01 00:00:00') AS begin_date,
CONVERT(datetime, '2020-01-01 00:00:00') AS end_date,
GETDATE() AS curr_date
FROM ca_owned_resource
GO

Uses

[dbo].[ca_owned_resource]
dbo