SQL Challenge: Snap To Nearest Factor

In my office, I often have people come over to my desk and say something like “Zach, I’ve got a SQL Challenge for you…”, and I love it. It gives me a chance to just take a break from what I’m doing and engage my brain in something different for a few minutes.

I thought it might be fun to post some of these challenges up on my site, just to see what people come up with – so, here’s the latest:

SQL Challenge: Snap To Nearest Factor

A user will select a whole number between 1 and 100 – You need to be able to “snap” that number to the nearest factor of another number.

Example one – Using a factor of 5 and a number of 19 you should return 20, which is the nearest factor of 5 to 19.

Example two – Using a factor of 9 and a number of 41, you should return 45.

Lets see what you can come up with. I’ll post my attempt in the comments at a later date as to not spoil the fun.

DECLARE @Factor INT = 5
DECLARE @Num INT = 19
Digg This
Reddit This
Stumble Now!
Buzz This
Vote on DZone
Share on Facebook
Bookmark this on Delicious
Kick It on DotNetKicks.com
Shout it
Share on LinkedIn
Bookmark this on Technorati
Post on Twitter
Google Buzz (aka. Google Reader)