sultankahut (7/16/2008)

Do you have an automatic update squedchuled at 3:00 every day on that machine ?

I do not know if its posible with the deployment wizzard, but you could use BIDS to do this.

Why not create a table 'YESNO':

• value int,   char name
• 1              NO
• 2              YES

The the first query can change the  case into a join becoming something like:

Select a.col1,b.col2,c.col3, yn.text  from bla as a join YESNO as yn...