Hey guys, Thanks for all the help. It turned out great!

thanx guys, I'll play a bit and see what I get - just got an error because when I cast the date it changes the format from yyyy-mm-dd hh:mm:ss to...

Thanx again Bob -

in the first article ...

EXEC sp_executesql @sSQL, N'@_Product int, @_OrderID int, @_TransactionType char(1), @_Qty int',

@_Product = @product, @_OrderID = @OrderID, @_TransactionType = @TransactionType,...

Thanx Bob - I'll check that out now ...

If I use

@mySqlStrOrg

in the select

sql says

Line 90: Incorrect syntax near '@mySqlStrOrg'.

if I use

+ @mySqlStrOrg

in the select it...

Thanks again Jeff !

as you may have guessed this is for the admin gui of an application. the estimated usage which could activate the triggers is arounf 0.63% ... approx...

Thank you Jeff !!

I see that I've got a bit to learn, I understand - but I don't understand. Guess I just need to keep moving forward

Thanks Harsh,

That helped! but only a bit ... now it runs without errors.

assume: 1 row to affect in departmentunit, 3 rows in team, 20 rows in person

before:

update departmentunit -1 row...

Thanks Jeff, sorry for the delay - was out of town.

ok, so we have departmentunit, team, and person in that heirarchy from top to bottom ... triggers on departmentunit and...