Re: Heads Up: TSQL sql_variant data type WILL NOT import into JMP
May 4, 2011 11:12 AM(974 views)
I came across this problem today, only I can't CAST or CONVERT on the SQL side because the data type is a little endian that contains an array of data. I can, however, handle this data type on the JMP side using a BLOB function.
So, if I can't bring the data type into JMP using OPEN DATABASE(), is there a way to run the BLOB function on the database side (with a direct reference to the database maybe)? Breaking up the array on the database side is a possibility, but I will have to sit though a lecture about how I am wrecking the elegance on their end.