DECLARE
@amount MONEY;
SET
@amount = 812.85;
SELECT
@amount
AS
Amount
,
CAST
(floor(@amount)
INT
)
[Whole portion]
,@amount % 1
[
Decimal
portion]
Naomi N edited Revision 9. Comment: Added See Also
Naomi N edited Revision 8. Comment: tense
Naomi N edited Revision 7. Comment: Added tag
Naomi N edited Revision 6. Comment: Adjusted participation link
Naomi N edited Revision 4. Comment: Added tags
Naomi N edited Revision 3. Comment: Fixed last link
Naomi N edited Revision 2. Comment: Adjusted link to Kalman's blog
Ed Price - MSFT edited Revision 1. Comment: Title casing, added tags