set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ( @Seconds DECIMAL ) RETURNS DECIMAL AS BEGIN DECLARE @Dec DECIMAL SET @Dec = @Seconds / 3600 RETURN @Dec END ------------------------------------- USE [PCPUNCH] GO DECLARE @return_value DECIMAL EXEC @return_value = [dbo].[spEmployeeFromResultsAndAuthUsers] @BadgeNo = 30806, @PayPeriodID = 14 SELECT 'Return Value' = @return_value GO