In SQL Server 2008 R2 Management studio under Linked servers I want to script a select from an Oracle database table. The result is that many of the fields occur three times. What can the reason for that be? See this example: SELECT [RATETYPE],[RATETYPE],[RATETYPE] ,[FROMCURRENCY],[FROMCURRENCY],[FROMCURRENCY] ,[TOCURRENCY],[TOCURRENCY],[TOCURRENCY] ,[VALIDFROM],[VALIDFROM],[VALIDFROM],[EXCHRATE] ,[FROMFACTOR] ,[TOFACTOR] ,[CREATIONDATE],[CREATIONDATE],[CREATIONDATE] FROM [MyServer]..[MyDB].[MyTable]
Software/Hardware used: SQL 2008 R2 Management Studio
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!
No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.
Your password has been sent to:email@example.com
To follow this tag...
Thanks! We'll email you when relevant content is added and updated.
Share this item with your network: