Q&A for professional and enthusiast programmers
USE master DECLARE @ INT=1000000; WITH C as(SELECT abs(number-500+@)r,abs(number)+2s FROM spt_values)SELECT top 1r FROM c WHERE 0not in(SELECT c.r%s FROM c d WHERE c.r>s)ORDER BY abs(r-@),r