thanks, I tried that already, doesn't work...

thanks for that tip! and I have actually solved it so I no longer need assistance

ok, I've figured it out:

SELECT  rm.rmsacctnum AS [Rms Acct Num],

            SUM(rf.rmstranamt) AS [TranSum],

            SUM(rf10.rmstranamt10) AS [10Sum],

            SUM(rf10.rmstranamt10) - SUM(rf.rmstranamt) AS [Balance],

            cb.CurrentBalance

FROM...

>>>The only possible way this will give you any records is if the MAX() balance happens to occur on the MAX() date/time.

YES, this is exactly what I want. ...

Thanks very much for your explanations, they helped a TON.  Now, yes, it would have been nice if this 3rd party ERP system would have just kept the damn date...

>>>What are the datatypes of the 2 columns rmstrandte and rmstrantim ?

rmstrandte - numeric(8,0)    e.g. 20050512

rmstrantim - numeric(6,0)    e.g. 173025

Hit me on the head for this stupid question...

I want to compare CurrentBalance with the rmsbalance but the rmsbalance whose record in RFINANL is related to rf.RMSFILENUM = rm.RMSFILENUM and that we are pulling rmsbalance based on the...

Thanks a lot for the explanation Mr. or Ms. 500, appreciated.  I just posted my latest code which hopefully should cover that issue now that you addressed.

set

ANSI_NULLS ON

set

QUOTED_IDENTIFIER ON

go

ALTER

Trigger [IT_Restrict_AreaCodes]

ON

[dbo].[DialEmpty]

AFTER

so you're saying something like this

on inserted.dialemptyID = d.dialemptyId

if so, then can you explain how this is all interecting with the inserted table?

>>>It works, sure, but if ProjectID is not the unique identifier of DialEmpty, then that UPDATE will also hit rows that were not recently inserted. This in turn will become...

Mr. or Ms. 500, noeld's worked great by inner joining the inserted

it works fine.  Thanks for the additional syntax change help.

yea, there needs to be an inner join between table Project and table dialempty based on ProjectID.  Maybe you're doing it correctly based on the inserted ProjectID which is really...

yea, noticed that but I can't get into sql analyzer to run the stored proc to increase the connections