Search results for query: *

I have an application that relays emails to the Exchange Server the application has a string in its preferences to input a user and password for authentication when i enter a user and attempt to send a message the log shows "454 5.7.3 Client does not have permission to submit mail to this...

I have an application that requires me to set my Exchange 2003 server to 'Basic Authentication' with the 'Anonymous Access' checked. What are the ramifications of setting the security in this fashion?

I have written a query and tried to export it to a CSV file but query analyzer dosn't put in the header column, tried to run query through excel but it didn't like my cast statement. Tried through export wizard but it didn't like my multiple alias. Tried to save to file but the format wasn't...

I have a memo field that contains a bunch of text that has an obnoxious header and footer that vary in length for each entry. EG This case was resolved by Darren Louie on 7/22/04 12:15 PM as follows: 1. Disabled Orderdesk. No more ODBC error. 2. Deleted AMGR. Settings now saving. 3. Looks like...

I am querying an index table and I would like the case to accomodate where no record exists in the table. Here is my query so far. select isBP = case when uf.code_id = 19 then (Select 'BP') when uf.code_id is Null then (select 'Null') when uf.code_id <> 19 then (select 'Not BP') end...

I have a details section that has a suppression formula in it. If the suppression cancels all rows from showing for a particular group the group header still shows because there are records there, they are just supressed. How can I count the number of displayed (non suppressed) records so I can...

I have a report that returns notes in the details section. But only the notes that are type 9 and have the text 'escalated' in the note. This works. Sometimes more than one note is returned to the report per group. In this case I want to select the note in that group that has the lowest...

I have a report with a group on opportunity ID then in the details i have the notes for that opportunity. I want a running total that counts the Opportunity Id but only when that opportunity is won (status 3). So I make a running total with the following evaluate criteria (opp_status = 3). The...

I am trying to write a formula that accepts a date parameter and returns the days of that week sunday to monday. For example today is Wednesday the 25, that would be my parameter. the result would return 7 dates starting with the 23rd to the 29th. But i have no idea where to start.