Tuesday, August 13, 2013

Stored Procedure - Fiscal Year

USE [DB]
GO
/****** Object:  UserDefinedFunction [dbo].[udf_Fiscal_Year]    ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Description: <Description,,>
-- =============================================
ALTER FUNCTION [dbo].[udf_Fiscal_Year] (@datetime datetime)
RETURNS varchar(50)
AS
begin
declare @FY varchar(50)

select @FY=(CASE WHEN Month(@datetime) IN (5,6,7,8,9,10,11,12) THEN Year(Dateadd(yy,1,@datetime)) ELSE Year(@datetime) END)
       
return @FY

end




No comments:

Post a Comment