1
CREATE PROCEDURE c_GetAllContentByChid
2
@Chid varchar(50)
3
AS
4
declare @str varchar(4000)
5
set @str=','+@Chid
6
while @@ROWCOUNT>0
7![](/Images/OutliningIndicators/None.gif)
8
select @str=@str+','+cast(ParentID as varchar(50)) from Tbl_ChannelInfo
9
where charindex(','+cast(Cid as varchar(50))+',',@str+',')>0
10
and charindex(','+cast(ParentID as varchar(50))+',',@str+',')=0
11![](/Images/OutliningIndicators/None.gif)
12
select a.ChannelTitle,b.* from Tbl_ContentInfo as b
13
inner join
14
(select * from Tbl_ChannelInfo where charindex(',{'+cast(Cid as varchar(50))+'},',@str+',')>0 ) as a
15
on b.ParentID=a.cid
16
GO
![](/Images/OutliningIndicators/None.gif)
2
![](/Images/OutliningIndicators/None.gif)
3
![](/Images/OutliningIndicators/None.gif)
4
![](/Images/OutliningIndicators/None.gif)
5
![](/Images/OutliningIndicators/None.gif)
6
![](/Images/OutliningIndicators/None.gif)
7
![](/Images/OutliningIndicators/None.gif)
8
![](/Images/OutliningIndicators/None.gif)
9
![](/Images/OutliningIndicators/None.gif)
10
![](/Images/OutliningIndicators/None.gif)
11
![](/Images/OutliningIndicators/None.gif)
12
![](/Images/OutliningIndicators/None.gif)
13
![](/Images/OutliningIndicators/None.gif)
14
![](/Images/OutliningIndicators/None.gif)
15
![](/Images/OutliningIndicators/None.gif)
16
![](/Images/OutliningIndicators/None.gif)