USP_DATALIST_VANITYURL

CREATE procedure dbo.USP_DATALIST_VANITYURL
    ( 
    @VANITYURL nvarchar(300) = null,    
    @CLIENTSITESID int = null
    )
as
    set nocount on;

    select 
       [ID], [REALMTYPEID], [CLIENTUSERID], [PAGEID], [VANITYURL], [TARGETURL], [CLIENTSITESID]
    from 
        dbo.VANITYURL
    where
    VANITYURL = ISNULL(@VANITYURL, VANITYURL)
    and ClientSitesID = ISNULL(@CLIENTSITESID, CLIENTSITESID)