changing datatype of dynamically generated columns
I have a temporary table in which the columns are dynamically generated using pivot.As I am using the pivot function the columns by themselves are of int datatype. the values for the columns are either 0 or 1. Now I want to update 1 with 'Y' and 0 with 'N'. but I am getting conversion error while doing so. please help.
changing datatype of dynamically generated columns
===

I have a temporary table in which the columns are dynamically generated using pivot.As I am using the pivot function the columns by themselves are of int datatype. the values for the columns are either 0 or 1. Now I want to update 1 with 'Y' and 0 with 'N'. but I am getting conversion error while doing so. please help.