Dynamic query in sql server

Sai Reddy

8y854

I have faced a interview question.

Input

Id Country Amount

1 India 1000

2 US 2000

3 Dubai 30000

Output

Id Country Amount Currency

1 India 1000 Rupee

2 US 2000 Dollor

3 Dubai 30000 Dhiram

I wrote a query with case statement for above three records, he asked me to write a dynamic query for lakhs of records. How can i acheive it?

Thanks in advance.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Shahriar Nikkhah8y ago
Accepted answer
Just Heads-up some countires have 2 unit of money

good luck
DECLARE @tblCountryAmount AS TABLE
(   [id]            Int
,   [Country]       nVarChar(10)
,   [Amount]        Int
)

INSERT INTO @tblCountryAmount
VALUES (1,'India' , 1000) , (2, 'US' , 2000) , (3, 'Dubai' , 3000)

--- For Test
SELECT    MT.* FROM   @tblCountryAmount MT

DECLARE @tblCountryUnit AS TABLE
(   [id]        Int
,   [Unit]      nVarChar(10)
)

INSERT INTO @tblCountryUnit
VALUES (1,'Rupee') , (2, 'Dollor') , (3, 'Dhiram')

--- For Test
SELECT    ST.* FROM   @tblCountryUnit ST



---
SELECT    MT.* , ST.Unit
FROM   @tblCountryAmount MT
INNER JOIN @tblCountryUnit ST
ON MT.id = ST.id
0
Sekhar Babu8y ago
You can maintain currency table, where columns would be country, currency, now you can apply join on both tables. coutry column is reference key
0