USP_FILES_URLSFORSITE

Parameters

Parameter	Parameter Type	Mode	Description
@CLIENTSITESID	int	IN

Definition

Copy



create procedure dbo.USP_FILES_URLSFORSITE(@CLIENTSITESID int)
as
begin
    select ID, URL
    from dbo.[DOCUPLOADFILES]
    where         
        ClientSitesID = @CLIENTSITESID and 
        URL is not null
    order by URL;
end