I just copied that SQL into management studio. and got the same result:

Msg 203, Level 16, State 2, Line 1

The name 'INSERT INTO @Banner_Orion_Employee_Comparison

(LAST_NAME, BANNER, ORION)

SELECT

a.LAST_NAME, a.BANNER_COLUMN, b.[rank]

FROM OPENQUERY(ORCLPROD_APDORACLE, 'select...

I did that. Here is the full function (Thanks for your help by the way):

USE [CTM_Reporting]

GO

/****** Object: UserDefinedFunction [dbo].[ufn_Banner_Orion_Employee_Comparison_parser_v2] Script Date: 3/13/2014 11:57:36 AM ******/

SET ANSI_NULLS...

I have already tried that. I just reset the statement to that and got this:

Internal sitting on a server behind a DMZ, so no worries about sql injection.

Msg 203, Level...