Viewing 15 posts - 76 through 90 (of 134 total)
Brilliant I think we both got there at the same time.
It works now
- thanks for your help.
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
April 24, 2013 at 7:36 am
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...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
April 9, 2013 at 5:29 am
Unfortunately - you will need to create views to reflect the field names atht you require.
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
April 8, 2013 at 7:58 am
Another option might be to use SSIS and craete an update package ?!
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
April 8, 2013 at 6:02 am
Can you display the code you are trying to use ?
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
April 8, 2013 at 6:00 am
Do you have an example of what you are trying to acheive ?
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
April 8, 2013 at 5:58 am
Ahh right - glad you're sorted.
I too am running Syspro - version 6.1 SP1 - without any issues.... so far 🙂
Regards
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
February 17, 2013 at 12:55 pm
Hi - Are you still having problems with your Syspro - SQL validation ?
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
February 15, 2013 at 6:36 am
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...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
February 15, 2013 at 3:20 am
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 ......
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
January 29, 2013 at 9:35 am
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...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
January 29, 2013 at 9:15 am
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...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
January 29, 2013 at 9:11 am
Just to keep the post live - I have answered my own question already.
DECLARE @CurrentLogon Char(50)
Set @CurrentLogon = SUSER_SNAME()
SELECT SUSER_SNAME()
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
January 29, 2013 at 2:48 am
Sean Lange (1/28/2013)
SteveEClarke (1/28/2013)
Using the DELETED table as the before data.
New Trigger;
ALTER TRIGGER [dbo].[trgGenMasterUpdate]
...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
January 29, 2013 at 1:43 am
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 ...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
January 28, 2013 at 2:00 pm
Viewing 15 posts - 76 through 90 (of 134 total)