Can someone help with the following please.
3 tables BudgetCategory, Budget and BudgetHolder in a Grandfather, Father child hierarchy
BudgetCategory - CategoryID, CategoryDesc
Budget - CategoryID, BudgetID, BudgetDesc
BudgetHolder - BudgetID, StaffName
If I delete a BudgetCategory record, I need to also delete all related Budget records and all BudgetHolder record related to each deleted Budget record.
How do I do this in T-SQL. Should I be using a trigger. If so what should I code.
Thanks for any help.