I was working on the thread "Call stored procedure within SELECT statement "
but a funny thing happend
i was going to suggest using a function instead of a proc but i cant seem to get it to run
create function dbo.Fitem(@item int)
Return (select item, Result=(value * value) from tba
where item = @item)
then i get this
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.Fitem'
am i just too tired or what?