[dbo].[al_bi_begn_end_date

[dbo].[al_bi_begn_end_date_view]

(local) > mdb > Views > dbo.al_bi_begn_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_begn_end_date_view
AS
SELECT
DISTINCT CONVERT(datetime, '1970-01-01 00:00:00') AS begin_date,
CONVERT(datetime, '2050-01-01 00:00:00') AS end_date,
GETDATE() AS curr_date
GO

Uses