A. e.g. select datepart(wk,'19990323') returns 13 when it should be 12.
This is because SQL Server starts counting weeks from Jan 1. Week 1 = Jan 1.
The ISO standard is that week 1 is the first week with 4 days in it.
You will have to write your own bit of SQL to calculate it...