[Rainbowportal-devel] =?iso-8859-1?Q?Discussion_SQL_script_is_wrong?=

[<if...@li...>]

Other errors in SQL script 1727=0D=0A=0D=0Alook at this piece:=0D=0A=0D=0A=
CREATE PROCEDURE rb_DiscussionGetTopLevelMessages=0D=0A(=0D=0A    @Module=
ID int=0D=0A)=0D=0AAS=0D=0A=0D=0ASELECT=0D=0A    ItemID,=0D=0A    Display=
Order,=0D=0A    LEFT(DisplayOrder, 23) AS Parent,    =0D=0A    (SELECT CO=
UNT(*) -1  FROM rb_Discussion Disc2 WHERE LEFT(Disc2.DisplayOrder,LEN(RTR=
IM(Disc.DisplayOrder))) =3D Disc.DisplayOrder) AS ChildCount,=0D=0A    Ti=
tle,  =0D=0A    CreatedByUser,=0D=0A    CreatedDate,=0D=0A    Body,=0D=0A=
    ViewCount,=0D=0A    (SELECT MAX(CreatedDate) FROM rb_Discussion Disc3=
 WHERE LEFT(Disc3.DisplayOrder, 23) =3D Disc.DisplayOrder)=0D=0A    AS Da=
teofLastReply=0D=0AFROM rb_Discussion Disc=0D=0AWHERE ModuleID=3D@ModuleI=
D=0D=0AAND (LEN( DisplayOrder ) / 23 ) =3D 1=0D=0A=0D=0AORDER BY=0D=0A   =
 DateofLastReply DESC=0D=0AGO=0D=0A=0D=0A-------------------------------=0D=
=0A=0D=0A"FROM rb_Discussion Disc" is wrong.=0D=0A=0D=0A-----------------=
--------------=0D=0A=0D=0AFede_