Viewing 2 posts - 1 through 2 (of 2 total)
Unfortunately, my example was not so well-defined. Actually, MyFunction receives column values as parameters.
update MyTable
set MyColA =
case
when MyColB = 1 then dbo.MyFunction(MyColC, MyColD) * 2
when MyColB = 4 then...
July 11, 2002 at 5:01 am
#432427
Thank you for your answers. I solved my problem with sp_grantdbaccess.
March 25, 2002 at 9:34 am
#426028