According to the accountants, the net income for a period would appear on a balance sheet under Owner's Equity, with an Account such as "Current Period Net Income/Loss". If...

Are you looking for something like this?

SELECT

A = CASE

WHEN B IN (1,2,3) THEN 1

ELSE 0

...

Found at least a partial solution. Adding "Integrated Security=SSPI" to the connection string in the app brought the timing down from 5 to 1 second on the inner queries....

I tried that this afternoon and it improved performance but still was not as fast as the SA login. It';s the oddest thing I've ever seen and was convinced...

Nope; it's set to None.

Very simple queries, they just return 1 column from a single table.

And I assume all your servers are not on SA then either. I think attempting to write your own Fuzzy logic willbe a daunting task; the MS version is...

Are you saying you're currently running Fuzzy Groupings now in SQL 2008 on a server that is not Enterprise? This is an Enterprise only (except Developer) feature.

I think the issue you're having is that SSRS evaluates the entire expression prior to doing the comparsions, so you'll always be dividing by zero. I wrote custome code...

Are you clicking on "My Subscriptions" or viewing them from the report itself?

Only reason I caught it was I spent the last week writing these as part of an ETL load 😉

If you're going to use the ROW_NUMBER function to list the duplicates, you'll probable need a ORDER BY in the OVER clause as well.

Have you configured the Mail Session on the Agent? You'll also need to restart the Agent in order for the changes to take effect.

SSRS should wrap the fields in quotes prior to a CSV export. I have data with commas in it and never had an issue with CSV exports for these.

That is exactly my thought and funny you should bring it up. We are tracking phone calls made by customers to a business and where the call was made...