Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE FUNCTION [dbo]._dcBolivarFuerte (@Valor decimal(32,2)) RETURNS decimal(32,2)
- AS
- BEGIN
- declare @Result decimal(32,2) Set @Result = @Valor
- If @Result<>0
- begin
- Set @Result = ISNULL(CAST(ROUND(@Valor/1000000,3)AS DECIMAL(32,2)),0.0)
- end
- RETURN @Result
- END
- GO
- CREATE FUNCTION [dbo]._dcBolivar(@Valor decimal(32,2)) RETURNS decimal(32,2)
- AS
- BEGIN
- declare @Result decimal(32,2) Set @Result = @Valor
- If @Result<>0
- begin Set @Result = Round(@valor/1000000.0,3)
- end
- RETURN @Result
- END
- GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement