Compare Max value in one table to Max value in another table 1

[NorthNone]

How can I check whether the max values for the same field in two separate tables are equal? Could a stored procedure do this? Then I'd use the SP result in SSIS to stop a load process because data are not up-to-date. Thanks, Jean

 

[markros]

if (select max(Value) from Table1) = (select max(Value) from Table2)
print 'The max values are the same..'

PluralSight Learning Library

 

[NorthNone]

Thanks so much, Mark. Have a star!