Langston Montgomery (11/11/2012)
I'm embarrassed to say that it turns out to be a version issue. We ran the same code on a different server with 2008 R2 SP1, and it ran fine. The initial server is still on the RTM version of 2008 R2.
but still ?? how that different version gives diferent/incorrect data ? or you want to say that you have different code/data on both servers
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)