Hi

I need to FTP a file from HP3000 to SQL 2005 server. How do I setup a user
account in SQL server side to enable the FTP process from HP3000. I have the
code as below:

       !BUILD FTPXEQT.PUB.SYS;REC=-2,128,F,ASCII;DISC=1
       !ftp 111.11.111.11      --> <SQL ip>
        user anonymous  
        password
        put file1.data filenew
        quit
       !PURGE FTPXEQT.PUB.SYS

Using ranking functions in a subquery to feed a CLR function values in a specified order.
Challenging Query - Please Help
JOIN Question...
TOP by GROUP SQL 2000
this simple query returns too much records