tsql kolona iz vrednosti druge kolone

WITH [FilteredSource] AS (
-- partition: 0 ms
SELECT
	[Documents].[DocumentID] AS [DocumentIDP],
	[Documents].[Filename] AS [Datoteka],
	[Documents].[Link] AS [Link],
	[Documents].[Deleted] AS [Deleted],
	[Documents].[LatestRevisionNo] AS [Revizija],
	[Projects].[ProjectID] AS [ProjectID],
	[Projects].[Deleted] AS [DeletedProj],
	[Projects].[Path] AS [DirektorijAggr],
	[Users].[FullName] AS [CheckOut By],
	[DocType].[TypeName] AS [TypeName],
	[VariableValue].[ValueText] AS [Property Value],
	[ObjectType].[ObjectTypeID] AS [ObjectTypeID],
	[ObjectType].[Description] AS [Description],
	[Variable].[IsDeleted] AS [IsDeleted],
	[Variable].[VariableName] AS [Property Name],
	[FileExtension].[Extension] AS [Extension],
	[DocumentConfiguration].[ConfigurationID] AS [ConfigurationID],
	[DocumentConfiguration].[ConfigurationName] AS [Konfiguracija],
	[Revisions].[FlushedDate] AS [Checked-In],
	ROW_NUMBER() OVER (PARTITION BY [DocumentConfiguration].[ConfigurationID], [Variable].[VariableID], [Documents].[DocumentID] ORDER BY [Revisions].[FlushedDate] DESC) AS [Partition_Konf-Prop]
-- select: 0 ms
FROM 	[DocumentsInProjects]
	FULL JOIN [Documents] ON [DocumentsInProjects].[DocumentID] = [Documents].[DocumentID]
	FULL JOIN [Projects] ON [DocumentsInProjects].[ProjectID] = [Projects].[ProjectID]
	FULL JOIN [VariableValue] ON [Documents].[DocumentID] = [VariableValue].[DocumentID]
	FULL JOIN [Variable] ON [VariableValue].[VariableID] = [Variable].[VariableID]
	FULL JOIN [Revisions] ON [Documents].[DocumentID] = [Revisions].[DocumentID]
	FULL JOIN [Users] ON [Documents].[UserID] = [Users].[UserID]
	FULL JOIN [DocType] ON [Documents].[DocTypeID] = [DocType].[DocTypeID]
	FULL JOIN [FileExtension] ON [Documents].[ExtensionID] = [FileExtension].[ExtensionID]
	FULL JOIN [ObjectType] ON [Documents].[ObjectTypeID] = [ObjectType].[ObjectTypeID]
	FULL JOIN [DocumentConfiguration] ON [VariableValue].[ConfigurationID] = [DocumentConfiguration].[ConfigurationID]
-- join: 0 ms
WHERE	([Documents].[Filename] LIKE CAST('%ngi%' AS NVARCHAR(5)))
AND	([Documents].[Link] = CAST('0' AS BIT))
AND	([Documents].[Deleted] = CAST('0' AS BIT))
AND	([Projects].[Deleted] = CAST('0' AS BIT))
AND	([DocType].[TypeName] NOT LIKE CAST('Toolbox' AS NVARCHAR(128)))
AND	([ObjectType].[Description] LIKE CAST('Normal Document' AS NVARCHAR(255)))
AND	([Variable].[IsDeleted] = CAST('0' AS BIT)
OR	 [Variable].[IsDeleted] IS NULL)
AND	([Variable].[VariableName] LIKE CAST('%ident%' AS NVARCHAR(7))
OR	 [Variable].[VariableName] LIKE CAST('%naziv%' AS NVARCHAR(7)))
-- filter: 0 ms
)
-- recursion: 0 ms
SELECT TOP 2000
	CONCAT('C:\EPDM', [FilteredSource].[DirektorijAggr]) AS [Direktorij],
	[FilteredSource].[Datoteka] AS [Datoteka],
	CONCAT('conisio://EPDM/open?projectid=', [FilteredSource].[ProjectID], '&documentid=', [FilteredSource].[DocumentIDP], '&objecttype=', [FilteredSource].[ObjectTypeID]) AS [Open],
	[FilteredSource].[Extension] AS [Extension],
	[FilteredSource].[Revizija] AS [Revizija],
	[FilteredSource].[Konfiguracija] AS [Konfiguracija],
	[FilteredSource].[Property Name] AS [Property Name],
	[FilteredSource].[Property Value] AS [Property Value],
	[FilteredSource].[CheckOut By] AS [CheckOut By],
	[FilteredSource].[Checked-In] AS [Checked-In],
	[FilteredSource].[DocumentIDP] AS [DocumentIDP],
	[FilteredSource].[ConfigurationID] AS [ConfigurationID]
-- selectouter: 0 ms
FROM 	[FilteredSource]
-- join: 0 ms
WHERE 	[FilteredSource].[Partition_Konf-Prop] <= 1

GROUP BY
	[FilteredSource].[DocumentIDP],
	[FilteredSource].[Datoteka],
	[FilteredSource].[Link],
	[FilteredSource].[Deleted],
	[FilteredSource].[Revizija],
	[FilteredSource].[ProjectID],
	[FilteredSource].[DeletedProj],
	[FilteredSource].[DirektorijAggr],
	[FilteredSource].[CheckOut By],
	[FilteredSource].[TypeName],
	[FilteredSource].[Property Value],
	[FilteredSource].[ObjectTypeID],
	[FilteredSource].[Description],
	[FilteredSource].[IsDeleted],
	[FilteredSource].[Property Name],
	[FilteredSource].[Extension],
	[FilteredSource].[ConfigurationID],
	[FilteredSource].[Konfiguracija],
	[FilteredSource].[Checked-In]
-- groupby: 16 ms
HAVING	 (CONCAT('C:\EPDM', [FilteredSource].[DirektorijAggr]) NOT LIKE CAST('%staro%' AS TEXT))
-- having: 16 ms
ORDER BY
	[FilteredSource].[DirektorijAggr],
	[FilteredSource].[DocumentIDP],
	[FilteredSource].[Konfiguracija] ASC,
	CASE
	WHEN [FilteredSource].[Property Name] LIKE 'Ident' THEN 1
	WHEN [FilteredSource].[Property Name] LIKE 'St. risbe' THEN 2
	WHEN [FilteredSource].[Property Name] LIKE 'Author' THEN 3
	WHEN [FilteredSource].[Property Name] LIKE 'Konstruiral' THEN 4
	WHEN [FilteredSource].[Property Name] LIKE 'Drawn By' THEN 5
	ELSE 6 END ASC,
	[FilteredSource].[Property Name]
-- orderby: 16 ms
;

WITH [FilteredSource] AS ()

([Variable].[VariableName] LIKE CAST('%ident%' AS NVARCHAR(7))

[Variable].[VariableName] LIKE CAST('%naziv%' AS NVARCHAR(7))