Post reply

merge statement to insert nulls for columns whose values currently unknown

  • August 3, 2011 at 3:25 am

    #241174

    I'm merging data from old to new database. New db contains columns not used in old.

    I currently want to focus building my merge statement to merge in values for just those columns that are not null and tackle the null ones later.

    In USING clause I have a select statement that uses CASE for bringing in data for columns that are not null. Please advise on how I can insert null values for those allowing nulls.

  • August 3, 2011 at 10:39 am

    #1363223

    the answer is, to make the column = NULL (within the select statement). This will populate the column with null values.

    Simple as that.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply