Viewing 8 posts - 1 through 8 (of 8 total)
Hey guys, Thanks for all the help. It turned out great!
August 24, 2009 at 1:00 am
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...
August 20, 2009 at 2:38 pm
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...
August 20, 2009 at 1:08 pm
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...
August 20, 2009 at 12:50 pm
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...
June 30, 2006 at 7:24 am
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
June 30, 2006 at 3:16 am
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...
June 29, 2006 at 3:00 am
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...
June 29, 2006 at 1:19 am
Viewing 8 posts - 1 through 8 (of 8 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy