computed column using another table in sql

Question

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 · Accepted Answer · 2014-06-15 12:54:04Z

1

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.

answered Jun 15, 2014 at 12:54

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Vladimir Semashkin · Accepted Answer · 2014-06-15 12:56:15Z

1

You can just use columns are contained in current table. For your purposes you can use triggers on foreign table for total sum calculation. Or you can use views for aggregation total results.

answered Jun 15, 2014 at 12:56

Vladimir Semashkin

1,2801 gold badge10 silver badges21 bronze badges

Collectives™ on Stack Overflow

computed column using another table in sql

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related