I have attempted to add the wehere exists function but I am not sure If I am scripting it correctly
I have added the following to the script
FROM dbase.Visits (nolock)
where Exists (VisitStartDate > = VisitHubGoLiveDate);
Does this still work even if the Field VisitHubGoLiveDate is not part of the source table?