USP_USERSETTINGSSEARCHLISTTASKHISTORY_GETLIST

create procedure dbo.USP_USERSETTINGSSEARCHLISTTASKHISTORY_GETLIST(@APPUSERID uniqueidentifier)
as
begin

    select USERSETTINGSSEARCHLISTTASKHISTORY.ID,
        SEARCHLISTCATALOG.NAME,
        USERSETTINGSSEARCHLISTTASKHISTORY.SEARCHLISTCATALOGID,
        USERSETTINGSSEARCHLISTTASKHISTORY.TASKCATALOGID
    from dbo.USERSETTINGSSEARCHLISTTASKHISTORY
    inner join dbo.SEARCHLISTCATALOG on USERSETTINGSSEARCHLISTTASKHISTORY.SEARCHLISTCATALOGID = SEARCHLISTCATALOG.ID
    where USERSETTINGSSEARCHLISTTASKHISTORY.APPUSERID = @APPUSERID 
    order by USERSETTINGSSEARCHLISTTASKHISTORY.DATECHANGED desc;

end