Here is the trigger. When I reviewed this, I concluded that each of the 4 rows would have been updated, therefore the additional message would have 4 affected rather...

When I turn on Include Actual Execution Plan, I get;

(4 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

There is an update trigger:

But is suggests...

I used the round function on the INVOICE column for the group and all is well.

Thanks for the support,

Bill

The invoice column is FLOAT (Not NULL).

And it is the culprit.

When I group by INVOICE, I two rows. The following query:

SELECT DISTINCT

--INV_ACCT_ID

--,LINE_ITEM_NAME

--,ACTIVITY_ID

--,COMMITTED_FUND_ID

--,SUPPLIER

--,OWNER

--,

INVOICE

--,

--SUM(committed_fund) AS COMMITTED_FUND

FROM details

where committed_fund_id = 26515

GROUP...

The activity_id is the same for all detail rows (and besides I need it).

This grouping work for all other detail records - all but this Committed fund. @!$@%!##

Thanks for looking...

Thanks for your followup.

I am using an application: Aprimo Marketing

I contains a feature to store 'touches' for a customer (email, web form, etc.) That feature creates a custom...

Thank you all for the replies.

Situation resolved.

I was able combine two int fields cast as varchar then cast again as int to use as the unique id.

Bill

Thank you all for the replies.

Situation resolved.

I was able combine two int fields cast as varchar then cast again as int to use as the unique id.

Bill

Thanks.

I appreciate the help.

Additonal information...

I increased the timeout value fro both instances.  Tourns out to be a network problem after all.

Thanks,

Bill

Thanks for the reply.

My laptop used to have sql express.  The despktop and the laptop could each connect.  It is only since I installed sql 2005 DEV version that I...

Thank you all for the solution.  It was just what I needed!!

Thanks, again,

Bill

When given date range A as 9/1/2006 - 9/30/2006

and date range B as 8/20/06 - 9/5/06

The result would be 5  :  days 9/1, 9/2, 9/3, 9/4 and 9/5 exist in...

I need to know the number of a days for a given week a task is secheduled.

A 5 day task starts on Friday.

Given a week period, the task start and total...

Thank you all for you replies,

Bill