Viewing 2 posts - 16 through 17 (of 17 total)
Select ID
FROM Table
Where IACID IN (1,2,5)
AND IExpID >=12
April 21, 2004 at 3:02 am
#503605
You could declare a variable and set it to the result of the function....
DECLARE @formula
SELECT @formula = dbo.returnformula('tot_hra')
EXEC ('SELECT ' + @formula + ' from <view1><view2> ' )
Thanks!
A
April 16, 2004 at 4:00 am
#503084