Hi,
i am doing incremental-load from SQL...first time, i just learned some scripts from web.
"the_id" is field of figures, just want to bring in new data that "the_id" larger than MaxID in QVD file.
...
SQL SELECT * FROM DB.TABLE
where "the_id" > $(v.MaxID);
...
An error message pop up below:
ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Incorrect syntax near > ...
what is reason and possible solution to solve it?