I have not used the Execution Plan windows in Query Analyzer much before but today seemed a good time to do this.

I took the SQL Statement from my procedure and...

Now I am confused. The results I am getting are the opposite from what I would have expected.

When I run the following code:

SELECT OrganisationName, dbo.fsalescountry(dbo.Companies.Sales1) AS AccountManagerCountry

from dbo.Companies...

The procedure I am thinking about returns several hundred rows for each country and puts these into individual zipped spreadsheets.  So an awful lot of calls to the functions. The...

Frank, I missed your reply above. It was NO_OUTPUT that I was looking for.

Thanks

Success

Frank, I received notification of your last message so changing the email address in profiles must have been the solution.

In the office we have a thick cable to the...

Frank, I did not get a notification of your message but I did get a notification on another post after I went in and changed my email address in profile...

No, it went on the end of the EXEC statement following a comma. Perhaps I imagined it. It will come to me one day.

I think I stumbled across a solution. Would the way to do this be to use an output parameter to update a global variable. And then check this variable in...

I have a procedure with lots of lookups, a number of them used more than once.

I tend to start procedures in a View and then...

Sorry, I did not make myself clear.

If I have the following code in a DTS SQL Task

DECLARE @ReturnStatus int

Exec @ReturnStatus = procZipFilePassword 'InFileNameAndPath', 'OutFileNameAndPath', 'MyPassword'

IF @ReturnStatus <> 0

I want to...

In Query Analyzer I am running the following code:

DECLARE @ReturnStatus int

Exec @ReturnStatus = procZipFilePassword 'C:\KnowledgeBase\Templates\CompanyPotentials.xls', 'C:\KnowledgeBase\WebTestFiles\CompaniesPotentialsNL','test'

In the Grids window below I get the following output.

WinZip(R) Command Line Support Add-On Version...

Oh joy, I now have IE6 and get a proper window to type in.

I wonder whether automated emails works when other...

Thanks Frank but I was looking for the command which I could add to the end of the EXEC statement which would suppress the messages in the Query Analyzer grid.

Thanks for the info, I am always reluctant to upgrade anything in the office because it is guaranteed to break something else. Spoken to our techies and Internet Explorer 6...

I am using Internet Explorer 5.50. And I did not get notification of your reply