Displaying 1 result from an estimated 1 matches for "herdnumber".
2012 Mar 07
1
SELECT CASE in RODBC
...ers in stead of the text string, but then
the UNION 'crashes' because it cannot convert the "event" variable from the
first SELECT to an integer variable...
Any suggestions?
Thanks - Bodil
I use the following code:
raw<-sqlQuery(.zz,
'SELECT TOP(100)PERCENT
Animal.Herdnumber AS herd, Animal.ChrNumber AS chrNr,
Animal.AnimalNumber AS animalid, Animal.DateOfBirth AS datebirth,
AnimalStatus.Code AS codestatus, AnimalStatus.Description AS
animalstatus,
AnimalTransfer.Date AS date,
AnimalTransferType.Code AS codeevent, AnimalTransferType.Description AS
event...