Displaying 1 result from an estimated 1 matches for "animalstatusid".
Did you mean:
animalstatus
2012 Mar 07
1
SELECT CASE in RODBC
...ode AS codeevent, AnimalTransferType.Description AS
event
FROM
Animal
FULL JOIN
AnimalTransfer ON Animal.AnimalNumber = AnimalTransfer.AnimalNumber
FULL JOIN
AnimalTransferType ON AnimalTransfer.AnimalTransferTypeId =
AnimaltransferType.RowId
FULL JOIN
AnimalStatus ON Animal.AnimalStatusId = AnimalStatus.RowId
UNION ALL
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,
calving.calvingdate AS date,...