How can you maintain data types through an open query

Last Post 15 Nov 2011 08:05 AM by gunneyk. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
duke442games
New Member
New Member

--
14 Nov 2011 09:33 AM
I need to create a stored proceedure in SQL that returns the results of an open query while maintaining the aplicable data type. Their are quantities and dolar amounts that I need to maintian through out this process.

Is this even possible?

gunneyk
New Member
New Member

--
15 Nov 2011 08:05 AM
You can insert them into a local table that has the correct datatypes defined. The values themselves wont change via the open query so if you insert them into the proper datatype on the local table they shoudl retain what you need.


Acceptable Use Policy
---