Tüm bağlantılar
select * from 
(
			select  
					distinct
					l.Name as 'Kutuphane',
					p.Name as 'SurecAdi',
					SurecVeri.Ent.value('(./@Function)[1]','nvarchar(max)') as Adı,
					'BAPI' as Tipi
			from    wflProcesses p inner  join
					wflLibraries l on l.Id=p.Library inner join
					wflProcessVersions pv on pv.Id=p.CurrentVersion cross apply
					pv.Graph.nodes('//BAPI') as SurecVeri(Ent)
			UNION ALL

			select  
			distinct
			l.Name as 'Kutuphane',
			p.Name as 'SurecAdi',
			WebVeri.Ent.value('(./@Url)[1]','nvarchar(max)') as Adı,
			'WebInvokeNS' as Tipi

			from    wflProcesses p inner  join
				wflLibraries l on l.Id=p.Library inner join
				wflProcessVersions pv on pv.Id=p.CurrentVersion cross apply
				pv.Graph.nodes('//WebInvokeNS') as WebVeri(Ent)
			UNION ALL

			select  
			distinct
			l.Name as 'Kutuphane',
			p.Name as 'SurecAdi',
			Web2Veri.Ent.value('(./@Url)[1]','nvarchar(max)') as Adı,
			'WebInvoke' as Tipi

	from    wflProcesses p inner  join
			wflLibraries l on l.Id=p.Library inner join
			wflProcessVersions pv on pv.Id=p.CurrentVersion cross apply
			pv.Graph.nodes('//WebInvoke') as Web2Veri(Ent) 

	UNION ALL

			select  
			distinct
			l.Name as 'Kutuphane',
			p.Name as 'SurecAdi',
			Web2Veri.Ent.value('(./@Connection)[1]','nvarchar(max)') as Adı,
			'SqlSelect' as Tipi

	from    wflProcesses p inner  join
			wflLibraries l on l.Id=p.Library inner join
			wflProcessVersions pv on pv.Id=p.CurrentVersion cross apply
			pv.Graph.nodes('//SqlSelect') as Web2Veri(Ent) 
	UNION ALL

			select  
			distinct
			l.Name as 'Kutuphane',
			p.Name as 'SurecAdi',
			Web2Veri.Ent.value('(./@Connection)[1]','nvarchar(max)') as Adı,
			'SqlExec' as Tipi

	from    wflProcesses p inner  join
			wflLibraries l on l.Id=p.Library inner join
			wflProcessVersions pv on pv.Id=p.CurrentVersion cross apply
			pv.Graph.nodes('//SqlExec') as Web2Veri(Ent) 
	UNION ALL

			select  
			distinct
			l.Name as 'Kutuphane',
			p.Name as 'SurecAdi',
			Web2Veri.Ent.value('(./@Connection)[1]','nvarchar(max)') as Adı,
			'SqlInsert' as Tipi

	from    wflProcesses p inner  join
			wflLibraries l on l.Id=p.Library inner join
			wflProcessVersions pv on pv.Id=p.CurrentVersion cross apply
			pv.Graph.nodes('//SqlInsert') as Web2Veri(Ent) 
	UNION ALL

			select  
			distinct
			l.Name as 'Kutuphane',
			p.Name as 'SurecAdi',
			Web2Veri.Ent.value('(./@Connection)[1]','nvarchar(max)') as Adı,
			'SqlUpdate' as Tipi

	from    wflProcesses p inner  join
			wflLibraries l on l.Id=p.Library inner join
			wflProcessVersions pv on pv.Id=p.CurrentVersion cross apply
			pv.Graph.nodes('//SqlUpdate') as Web2Veri(Ent) 

) as Temp order by 1,2
Tüm bağlantılar
select * from
(
    select 
            distinct
            l.Name as 'Kutuphane',
            p.Name as 'SurecAdi',
            SurecVeri.Ent.value('(./@Function)[1]','nvarchar(max)') as Adı,
            'BAPI' as Tipi
    from  wflProcesses p 
		inner  join wflLibraries l on l.Id=p.Library 
		inner join (select Id,Process,TestMode,Convert(XML,Graph) Graph,Version,CreateDate,LastUpdate,Description from wflProcessVersions )pv on pv.Id=p.CurrentVersion 
		cross apply pv.Graph.nodes('//BAPI') as SurecVeri(Ent)

    UNION ALL
 
    select 
			distinct
			l.Name as 'Kutuphane',
			p.Name as 'SurecAdi',
			WebVeri.Ent.value('(./@Url)[1]','nvarchar(max)') as Adı,
			'WebInvokeNS' as Tipi
 
    from wflProcesses p 
		inner  join wflLibraries l on l.Id=p.Library 
		inner join (select Id,Process,TestMode,Convert(XML,Graph) Graph,Version,CreateDate,LastUpdate,Description from wflProcessVersions )pv on pv.Id=p.CurrentVersion 
		cross apply pv.Graph.nodes('//WebInvokeNS') as WebVeri(Ent)

    UNION ALL
 
    select 
			distinct
			l.Name as 'Kutuphane',
			p.Name as 'SurecAdi',
			Web2Veri.Ent.value('(./@Url)[1]','nvarchar(max)') as Adı,
			'WebInvoke' as Tipi
 
    from    wflProcesses p 
		inner  join wflLibraries l on l.Id=p.Library 
		inner join (select Id,Process,TestMode,Convert(XML,Graph) Graph,Version,CreateDate,LastUpdate,Description from wflProcessVersions )pv on pv.Id=p.CurrentVersion 
		cross apply pv.Graph.nodes('//WebInvoke') as Web2Veri(Ent)
 
    UNION ALL
 
            select 
            distinct
            l.Name as 'Kutuphane',
            p.Name as 'SurecAdi',
            Web2Veri.Ent.value('(./@Connection)[1]','nvarchar(max)') as Adı,
            'SqlSelect' as Tipi
 
    from    wflProcesses p 
		inner join wflLibraries l on l.Id=p.Library 
		inner join (select Id,Process,TestMode,Convert(XML,Graph) Graph,Version,CreateDate,LastUpdate,Description from wflProcessVersions )pv on pv.Id=p.CurrentVersion 
		cross apply pv.Graph.nodes('//SqlSelect') as Web2Veri(Ent)

    UNION ALL
 
            select 
            distinct
            l.Name as 'Kutuphane',
            p.Name as 'SurecAdi',
            Web2Veri.Ent.value('(./@Connection)[1]','nvarchar(max)') as Adı,
            'SqlExec' as Tipi
 
    from    wflProcesses p 
		inner join wflLibraries l on l.Id=p.Library 
		inner join (select Id,Process,TestMode,Convert(XML,Graph) Graph,Version,CreateDate,LastUpdate,Description from wflProcessVersions )pv on pv.Id=p.CurrentVersion 
		cross apply pv.Graph.nodes('//SqlExec') as Web2Veri(Ent)

    UNION ALL
 
            select 
            distinct
            l.Name as 'Kutuphane',
            p.Name as 'SurecAdi',
            Web2Veri.Ent.value('(./@Connection)[1]','nvarchar(max)') as Adı,
            'SqlInsert' as Tipi
 
    from    wflProcesses p 
		inner join wflLibraries l on l.Id=p.Library 
		inner join (select Id,Process,TestMode,Convert(XML,Graph) Graph,Version,CreateDate,LastUpdate,Description from wflProcessVersions )pv on pv.Id=p.CurrentVersion 
		cross apply pv.Graph.nodes('//SqlInsert') as Web2Veri(Ent)

    UNION ALL
 
            select 
            distinct
            l.Name as 'Kutuphane',
            p.Name as 'SurecAdi',
            Web2Veri.Ent.value('(./@Connection)[1]','nvarchar(max)') as Adı,
            'SqlUpdate' as Tipi
 
    from    wflProcesses p 
	inner join wflLibraries l on l.Id=p.Library 
	inner join (select Id,Process,TestMode,Convert(XML,Graph) Graph,Version,CreateDate,LastUpdate,Description from wflProcessVersions )pv on pv.Id=p.CurrentVersion 
	cross apply pv.Graph.nodes('//SqlUpdate') as Web2Veri(Ent)
 
) as Temp order by 1,2
RFC çağıran süreçlerin listesini getiren sorgu
select * from
(
            select 
                    distinct
                    l.Name as 'Kutuphane',
                    p.Name as 'SurecAdi',
                    SurecVeri.Ent.value('(./@Function)[1]','nvarchar(max)') as Adı,
                    'BAPI' as Tipi
            from    wflProcesses p inner  join
                    wflLibraries l on l.Id=p.Library inner join
                    (select Id, Process,TestMode, convert(xml,Graph) as Graph, Version, CreateDate, LastUpdate, Description from wflProcessVersions) pv on pv.Id=p.CurrentVersion cross apply
                    pv.Graph.nodes('//BAPI') as SurecVeri(Ent)
            UNION ALL
 
            select 
            distinct
            l.Name as 'Kutuphane',
            p.Name as 'SurecAdi',
            WebVeri.Ent.value('(./@Url)[1]','nvarchar(max)') as Adı,
            'WebInvokeNS' as Tipi
 
            from    wflProcesses p inner  join
                wflLibraries l on l.Id=p.Library inner join
                (select Id, Process,TestMode, convert(xml,Graph) as Graph, Version, CreateDate, LastUpdate, Description from wflProcessVersions) pv on pv.Id=p.CurrentVersion cross apply
                pv.Graph.nodes('//WebInvokeNS') as WebVeri(Ent)
            UNION ALL
 
            select 
            distinct
            l.Name as 'Kutuphane',
            p.Name as 'SurecAdi',
            Web2Veri.Ent.value('(./@Url)[1]','nvarchar(max)') as Adı,
            'WebInvoke' as Tipi
 
    from    wflProcesses p inner  join
            wflLibraries l on l.Id=p.Library inner join
            (select Id, Process,TestMode, convert(xml,Graph) as Graph, Version, CreateDate, LastUpdate, Description from wflProcessVersions) pv on pv.Id=p.CurrentVersion cross apply
            pv.Graph.nodes('//WebInvoke') as Web2Veri(Ent)
 
    UNION ALL
 
            select 
            distinct
            l.Name as 'Kutuphane',
            p.Name as 'SurecAdi',
            Web2Veri.Ent.value('(./@Connection)[1]','nvarchar(max)') as Adı,
            'SqlSelect' as Tipi
 
    from    wflProcesses p inner  join
            wflLibraries l on l.Id=p.Library inner join
            (select Id, Process,TestMode, convert(xml,Graph) as Graph, Version, CreateDate, LastUpdate, Description from wflProcessVersions) pv on pv.Id=p.CurrentVersion cross apply
            pv.Graph.nodes('//SqlSelect') as Web2Veri(Ent)
    UNION ALL
 
            select 
            distinct
            l.Name as 'Kutuphane',
            p.Name as 'SurecAdi',
            Web2Veri.Ent.value('(./@Connection)[1]','nvarchar(max)') as Adı,
            'SqlExec' as Tipi
 
    from    wflProcesses p inner  join
            wflLibraries l on l.Id=p.Library inner join
            (select Id, Process,TestMode, convert(xml,Graph) as Graph, Version, CreateDate, LastUpdate, Description from wflProcessVersions) pv on pv.Id=p.CurrentVersion cross apply
            pv.Graph.nodes('//SqlExec') as Web2Veri(Ent)
    UNION ALL
 
            select 
            distinct
            l.Name as 'Kutuphane',
            p.Name as 'SurecAdi',
            Web2Veri.Ent.value('(./@Connection)[1]','nvarchar(max)') as Adı,
            'SqlInsert' as Tipi
 
    from    wflProcesses p inner  join
            wflLibraries l on l.Id=p.Library inner join
            (select Id, Process,TestMode, convert(xml,Graph) as Graph, Version, CreateDate, LastUpdate, Description from wflProcessVersions) pv on pv.Id=p.CurrentVersion cross apply
            pv.Graph.nodes('//SqlInsert') as Web2Veri(Ent)
    UNION ALL
 
            select 
            distinct
            l.Name as 'Kutuphane',
            p.Name as 'SurecAdi',
            Web2Veri.Ent.value('(./@Connection)[1]','nvarchar(max)') as Adı,
            'SqlUpdate' as Tipi
 
    from    wflProcesses p inner  join
            wflLibraries l on l.Id=p.Library inner join
            (select Id, Process,TestMode, convert(xml,Graph) as Graph, Version, CreateDate, LastUpdate, Description from wflProcessVersions) pv on pv.Id=p.CurrentVersion cross apply
            pv.Graph.nodes('//SqlUpdate') as Web2Veri(Ent)
 
) as Temp order by 1,2
  • No labels