help with a trigger of formula

Gordon Hughes
Gordon Hughes used Ask the Experts™
on
I have an application that uses MSSQl
I have created a column in the database
I want to update this column when data exists in another table
I created a trigger which seemed to work but then it caused an issue when trying to run a procedure
so I thought maybe I could modify the column to include some formula to, like "if isnull ([wo.draw]) then 'No' else 'Yes'"
but that does nothing
Any ideas?
Gordon
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Vitor MontalvãoIT Engineer
Distinguished Expert 2017

Commented:
I created a trigger which seemed to work but then it caused an issue when trying to run a procedure
Can you post the trigger code? And what's the issue? There's any error message that you can share with us?
Gordon HughesDirector

Author

Commented:
Think I have solved it
Jason clarkDBA Freelancer

Commented:
Please share the code if you exactly need a help.
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Director
Commented:
Hi
I managed to solve this issue, I re-wrote the trigger and all is now working
Gordon
Top Expert 2012

Commented:
Either post the code or request the thread be deleted.  As it stands it is of no use to anyone.
Gordon HughesDirector

Author

Commented:
Re-wrote the trigger

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial