test

0

Please login or register to vote for this query.

(click on this box to dismiss)

Computational Science

Q&A for scientists using computers to solve scientific problems

set nocount on;
declare @table1 table (Id int, description1 varchar(50), dt datetime2(0))
declare @table2 table (Id int, description2 varchar(50), dt datetime2(0))

declare @etlcutoff datetime2(0) = (select dateadd(mi, -50, getdate()))
declare @dt1 datetime2(0) = (select dateadd(mi, -51, getdate()))
declare @dt2 datetime2(0) = (select dateadd(mi, -50, getdate()))
declare @dt datetime2(0) = getdate()

insert into @table1
values 
(1, 'test1', @dt1),
(2, 'test2', @dt1),
(3, 'test2', dateadd(mi, 2, @dt1))

insert into @table2
values 
(1, 'test21', @dt2),
(2, 'test22', @dt2),
(3, 'test22', dateadd(mi, -51, @dt2))

select t1.*
      ,'***'
      ,t2.*
      ,@etlcutoff As etlcutoff
      ,@dt as dt
from   @table1 As t1
       LEFT OUTER JOIN @table2 t2 ON
         t1.id = t2.id
where (t1.dt >= @etlcutoff OR t2.dt >= @etlcutoff)

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results