Now this might be common knowledge to some, but it came as a pain in the butt surprise to myself and my team. There are a few gotchas with using CAML in SharePoint, specifically with the SPQuery object. The results of using it incorrectly can cause missing data, which will cause a man to go crazy looking for a solution. I primarily use U2U CAML Query Builder Tool to create my CAML queries and then modify them as I need in the code. I recommend downloading this free tool and use it to generate yo... [More]