ahh good catch

Thanks!!

yes when i run on the linked server it returns the 90 tables i'm trying to query.

I tried those steps, but the Print didn't give me any output.

Your right Phil... Sorry

I added in the other logic

Thanks Jeff

DECLARE @SQL VARCHAR(MAX) = ''
;
 SELECT @SQL += REPLACE(REPLACE('
        RAISERROR("-----------------------------------",0,0) WITH...

Jeff,

Thanks that works perfect, but I have another table(POST Above) that I'm trying to get ALL of the records GT timestamp from processed tables:

''>'' (Select last_updated from Speed_Last_Processed)

Then after I...

When I'm looping thru the tables in DB:

SELECT name from sys.tables where name like 'f3%'

That comment "# Loop through all tables and export a CSV of the Table Data" was...

any ideas or thoughts to make this happen?

Thx.

It was to transfer files across network to backup storage location. I was weighing impact of doing the compression in the SQL backup versus a script..

Thx.

Perfect Thanks!!!!

I want to get rid of the BIG file I'm trying to ZIP but need to make sure I can recreate from the multiple Chunk files created..

Thx.

Cool.

That worked perfect to do split is there away then to using the chunk file to recreate the original file I zipped.

Just wanted to express THANKS to all that replied and gave suggestions and examples... This forum is so helpful and replies are so much appreciated.

We have pushed back and asked...

I'm not sure what else in the Plan would be helpful other than what I provided...

So just to be clear without changing the Table field Def this is no way...

1st)  Still have the Warning in Query Plan

2nd) Column 'design.attValue' is invalid in the select list because it is not contained in either an aggregate function or...

Thanks very much !!!

I'll test the 3 scenario's...