Hi Sir,

Your code helped to create full stored procedure.

This is the script I have wrote.

CREATE PROCEDURE SP_STAT_CURR

(

@I_NET_AMOUNT NUMERIC(10,3),

@I_DOCUMENT_CURR VARCHAR(3),

@I_TARGET_CURR VARCHAR(3)

)

AS

BEGIN

IF (@I_TARGET_CURR = @I_DOCUMENT_CURR)

BEGIN

SELECT @I_NET_AMOUNT AS O_TARGET_CURR

END

ELSE

IF (@I_DOCUMENT_CURR = 'USD' AND @I_TARGET_CURR != 'USD')

BEGIN

SELECT ((@I_NET_AMOUNT) / (RATE)) AS O_TARGET_CURR

FROM CURRENCY

WHERE CURRENCY = @I_TARGET_CURR AND RTYPE = 'M'

END

ELSE

IF(@I_DOCUMENT_CURR <> 'USD' AND @I_TARGET_CURR = 'USD')

BEGIN

SELECT (@I_NET_AMOUNT * RATE) AS O_TARGET_CURR

FROM CURRENCY

WHERE CURRENCY = @I_DOCUMENT_CURR AND RTYPE = 'M'

END

ELSE

BEGIN

SELECT ((SELECT (@I_NET_AMOUNT * RATE) AS O_TARGET_CURR

FROM CURRENCY WHERE CURRENCY = @I_DOCUMENT_CURR AND RTYPE = 'M')/(RATE)) FROM CURRENCY

WHERE CURRENCY = @I_TARGET_CURR AND RTYPE = 'M'

END

END

EXEC SP_STAT_CURR 25,'GBP','GBP'

Once Again I am Thank You Sir!!