Thanks
Interesting, "m." prefix looks better :-)


>>Hi
>>
>>All these @ are really needed at the begining of variables?
>
>I'm not Rodman, but I can answer the question as it pertains to T-SQL in SQL Server. Yep, they are. Additionally, @@ is used to identify global variables (system functions).
>
>>
>>>Walter,
>>> This problem is actually easy to solve in SQL Server 2000. SQL Server 2000 now has UDF's which can be recursive.
>>>
>>>Here's a UDF from www.foxforum.com that retrieves a message's depth (how low in the tree is the message)
>>>
>>>
>>>
>>>ALTER function forum_get_message_depth
>>>(@messageid as int, @intCurrentDepth as int)
>>>Returns int
>>>as
>>>
>>>BEGIN
>>>
>>>DECLARE @intParentID INT
>>>SELECT @intParentID = parentid
>>> FROM messages where messageid = @messageid
>>>
>>>DECLARE @intRetVal INT
>>>SET @intRetVal = 0
>>>
>>>SET @intCurrentDepth = @intCurrentDepth + 1
>>>
>>>If @intParentID = 0
>>> SET @intRetVal = @intCurrentDepth
>>>Else
>>> BEGIN
>>> SET @intRetVal = dbo.forum_get_message_depth(@intParentID, @intCurrentDepth)
>>> END
>>>
>>>Return @intRetVal
>>>END
>>>
>>>Rodman