USP_DATAFORMTEMPLATE_EDITLOADINFO_THIRDPARTYAUTH_APPUSER_MARKINACTIVE

create procedure [dbo].[USP_DATAFORMTEMPLATE_EDITLOADINFO_THIRDPARTYAUTH_APPUSER_MARKINACTIVE](@ID uniqueidentifier)
as
set nocount on;

select
  [APPUSER].[TSLONG],
  [APPUSER].[DISPLAYNAME],
  isnull([APPUSERTHIRDPARTYAUTH].[INACTIVEDETAILS], '') [DETAILS],
  [APPUSERCLAIMS].[NAMEIDENTIFIER] [CLAIMSNAMEIDENTIFIER]
from [dbo].[APPUSER]
left join [dbo].[APPUSERTHIRDPARTYAUTH] on [APPUSER].[ID] = [APPUSERTHIRDPARTYAUTH].[ID]
left join [dbo].[APPUSERCLAIMS] on [APPUSERCLAIMS].[APPUSERID] = [APPUSER].[ID]
where [APPUSER].[ID] = @ID;

return 0;