Select Images For Cover For a Album **********************

----------------------------------------------------------------------
CREATE proc select_allImagesforAlbumCover          
as          
         
select AlbumName,AlbumMaster.AlbumMasterID,    
(select count(ImageID) from  ImageMaster where albummasterid=AlbumMaster.AlbumMasterID and isactive=1) as TotalImage,        
(select top 1 ImageUrl from  ImageMaster where albummasterid=AlbumMaster.AlbumMasterID and isactive=1) as ImageUrl
from AlbumMaster