USP_SIMPLEDATALIST_GETMETADATA_TSLONG

CREATE procedure [dbo].[USP_SIMPLEDATALIST_GETMETADATA_TSLONG](@ID uniqueidentifier)
as begin

    set nocount on;

    select 

    SDLC.TSLONG,
    TFC.TSLONG AS TRANSLATION_TSLONG

    from dbo.SIMPLEDATALISTCATALOG AS SDLC
        left outer join dbo.TRANSLATIONFUNCTIONCATALOG AS TFC 
        on     SDLC.TRANSLATIONFUNCTIONCATALOGID = TFC.ID

    where SDLC.ID = @ID;

    return 0;

end