computed column using another table in sql

debugcn Published at Dev

Arash

i have two table in sql serever with no relation 1-rate table 2-jewellry tabale rate table hold diffrent rate for example usd , gold , platinume and jewellry table use holds jewellry item , and total price of each item is calculated real time based on rate value from rate table .

price field in jewellry table is computed column and has its own business rule , but in end it should use a value in rate table to complete the rule , for example gold rate in rate table*weight(jewellry table)*tax(rate table ).

how can i achive this in sql server ? store procedure ? function ? i dont want to use any client side because i want to export table via wcf as odata .

Gordon Linoff

You can achieve this by creating a user-defined function that does the calculation that you want.

The computed column can then be set using the UDF.

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-06-28

Comments

0 comments

From Dev

Related Related

Article

computed column using another table in sql

computed column using another table in sql

SQL computed column for sum of data in another table

How to create a computed column that references another column from another table?

Insert in SQL table using select with column values from another select

SQL: Filtering on a computed column

SQL: Filtering on a computed column

Update table column using table in another SQL Server database while using a spatial function

Populate SQL table column from another table

Can I use a computed column in a table to fetch data from another table columns

How can I create a SQL table variable using records in another table as column names

TryParse in a Sql Server computed column

TryParse in a Sql Server computed column

SQL computed column based on OR clause

SQL Server - computed date column

Move SQL Server table column values to another table column

create table column based on another table column value in sql

create table column based on another table column value in sql

Move SQL Server table column values to another table column

How can i create Computed Column which gets data from another table

SQL Join Constraint Column on Another Joined Table

SQL command single column data to another table

Joining a column from another complex table in sql

Populate a column in SQL with values from another table

SQL - Setting a variable to value of column in another table

SQL query for referring another column in same table

SQL Query to Filter a Table using another Table

query table using another lookup table sql

Update table column with another column values of the same table using updateAll()

Sort a CursorLoader using column present in another table

use function from another database in computed column