Forum Discussion
Converting ColumnsUpdated Field
In my SQL datatable I have a ColumnsUpdated field which is a VARBINARY representation of the COLUMNS_UPDATED T-SQL function. I have a custom scalar-valued function which converts the column by essent...
Greg_DecklerI was able to solve this issue by created a CTE in the Advanced Options of Get Data, setting up the relationship, and then displaying the parsed ColumnsUpdated from the CTE in a report.
The SQL I ran during import was:
WITH ChangeLog_CTE (Guid, ParsedUpdatedColumns) AS ( SELECT Guid, (dbo.[GetChangedColumns]('History.Resources', History.Resources.ColumnsUpdated)) AS ParsedUpdatedColumns FROM History.Resources ) SELECT * FROM ChangeLog_CTE;
Greg_DecklerI was able to solve this issue by created a CTE in the Advanced Options of Get Data, setting up the relationship, and then displaying the parsed ColumnsUpdated from the CTE in a report.
The SQL I ran during import was:
WITH ChangeLog_CTE (Guid, ParsedUpdatedColumns)
AS
(
SELECT
Guid,
(dbo.[GetChangedColumns]('History.Resources', History.Resources.ColumnsUpdated)) AS ParsedUpdatedColumns
FROM
History.Resources
)
SELECT *
FROM ChangeLog_CTE;
Greg_Deckler
Community Champion
Community ChampionAnonymous , glad you got it figured out. Yes, the Advanced Options will let you run whatever SQL Query you desire. Didn't think of that as the answer to your question because I'm still not exactly sure what you are going for!! :)