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.
| Author |
Topic |
|
programer
Posting Yak Master
221 Posts |
 Posted - 2011-07-26 : 14:55:10
|
Hi,
I have table tbl_transaction:
SrNo int Unchecked
UserId uniqueidentifier Checked
TransactionAmount decimal(18, 2) Checked
TransactionType int Checked
TransactionDate datetime Checked
TransactionId nvarchar(1000) Checked
Pending bit Checked
and I have tbl_ tbl_BankDetails:
ID int Unchecked
UserId uniqueidentifier Checked
SWIFT nvarchar(30) Checked
IBAN nvarchar(50) Checked
BankName nvarchar(200) Checked
Country nvarchar(100) Checked
AccountOwner nvarchar(200) Checked
Address nvarchar(500) Checked
BankDetails table is to store bank details (SWIFT BANK NAME,...)
Which table I need for stored amount?
I create a new table tbl_withdrawal where store all the pay out (withdrawals)?
Like this:
SWIFT BANK NAME, IBAN, AMOUNT? |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-07-31 : 15:09:33
|
isn't th5s just a combination of data from bankdetails and transaction for a transaction type? Why does it need to be a table.
If needed it could be a view but I would just leave it as it is.
==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Design table for withdrawal