August 6, 2007 at 9:21 am
Good morning-
Anyone have any thoughts on how to enable a MOD function? Basically what I need is a formula that would look at a fraction and separate the integer from the remainder. For example:
QTY1=32
QTY2=10
END RESULT: 32/10--> Separate the 3 from the 2?? I believe this used to be int(QTY1/QTY2) and MOD (QTY1/QTY2) but that is not in SQL Server 2005.
Any thoughts would be appreciated. Thank you for your help.
August 6, 2007 at 9:23 am
SELECT 32/10 -> 3
SELECT 32%10 -> 2
Is that what you're looking for?
John
August 6, 2007 at 9:30 am
That's it, thanks! I knew it was something easy, long weekend, Monday came too quick. Thanks for your help!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply