I am trying to convert this fun to SetAnalysis and i was confused on how to convert WHERE conditions and input variable in this function. your suggestions are welcome...
CREATE FUNCTION dbo.fnGetABCAAmount
(
@ABC_ZZZD INT ,
@ZZZZcode VARCHAR(5) ,
@IsTransisitonedFacility BIT ,
@DateOfService DATE
)
RETURNS MONEY
AS
BEGIN
IF @DateOfService IS NULL
SET @DateOfService = GETDATE();
DECLARE @amount MONEY
SELECT @amount = ( ( ( WorkABC * WorkZZZ )
* ( CASE WHEN YEAR(@DateOfService) < 2006 THEN 1
WHEN YEAR(@DateOfService) = 2007
THEN 0.8994
WHEN YEAR(@DateOfService) = 2008
THEN 0.8806
ELSE 1
END -- Budget Adjustor Value
) ) + ( PEZZZ
* ( CASE WHEN @IsTransisitonedFacility = 1
THEN TransitionedFacilityPExpenseABC
ELSE TransitionedNon_FacilityPExpenseABC
END ) ) + ( MalpracticeABC
* MPZZZ ) )
* ConversionFactor
FROM dbo.ABC_PprABC ABC JOIN
dbo.ABC_GPC gpc ON ABC.ABC_HeaderID = gpc.ABC_HeaderID
JOIN dbo.ABC_Header h ON gpc.ABC_HeaderID = h.ABC_HeaderID
AND @DateOfService BETWEEN StartDate AND EndDate
WHERE ZZZZcode = @ZZZZcode
AND ABC_ZZZD = @ABC_ZZZD
RETURN CAST( @amount AS DECIMAL(10,2))
END
go
