Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Multiple Currency storage

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-04-05 : 00:58:06
Tony writes "Hi

Can someone show/tell me how to store multiple curency type in one single table. What I mean is I have to store currencies in $,£,Yen etc in table titled 'tbl_RoomCharges.Payment'. In orther words, these payments are made in various currencies.

What do you think is the best way of storing these various 'payment type' currencies? Or is there a better way?

Please kindly let me know.

T"
   

- Advertisement -