Thank you very much for the quick response! All solved now. I used the following query:
select Emp_No as Emp_No_Int, convert(varchar, Emp_No) as Emp_No_Txt
from Person
Thanks again!
Oliver
Hi,
I am attempting to create a report in Crystal 10 that extracts data from two SQL sources. They both share a common ID which uniquely identifies a person, however, in one database this is stored as a Text, in the other an Int.
Obviously the ideal solution would be for them to both be int's...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.