great, this worked a treat thanks.

Hi

i'm not sure where to carry out the test. I'm from a vb background, will there be some kind of

select stockcode from inserted

if stockcode like 'Y%' then

do something...

Brilliant. It works perfectly. Thanks for your help.

thanks Lowell

the link is really useful and has helped me understand how the linked server works but i'm now getting an error message saying :Data source name not found and...

thanks for all your replies.

my afternoon is now going to be checking out the link posted by opc.three on database mail. 🙂

for the subject to include date i went with...

great, thanks.

I see your point and def don't want to start rolling back transactions. Am i right in thinking that i don't need to worry about this in 2005 as...

hi,

just got my head around all of the responses.

so...It turns out i was running trigger to email on our test system which doesn't have the correct permissions to truncate the...

--truncate table EncoreCompanyT.dbo.InvNewStockode

--insert into EncoreCompanyT.dbo.InvNewStockode

--select StockCode, Description, LongDesc, Supplier, Buyer

--from INSERTED

EXEC msdb.dbo.sp_send_dbmail

@recipients = 'gfrewin@dddltd.co.uk',

@body = 'Please find the...

just stumbled across this thread. worked a treat thanks.

just re-tested and it works fine. Thanks for all your help.

ALTER TRIGGERdbo.trg_LotTransactions

ONEncoreCompanyT.dbo.LotTransactions

FOR INSERT

AS

SET NOCOUNT ON

UPDATEDL

SETStatusFlag = ' '

--SELECT *

FROMEncoreCompanyT.dbo.DataLots DL

JOIN(SelectLotJob, TrnQuantity * -1 as TrnQuantity

FromINSERTED --EncoreCompanyT.dbo.LotTransactions

WhereTrnValue < 0

AndTrnType = 'R') LT

ONLT.LotJob = DL.LotNumber

ANDLT.TrnQuantity...

Ok, after some meddling i've managed to get ....

UPDATE DL

SETStatusFlag = ' '

FROM EncoreCompanyT.dbo.DataLots DL

JOIN (SelectLotJob, TrnQuantity * -1 as TrnQuantity

FromEncoreCompanyT.dbo.LotTransactions

WhereTrnValue < 0

AndTrnType...

Hi

I have created the following from the posts below...

UPDATEEncoreCompanyT.dbo.DataLots

SETStatusFlag = ' '

WHEREStatusFlag <> ' '

ANDEXISTS

(

...

perfect, thanks ken. 🙂

thanks

I am now getting stuck into SSIS 🙂