Category Archives: Database Consults

Lifetime sow performance predicted by the first farrowing

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

Posted in Porcitec Consults | Leave a comment

Service result and subsequent service

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

Posted in Database Consults | Leave a comment

Service result and subsequent service after transfer

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.

Posted in Database Consults | Leave a comment

Arrival date vs days between first heat and first service

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.

Posted in Database Consults | Leave a comment

Litters born with at least one scour treatment

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.

Posted in Database Consults | Leave a comment

Liveborn number by parity for every female in a pivot table

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.

Posted in Database Consults | Leave a comment

Interval between service result 1 and service 2

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.

Posted in Database Consults | Leave a comment

Second service perfomance of recycles

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

Posted in Database Consults, Porcitec Consults | Leave a comment

Age at first heat distribution

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

Posted in Database Consults | Leave a comment

How to join 2 tables to get next parity data

For example, I want to know the performance of sows after weaning by farrowing room. I want to know weaning and service performance in the current parity, and litter size in their next parity, so I need to join 2 … Continue reading

Posted in Database Consults, Porcitec Consults | Leave a comment