ADSM-L

Re: Select Statement for Archives

2000-07-11 11:20:56
Subject: Re: Select Statement for Archives
From: "Tomblin, David" <David.Tomblin AT AVISTACORP DOT COM>
Date: Tue, 11 Jul 2000 08:20:56 -0700
I modified one of my select statements to check the years you requested.
The first display everything the second selected info in columns.
Dave T

select * from archives where archive_date>'1997-01-01 00:00:00.000000' and
archive_date<'1998-12-31 00:00:00.000000'

select node_name, filespace_name, ll_name, hl_name from archives where
archive_date>'1997-01-01 00:00:00.000000' and archive_date<'1998-12-31
00:00:00.000000'

<Prev in Thread] Current Thread [Next in Thread>