Thank you, this is exactly what I was look for.

Howard

Govinn:

Thanks for the reply.

I am using a Rapid Application Tool (Magic from Magic Software Enteprises) to connect to the database. ALL logins consists of Database...

I am using a Rapid Application Tool (Magic from Magic Software Enteprises) to connect to the database. My login consists of Database Server name, User Name, User Password, (User name...

All users are logged into SQl with sql-authentication and for the majority of users the nt user name does appear.

Howard

The authentication is the same on all PC's.

Am I the only one who cannot get Wayne's snippet to work. I created a little test table, inserted four entries. On with a leading char(13) and one ending with...

Leah:

1. check your rights.

Rights are okay.

2.make sure...

Leah

I ran your query against the pubs database. The only change was the last argument...

Leah:

Thanks for your fast reply.

I...

Leah Kats:

Would you please provide an example of how to properly run your script.

Perhaps use the following in the example:

@FileName = Test_File.xls,

@sql  = select col1, col2, col3 from...

Thanks for the suggestion and example of a different schema design.

This is very helpful information.

Howard

This is along the lines of what I would like to do. Since the backup file already exists on the remote server I would like to run the command line winzip,...

Thank you.

You have been extremely helpful.

Howard

Slight modification to your last query:

select substring(account_number,2,4) as accnt_no,

min(description_1)

from chart_of_accounts

where left(right(account_number,5),2) = '20'

group by substring(account_number,2,4)

order by substring(account_number,2,4)

Works just fine.

Can you tell me why removing the 'min' around description_1 will...

Thank you, that is exactly what I was looking for.

Question, why does the min(description_1) work and just description_1 not work?