Category Archives: Database Consults
A recent published study looked for a correlation between the number of pigs born alive to parity one females and their subsequent lifetime and reproductive performance on commercial farms in southern Europe (Ilida, Piñeiro and Koketsu, 2015). The study results … Continue reading
The research and development group would like to see the service result and subsequent service result in the same or next parity for trials they are running. They want two subsets, one subset is filtered by service date and the … Continue reading
The research and development group would like to see the first service result after transfer and subsequent service result in the same or next parity for transferred females between two dates.
I need a tally report showing the arrival date in one axis and days from first heat not served to first service in the other axis. I want to determine if the arrival date is correlated to the interval days.
We would like a list report that shows all the litters farrowed with some way to distinguish the litters that have at least one scours treatment.
I want to extract the born alive number by parity for every female. The results must be placed in a crosstab format (pivot table). Each row shows the sow ID, and the columns show the liveborn number for each parity.
I would like to see the trend of the days interval from service result date in service 1 to service 2 date in a period of time.
We wish to look at the birthing rate, total born & born alive of females who had a second service (NSERVICE=2) where the first service result = return to heat only (omit all other service result reasons except returns). We … Continue reading
I want to know the number animals that arrived in a time period and the percentage of arrived that had their first Heat Not Served event at specific age classes (or none). I want to include females in both Female … Continue reading