We help IT Professionals succeed at work.

Query to Table with Computed Fields

I want to write directly to a new table and as long as there are no computed fields I have no problem. The issue is that I have 10 computed fields which insert an X dependent upon the value from another field. When I write to the new table the computed fields are not being populated by an X. Any ideas?
Watch Question

Top Expert 2011

can you post your code?
Senior DBA
Most Valuable Expert 2018
Distinguished Expert 2019
Computed columns should be generated "live" as the data is read from the table (unless the computed column is persisted, either explicitly or implicitly).

When you say "computed column", do you mean a virtual/logical column in the table defined like:
CREATE TABLE ... (..., computed_column AS <column_expression> )
or do you mean something else?

Explore More ContentExplore courses, solutions, and other research materials related to this topic.