Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more here.

Tadeusz Dracz

My feedback

  1. 22 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Tadeusz Dracz commented  · 

    The issue seems to be to somehow connected to this computed column:
    [Location] AS (CASE WHEN [LocationExtra] IS NULL THEN [LocationCore] ELSE [LocationCore]+[LocationExtra] END),

    When its definition is changed to:
    ([LocationCore]+ISNULL([LocationExtra],''))

    the problem doesn't occur. Note, LocationCore doesn't allow nulls.

    An error occurred while saving the comment
    Tadeusz Dracz commented  · 

    P.S. I can provide a database on which it can be easily replicated.

    Tadeusz Dracz shared this idea  · 
  2. 955 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    19 comments  ·  SQL Database  ·  Flag idea as inappropriate…  ·  Admin →
    Tadeusz Dracz supported this idea  · 

Feedback and Knowledge Base