Many thanks ktflash - worked like charm.

OK, so I found the issue with my second error.  I needed a second dataset to populate the parameters in the first dataset.

SELECT [arr].Users,[arr].Groups

FROM [dbo].[UserGroups]

The issue I am having now...

I found my mistake.

But when I run the report I get "An error occurred during local procesing. The report parameter 'GroupSearchTerm' has a defaultvalue or a validvalue that depends that...

I get an error trying to create the stored procedure

Incorrect syntax near '@GroupSearchTerm'.

Thanks, it works now

Yes I tried Openrowset, but unfortunately they have the SQL Server 2017 in compatibility mode 2012 and openrowset won't work. 🙁

CREATE PROCEDURE [dbo].[Excluded_List]

AS

CREATE TABLE #TempTable (Software NVARCHAR(MAX));

BULK INSERT #TempTable

FROM 'c:\temp\EXCLUDE_LIST.txt'

WITH

(

DATAFILETYPE= 'char',

FIELDTERMINATOR=',',

ROWTERMINATOR='\r' -- Carriage Return

);

SELECT * FROM #TempTable;

-- Remove our temporary table.

DROP TABLE #TempTable

Have you created or are you creating the stored proc? Yes

Why are you not allowed to use a temp table? Politics

what do you want to do with the results of...

Ok how do I use a Table Variable

Additional Info:

The temporary Table in my Stored Procedures reads a text file to populate the temporary Table.  I then use a Select *...

Hi Jeff, It works great!  I did some initial testing and two thumbs up.

I will test further and if any issues pop up, I will post it.

Thanks again

Yes each model is on a separate line in the file followed by a comma.  Commas could be removed

The text file just contains a list of Models:

GRX,

TRX,

VRX,

WRX,

NRX,

PRX

I have no choice.  I can't - not allowed to store in a table.

I have to use a text file 🙁

I have been trying LTRIM and no luck.  I am...

Yes I thought of LTRIM - just wasn't sure how to do it with this query:

DECLARE @Job_numbers VARCHAR(max)

SELECT @Job_numbers=BulkColumn

FROM OPENROWSET(BULK 'c:\temp\SampleUnicode.txt', SINGLE_nCLOB) x;

SELECT ModelName0

FROM v_Manufac

WHERE ModelName0 NOT IN

(

SELECT value FROM...

The OPENROWSET is doing this:

(GRX, TRX, VRX, WXR)  and I want this:

(GRX,TRX,VRX,WXR)   - No spaces