Can you please provide the step by step explanation on SSIS implementation, if possible provide few screen shots too.

By the way what method were you using earlier, can you detail...

Try this..

SELECT Count(tblSicknessEpisode.PersonnelNumber) AS CountOfPersonnelNumber, tblSicknessEpisode.SickEpisodeID, tblSicknessEpisode.FirstDate, tblSicknessEpisode.LastDate, tblSicknessEpisode.SickCategory

FROM tblSicknessEpisode

GROUP BY tblSicknessEpisode.SickEpisodeID, tblSicknessEpisode.FirstDate, tblSicknessEpisode.LastDate, tblSicknessEpisode.SickCategory

WHERE

tblSicknessEpisode.SickCategory="NWR"

HAVING (((tblSicknessEpisode.PersonnelNumber)>=4))

ORDER BY tblSicknessEpisode.FirstDate;

Having is meant to apply condition on any Aggregate functions used...

That's really great, I appreciate it.

By the way what's the significance of passing '1' or '2' in

FROM OPENXML(@iDoc, '//a:category', 1)

In both the cases I find same results

I noticed that you are using SQL 2005, so SSIS (SQL Server Integration Services) will be the best choice here, but if you wish to continue with same logic then...