Can anybody suggest where to look - it happens on an out of the box SQL 2008 as well

Codepage is Latin1_General_CI_AS

everything else seems pretty standard

ohack

@@textsize comes back at 2M+

Setting text size has no effect.

Ten Centuries

Thank you so much for spending the time to look and solve this problem for me.

Please do not think my comment was inappropriate. I was actually pointing out that...

Ten Centuries

Thank you for pointing out the error of my ways. It is rude of me to assume that others have time to spend on other peoples problems. I now...

I think i am getting stuck in a loop

ALTER FUNCTION [dbo].[GetEmptyNodes](@ThisSectionID int) Returns int

AS

BEGIN

DECLARE @TmpTree TABLE (SectionID int ,TreeLevel int)

DECLARE @level int

DECLARE @Result int

SET @level = 0

SET @Result =...

I have made some progress, but its a dirty.

I have created a function that looks up all the child nodes to the current node, then checks for data in those...

Sorry I did post with spaces but they got removed

Parent1

.....Node1

......Data

.....Node2

......Data

.....Node3

.......Node4

.......Node5

.........Data