I restored the database in a Test server. Now i cannot decrypt/ encrypt the data. I even tried to restore the service master key, i am getting the following...
If these two statements retrives different values then go go for temp tables.Keep all the results in the temp tables and then retrieve it from that table.