Nice code, thanks. The proc that's doing the BCP is just a part of a larger process; create a file, write it to a windows server,email it, then also...

Thanks to you both!

EXCELLENT! Thanks. Sometimes you look at things for too long and from the wrong angle.

Thanks. I believe I'm doing what you suggested

QtdRptEarnSubjDed00 = CASE WHEN QtdRptEarnSubjDed00 > 0 THEN QtdRptEarnSubjDed00 + @diff ELSEQtdRptEarnSubjDed00 end,

QtdRptEarnSubjDed01 = CASE WHEN QtdRptEarnSubjDed01 > 0 THEN QtdRptEarnSubjDed01 +...

thanks, that'll keep me from searching for the answer any further.

Thanks. I can do all this in .Net managed code, if fact I have, but I was trying do it all in SQL. our AD is barebones, our SQL...

I just want to smack the person who originally wrote 'Select *'. it couldn't have been me...;-) in fact, it's friday, maybe I'll blow some time tagging all...

Just as an FYI, I found the same problem with a view that uses 'Select *'