Hi all,
I use sql server 2005 with a linked server to Btrieve.
My Problem is that there is a date field in BTrieve that can contain the value 00/00/0000.
When I run and open query sql runs ok until it hots one of these dates.The I get the error "Conversion failed because the data value overflowed the data type used by the provider."
I know this is because SQL is saying what the hell is this 00/00/0000?
But I need all these columns returned..
The only way so far that I can get all columns back is by using convert to varchar but this takes along time to run..
Any other ideas?
eg:Below takes 8Mins to run but I get 00-00-0000 returned.
Need to speed things up
SELECT *
FROM OPENQUERY(cellular, 'SELECT refnumber,Convert(InWorkShopDate, SQL_VARCHAR)as InWorkShopDate,FROM JOBSE ')
Ray
I use sql server 2005 with a linked server to Btrieve.
My Problem is that there is a date field in BTrieve that can contain the value 00/00/0000.
When I run and open query sql runs ok until it hots one of these dates.The I get the error "Conversion failed because the data value overflowed the data type used by the provider."
I know this is because SQL is saying what the hell is this 00/00/0000?
But I need all these columns returned..
The only way so far that I can get all columns back is by using convert to varchar but this takes along time to run..
Any other ideas?
eg:Below takes 8Mins to run but I get 00-00-0000 returned.
Need to speed things up
SELECT *
FROM OPENQUERY(cellular, 'SELECT refnumber,Convert(InWorkShopDate, SQL_VARCHAR)as InWorkShopDate,FROM JOBSE ')
Ray