How to call a scalar function in a stored procedure
Posted
by Luke101
on Stack Overflow
See other posts from Stack Overflow
or by Luke101
Published on 2010-04-20T16:58:35Z
Indexed on
2010/04/20
17:03 UTC
Read the original article
Hit count: 373
Filed under:
sql-server-2008
I am wacking y head over the problem with this code.
DECLARE @root hierarchyid
declare @lastchild hierarchyid
SELECT @root = NodeHierarchyID from NodeHierarchy where ID = 1
set @lastchild = getlastchild(@root)
it says it does not recognize getlastchild function. What am I doing wrong here
© Stack Overflow or respective owner
