gistfile1.sql

CREATE FUNCTION [dbo].[ufn_MimicView] 
(
)
RETURNS 
@ViewsData TABLE 
(
	A NVARCHAR(255) 
	, B NVARCHAR(255) 
	, C VARCHAR(255) 
	, D VARCHAR(255) 
	, E CHAR(50)			
)
AS
BEGIN
	-- Perform logic to see whether to call Database X or Y
	
	IF(DatabaseToUse = 'X')
	BEGIN
		INSERT INTO 
			@ViewsData 
		
		SELECT
			*
                FROM 
                        X
	END
	ELSE
	BEGIN
		INSERT INTO 
			@ViewsData 
		SELECT
			*
                FROM 
                        Y
	END
	
	RETURN 
END
GO