T-SQL stored procedure: Get parent class pictures

If there is no image in the current category, the parent image is obtained until the image is found.

Create procedure w_category_getimg
@ PCID int
As
Declare
@ Cache_pcid int,
@ Imgcount int
Begin
Set @ cache_pcid = @ PCID;
Set @ imgcount = (select count (*) from w_categoryphotos where PCID = @ cache_pcid)
If (@ imgcount> 0)
Begin
Select * From w_categoryphotos where PCID = @ cache_pcid
End
Else
Begin
While @ imgcount = 0
Begin
Set @ cache_pcid = (select parentid from w_productcategorys where PCID = @ cache_pcid );
Set @ imgcount = (select count (*) from w_categoryphotos where PCID = @ cache_pcid );
If (@ imgcount = 1)
Begin
Select * From w_categoryphotos where PCID = @ cache_pcid
Break;
End
End
End
End