My 2bits. Every table I ever create has as its first column "UID" which is an idenity column and is set a primary key.

In the very rare circumstance when I...

What I don't know never ceases to amaze me.

Thanks Hanslindgren, If I understand correctly this is what I have been looking for.  Most of my transactions are the type where...

Looks like its essentialy the same as win03. don't you require authentication on your smtp server? Gotta fight spam ya know

Adding (vbscript):

objMessage.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate")...

Well I went the route David Scotland went, since I already have an aspEmail componant installed on that server, I just use it.

I was not excited about installing outlook on...

From outlook it works fine. I resolved this by simply using sp_OACreateObject and an already installed smtp email componant. Sure is allot less hassle. Permission aside

Thanks grasshopper that seems like the easiest way. Unless issueing the rollback/committ stops the proc then wouldn't I also need something like:

insert statement ....

If @@ERROR 0

...

Well I havn't run any performance audits, but for the most part it's save a form and deliver a list sort of activities. Not a whole lot of analysis going...

ya as soon as I started to update the proc my brain turned back on

Thanks again,

dave

OK after playing around with it a few times I think i have it. I actually need two variables.

declare @DidItError int

declare @AnyErrors bit

insert statement ....

set @DidItError = @@error

if @DidItError ...

Are the data collection points all in different time zones? and being sent to a seperate sql location in yet another time zone?

If so then you'll need some identifer from...

What format is the timezone in? Is it simply an offset from UTC?

"tiwjt" Is this a typo or perhaps is a formt I'm unfamiliar with.

yup the performance issues made it a no go on running the cursor in the trigger to call this proc..loop within a loop, was causing the remote bulk insert...

Thankyou, Your first comment solved the main cofusion for me. Knowing that the trigger fires for the statement rather then for each row makes a difference.  Although it's not reccomended I have a felling...

Um without created those tables and trying it on mine. Wouldn't you:

SELECT     dbo.detailtable.stockID, dbo.detailtable.purchasenumber, MAX(dbo.detailtable.quantity) AS Expr1

FROM         dbo.detailtable INNER JOIN

                      dbo.mastertable ON dbo.detailtable.stockID = dbo.mastertable.stockID AND dbo.detailtable.purchasenumber = dbo.mastertable.PurchaseNum

GROUP BY...

Yup thanks, I was moving my code from T-sql into the script portion and realized my brain fart...thanks

dave