Thank you too CELKO for coming back.

Just a copy of questions:

How can I incorporate your suggestion into my code?

...

Jeff,

Thanks for coming back.

I am trying to combine several stored procedures and functions into one query that I can run with my limited access. Initially, whilst I refine the...

If it helps the functions are:

[font="Courier New"]ALTER FUNCTION [rpt].[getFXRate](@Currency CHAR(3), @OnDate DATETIME)

RETURNS FLOAT

AS

BEGIN

-- make sure that we don't do anything for US$

IF @Currency='USD' RETURN 1

...