USP_DATALIST_OLAPDATASOURCES

CREATE procedure dbo.USP_DATALIST_OLAPDATASOURCES

as

set nocount on;

select 
ODS.ID,
ODS.SOURCENAME,
ODS.SOURCEDESCRIPTION,
COALESCE(CAT.DESCRIPTION,'') AS CATEGORY,
CAST(COALESCE(CASE WHEN ODS.ETLJOBNAME <> '' THEN 1 ELSE 0 END,0) AS BIT) AS HASETLJOBNAME
/*
,
ODS.CONNECTIONSTRING,
ODS.IMPERSONATE,
ODS.IMPERSONATEUSERNAME
*/

,ISOLAP


from dbo.OLAPDATASOURCE AS ODS

LEFT JOIN dbo.OLAPDATASOURCECATEGORYCODE AS CAT

ON ODS.OLAPDATASOURCECATEGORYCODEID=CAT.ID

ORDER BY ODS.SOURCENAME;