Brilliant I think we both got there at the same time.

It works now

- thanks for your help.

This is correct - additional columns were added for 2012 version.

If you are creating Temp Tables - then they will need to be revisited for the results set to be...

Unfortunately - you will need to create views to reflect the field names atht you require.

Another option might be to use SSIS and craete an update package ?!

Can you display the code you are trying to use ?

Do you have an example of what you are trying to acheive ?

Ahh right - glad you're sorted.

I too am running Syspro - version 6.1 SP1 - without any issues.... so far 🙂

Regards

Hi - Are you still having problems with your Syspro - SQL validation ?

What do you expect to see in the result set ?

Do you want to display records that are contained in the "IN" clause - and then display records that are...

Thanks -

Yes unfortunately the ERP system does, Inventory, Customer, Suppliers, but not LEDGER chanegs - which is a blackhole - so I have just replicated that they do and ......

as an aside - I have checked the "Main Audit" table - which contains over 200 fields and have 275,000 records over the 3 years of using the system, which...

I see where you are coming from - honestly do appreciate your input.

However, we currently have this style of "audit table" setup from our ERP system, so I am in...

Just to keep the post live - I have answered my own question already.

DECLARE @CurrentLogon Char(50)

Set @CurrentLogon = SUSER_SNAME()

SELECT SUSER_SNAME()

Sean Lange (1/28/2013)

---

SteveEClarke (1/28/2013)

---

I have managed to answer my own question - through a little digging -

Using the DELETED table as the before data.

New Trigger;

ALTER TRIGGER [dbo].[trgGenMasterUpdate]

...

I have managed to answer my own question - through a little digging -

Using the DELETED table as the before data.

New Trigger;

ALTER TRIGGER [dbo].[trgGenMasterUpdate]

ON ...