SQL Server Manipulate Select Return Data

Question

Is there a way to preprocess the data returned from SQL Server in a select statement at all?

Scenario, we need to save all money figures into our database as the default exchange rate. i.e. If money figure entered in China, it will get resolved and saved as USD with the chinese exchange rate assigned to it. I can utilize triggers to automate this at the db level.

When we perform a select from this table i'm wanting to return the figure as the Chinese amount which will be Money field * exchange rate. Is this possible at all?

Any advice? Im hoping we can do this at the db layer as we are working with legacy software.

Thanks

Gordon Linoff · Accepted Answer · 2014-01-28 03:15:43Z

1

I would suggest using a view for this:

create view v_table as
    select t.*,
           (t.MoneyFigure / t.ExchangeRate) as LocalCurrencyAmount
    from table t;

In SQL Server, you can also do this by adding a computed column to the table:

alter table
    add LocalCurrencyAmount as (t.MoneyFigure / t.ExchangeRate);

answered Jan 28, 2014 at 3:15

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

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

Comments

Szymon · Accepted Answer · 2014-01-28 03:16:05Z

0

There is no pre-process layer in SQL Server.

One way around it (not the best in some ways though) is to rename the tables to a new name and create views for those tables that have the same names as the original tables. This way you will be able to manipulate the data in the views.

answered Jan 28, 2014 at 3:16

Szymon

43k16 gold badges99 silver badges115 bronze badges

Collectives™ on Stack Overflow

SQL Server Manipulate Select Return Data

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