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)
Returns table
as
Return (select item, Result=(value * value) from tba
where item = @item)
GO

select dbo.Fitem(1)

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?

Well, for starters you do not need to preface table functions with the owner; just scalar functions.

Also, I believe you need a BEGIN and END statement in your function definition.

And yes, your syntax is off. Check Books Online for structure and examples.

got it
just too tired
thanks for the in-depth help