please see the link below to help us figure out what's going on. Sample DDL and data will help us to solve your issues faster.
Thanks,
Jon
http://www.sqlservercentral.com/articles/Best+Practices/61537/
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."