Float values are not exact, they are approximate.  Internally, float 0.55 might be 0.550000000001.  CEILING goes up to the next int value no matter how small the amount above the previous...

I'm genuinely confused.

Your q states"How can I combine the three queries to one".  We write queries that combine the 3 queries into a single query. 

But then...

It could be more efficient to get only typeid from table1 in the first pass, like below.  This depends on indexing and the cardinality (how many t1 rows have typeids...

Since you're only keeping ~1/6 of the data, you may want to consider a different approach.

Backup up everything (of course!).  You might even want to make another copy...

SELECT [Product Line]
FROM dbo.[Table]
GROUP BY [Product Line]
HAVING MAX(CASE WHEN [Business Unit] = '' THEN 1 ELSE 0 END) = 1 AND
    MAX(CASE...

If there is any (non-filtered) index keyed first on id, then MAX(id) will do an index seek/lookup.  Internally it could officially be a scan, but it will be a scan...

If the job owner has 'sa' level permissions, then the job is run under the Agent's service account, and thus using its permissions to other resources -- drives, network, etc..

I assume you have space in prod to restore the db to a diff name?

If so, you could:

1) restore the db to a diff name
2)...

To avoid having to lookup every duplicate tab1.col1 value in tab2, which is pointless, I'd try this query:

SELECT t1.col1
FROM (
  SELECT DISTINCT col1...

SQL has a very strong built-in preference...

Some quick thoughts:

1. Why not a 5-minute interval?  I don't know of anything other than a payment system that would need a lower interval than that.

2....