It would be nice to have an Eastern Orthodox version of the code.

I use ranking functions to find and delete dups:

SELECT * FROM

(

SELECT [pat_info_handle]

,[pat_handle]

,[type]

...

It would be nice to know where you do the QUOTENAME(columnname, '"')

I had a similar problem. I removed the CALCULATE when I entered a code for a new calculated member. That solved my problem. Thanks!

Yes, I just figured that out. Thank you!

This is very weird but when I added lcd and created a subfolder within the folder that contains the psftp.exe, I was able to copy the file! I tried wildcard...

Peter, thank you. I actually don't need to change a directory. I might want to do it in the future but for now a directory where psftp.ext is sitting is...

Dear Peter, thank you for your reply. I removed the ServerSubdirectory as you suggested since I need to get a file from a root directory. My psftp.exe is sitting in...

Can you, please help me to GET a file from SFTP server? I can PUT a file as your article shows. That works great. I don't have to change to...

Never mind my previous post. I ran the Register.sql on a wrong db. I was able to run all the sql statements after I ran Register.sql.

Someone, please help me. I successfully registered the assembly SQLSpatialTools but when I run these statements to use the AffineTransform function I get this error:

Msg 243, Level 16, State 4,...

I don't see the script in the article. Am I missing anything?

Stan

I was able to use this approach to identify and delete duplicates very easily. I just had my FROM clause in a form of another query that just gets all...