No, this is where you defined the source:

USING ( SELECT --@OrderID,

@orderName,

@orderType,

@orderNumber

) AS source

Per your example I shall insert this...

No data to test with from you, so I don't even know if your code will run, but let me ask why is this in your code?

(

SELECT ordername, ordertype, ordernumber

FROM...

I'm no longer angry, but that's an...

select convert(varchar(8),getdate(),112)+'_test.csv'

The statement above will produce the correct file name for today's date.

What is "that day"? The file with today's...

You're welcome.

If I may make a suggestion for the future: Whenever I am working with dynamic SQL, I never begin with trying to execute the...

[schema].

You have a table named this in every db on every server?

You have a table named this anywhere?

What you typed in was:

That wouldn't work either,...

Can't get there, Lynn. I just came close to calling an OP a liar. My patience is exceedingly thin today.

That's probably your problem with performance, right there.

insert into #FT_FinalAmts(specimen, SG_Great_Less, Creat_Great_Less, PH_Great_Less)

select specimen, coalesce(SGgreat,SGLess), coalesce(creatGreat,creatLess), coalesce(phGreat,phLess)

from #FT_GreatLessAmts

ISNULL() would work too, in this instance.

It does not. You did not do as I requested. You...

Thanks for posting back, Peter. Your results make sense when I look at them now. Still using my creaky old laptop, I'm seeing the following times...

In the meanwhile, here's a hint:

You are putting '[schema].' in as a constant, instead of using two variables to supply the schema name and the name...

Please, let us see the value you are building:

-- add this statement and rerun your code, then paste the printed results back here.

PRINT @SQLstr

EXEC sp_executesql @SQLstr, N'@myVarOUT...

Since Flo brought up the TVF approach, I want to ask. Can anyone point me to documentation about the performance of TVFs v stored procedures? ...

print @@error ????