formula for computed column based on different table’s column

by

You could create a user-defined function for this:

CREATE FUNCTION dbo.GetValue(@ncode INT, @recid INT)
RETURNS INT
AS 
   SELECT @recid * nvalue 
   FROM c_const 
   WHERE code = @ncode

and then use that to define your computed column:

ALTER TABLE dbo.YourTable
   ADD NewColumnName AS dbo.GetValue(ncodeValue, recIdValue)

More Related Contents:

  1. Sql Server deterministic user-defined function
  2. How can I alter this computed column in SQL Server 2008?
  3. I dont know sql syntax for my table [closed]
  4. Insert an image in a column of a table that already has 5 columns
  5. Insert local .csv data in remote SQL Server via already working connection string
  6. Syntax combine two stored procedure into one [closed]
  7. How to delete duplicate rows in SQL Server?
  8. CROSS JOIN vs INNER JOIN in SQL
  9. How to cast the DateTime to Time
  10. How can I schedule a job to run a SQL query daily?
  11. Reset identity seed after deleting records in SQL Server
  12. How to avoid the “divide by zero” error in SQL?
  13. SET versus SELECT when assigning variables?
  14. Multiple INSERT statements vs. single INSERT with multiple VALUES
  15. Real life example, when to use OUTER / CROSS APPLY in SQL
  16. Common Table Expression, why semicolon?
  17. T-SQL split string based on delimiter
  18. SQL Server 2008: how do I grant privileges to a username?
  19. How to convert an integer (time) to HH:MM:SS::00 in SQL Server 2008?
  20. How do I find duplicates across multiple columns?
  21. Generate script in SQL Server Management Studio
  22. Split values over multiple rows [duplicate]
  23. How to do an inner join on row number in sql server
  24. is of a type that is invalid for use as a key column in an index
  25. How to get the size of a varchar[n] field in one SQL statement?
  26. Stored procedure that exports data into csv files only exports to one file
  27. SQL Server: should I use information_schema tables over sys tables?
  28. TSQL – How to use GO inside of a BEGIN .. END block?
  29. SQL take just the numeric values from a varchar
  30. How to execute a stored procedure inside a select query

Leave a Comment