Since we use all different versions of SQL Express and there is no direct connections between servers and clients, they actually use Delphi to query DBs, create files, transfer files...

Jeff,

I want to thank you for the great powerpoint presentation that you passed along. It is exactly what I was looking for to prove to my superiors that xp_cmdshell...

Have you tried

Set @SQLCMD = 'Select * from openquery(ABCD,"Select * from database.TableName")'

insert into @TempTableName

EXEC (@SQLCMD)

Thank you very much... I'm going through the presentation right now...

much appreciated.

Oh well... :ermm:

In my case, I'm using SQL Express and don't have any other solution than using the xp_cmdshell to use bcp...

I'll continue searching for the best way to secure...

WOW! do I feel silly! I actually thought it was an actual thread...

Note to self: Always look at the date before posting!!! :hehe:

Did you ever create that article?

Was looking into how to implement a secure way to use XP_CMDSHELL... I've read many of the posts... Very interesting...

Now! I'm more confused then when I started reading!...

figured it out...

To convert a UTF8 file to unicode (this helps when you want to Bulk insert a UTF8 file which is no longer supported by MS SQL...

Hi,

I looked up CODEPAGE=RAW for Bulk Insert and Tried it too.

still unsuccessful.

I've been searching to understand the behavior of bulk insert under different operating systems and can't find...

i finally figured out the problem and solution

the copy adds a character when merging 2 files (I was using /B right after the copy) had to change it to...

not sure how I dodged the question... (I didn't mean to)

What would you suggest ?

right now the process in place uses a file system and they want me to...

Hi sgmunson,

The systems are independent but structure can be identical.

I'm still in testing mode (so I'm testing on the same system) but eventually this will be going do...

Thank you very much for time and effort...

Very much appreciated.

🙂

Thanks for your response...

1. the execution plans of the Row_number for:

SELECT *, rn = ROW_NUMBER() OVER(PARTITION BY [UPC], [LocGroup] ORDER BY PriceLvl) FROM #Master_TAB

SELECT *, rn = ROW_NUMBER()...

Here it is... This script creates and populates the necessary tables to optimize the final query.

The final Query spills data to Tempdb which I'm trying to avoid.

CREATE TABLE...