I have a dynamic SQL query which pull data from oracle DB through linked server.
Dynamic SQL query works fine and I am able to pull the data into SQL Server table.
But the issue is, after the data pull is done, if I run the same query it pulls more data.
What would be the issue? Is it because of linked server??
Same Code but different output. This is the issue.
Can someone give me some idea?