Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Comparing binary values in tMSSQLxxxx Select statement

Hello,
We are trying to load the delta data from a source SQL server table into a target SQL server table. The source table has a RowVersion (timestamp) column which is a binairy(8) data type.
To select the delta load of data, we first do a Max value of the timestamp column of the target table:
0683p000009Lt77.jpg
Then we store this value in a global variable with tFlowToIterate so we can use this in the select statement for the selection of records from the source.

 

Question: How can we do a SELECT-statement to compare binary values in the WHERE clause? It seems that binairy data is displayed in different ways:
- SQLserver: 0x00000000F0793D49
- Query builder in Talend: 00000000F0793D49
- System.out.println value in Talend: [B@42d3bd8b

Thanks on advance,

Regards Glenn.

Labels (3)
0 Replies