Just correcting a typo in his SQL statement:

SELECT TOP 1 <field_name>, COUNT(<some_field>) AS tmp

FROM <table_name>

GROUP BY <field_name>

ORDER BY tmp DESC

No, you can not if you are using xp_sendmail.

the @Message parameter of xp_sendmail only accepts up to 8000 bites.

If you must use xp_sendmail, you have 2 options:

1. Attach an html...

The 26th connection would be denied.

Microsoft has more licensing plans than just that. I suggest contacting their licensing people. Maybe the SPLA program is for you. Instead of paying one...

There is no bottom command, only top. So, to get the bottom records, you have to sort desc.

For example:

Select Top 100 *

From myTable

Order By someField DESC

You have too many double quotes on this line:

objTxtFile.writeline( "put """ & strSourcePath & "\" & rsFName("FileName") & """")

You should only have 3 at the very last part. By having...

I'm assuming that he is using a linked server to query the other server? How is the linked server set up? Is it configured to map all users to a...

I do this many times a day.

In your DTS package, create an ActiveX script. Use the FileSystemObject to write your ftp script that you need to run that day. Then...

These things should not be set within the code of the stored procedure. In fact, some of them can't be changed by doing this within the stored procedure.

They should be...

Different how? Is the count being returned different? By how much?

Can you post the code fro botht he batch and the sp so we can rule out user error?

I do...

Have you tried putting the conditional statement in the where clause into the join statement? This can greatly increase the efficency of the query in many cases.

For example, let's suppose...