Anonymous

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
-------------------------------------
28