var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Tried to Solve a Problem and i got bit
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?
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.
just too tired
thanks for the in-depth help