texpic (8/5/2012)
New error now, "Msg 530, Level 16, State 1, Line 12 The statement terminated. The maximum recursion 100 has been exhausted before statement completion."
use MAXRECURSION hint.
check this out:
http://msdn.microsoft.com/en-us/library/ms186243(v=SQL.105).aspx
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm: