SET IDENTITY_INSERT dbo.tblTransactions ON - that worked... thanks!

tried and get: Msg 1088, Level 16, State 11, Line 1

Cannot find the object "tblTransactions" because it does not exist or you do not have permissions.

One additional question... my receiving table has its primary key with "Is Identity" being "Yes" and and a seed of 18000 incremented by one... the number of records (historical data)...

Thanks... worked!

The trigger is reliably setting [Transfered] = 'True' if the condition of the INSERTED Transaction type is 'Transfer', but I want it to update not the INSERTED record but a...

Thanks... your idea worked of thr UNION All and one trigger!.... my misstake was I has not deleted my original query which was still firing producing that dupe record.... many...

None of these have a possibility of being NULL: INSERTED.PO_Number + INSERTED.AppUser + INSERTED.SoftwareShortName + INSERTED.HeatTicketNumber,

None of the values are integers...

I'd have expected that a seperator would be used between...

I had originally hoped to do just that with one trigger... but the trigger needs to create two records. I put the complete SQL below in and actually get THREE...

Both the PO_Number and HeatTicketNumber are already Varchar as the table datatype... so (?) no need for conversion (?)...

I ran the code above and now have a SQL error popping...

In general it seems to not like something else that keeps popping up:

Msg 102, Level 15, State 1, Procedure trPopulateJournalEntries, Line 11

Incorrect syntax near '('.

A little outside my experience... I open cmd and see "Administrator: C:\WINDOWS\system32\cmd.exe" as the header of my command prompt... not sure what and where to type in my command...

OK Got it working... may not be pretty, but thoroughly tested and it is decrementing the Quantity_Remaing from tblBulkPurchases!

Thanks all, I learned a lot about virtual tables that I...

Did I get the data you needed or other information for the testing? Just can't seem to find what could be wrong with this trigger...

CREATE TRIGGER [dbo].[trDecrementBulkPurchases]

ON [dbo].[tblTransactions]

AFTER INSERT

AS

BEGIN

UPDATE tblBulkPurchases

SET...

It's a matter of timing - bulk purchases of software are handled in one transaction within the tblTransactions and may linger in inventory possibly for weeks before before each is...

The trigger that is fired upon inserting data to tblTransactions will also populate the table tblBulkPurchases:

USE [TrackIT]

GO

CREATE TRIGGER [dbo].[trPopulateBulkPurchases]

ON [dbo].[tblTransactions]

AFTER INSERT

AS

BEGIN

INSERT INTO tblBulkPurchases

(tblBulkPurchases.PO_Number,

tblBulkPurchases.Buyer_Initial,

tblBulkPurchases.Quantity,

tblBulkPurchases.Transaction_Number,

tblBulkPurchases.Quantity_Remaining,

tblBulkPurchases.Unit_Price,

tblBulkPurchases.Software_Description,

...