September 15, 2008 at 11:14 am
I have a column coming from one database to another database. The original database the column has a datatype of smallint with 1, 0 or null. The database its going to the same column is not a bit. So 1 becomes true, 0 becomes false. The new database the bit column does not allow nulls, so I need to do a isnull and if the old source column is null, then false, else the value in the column. So, I have a data converion changing from smallint to boolean, then a isnull on the data conversion column. Its changes everything to false each time. I setup a data viewer on each step, and its true until it hits that dervied column and it changes to false. Below is my syntax. Can anyone help.
ISNULL(DC_P_ACTIVE ? FALSE : DC_P_ACTIVE)
the original colum name is p_active. DC_P_ACTIVE is the data conversion of that original column. Why is it changing my trues to false?
September 15, 2008 at 11:24 am
Looks to me that you just have to move the parenthesis, as in:
ISNULL(DC_P_ACTIVE) ? FALSE : DC_P_ACTIVE
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
September 15, 2008 at 12:06 pm
thank fixed it, thanks alot!!!!!!!!
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy