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. |
 |
|
|
|
|