Viewing 2 posts - 1 through 2 (of 2 total)
Very good!! I hadn't seen this before. Thank you! The following code is an abstraction of basically what I'll end up doing to accomplish this goal.
DECLARE @tbl...
August 18, 2009 at 1:14 pm
#1041121
Have you tried casting as decimal?
DECLARE @p float
SET @p = '15.4'
SELECT CAST(@p as decimal (8,2))
August 18, 2009 at 11:43 am
#1041043