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 |
|
pssumesh2003
Starting Member
35 Posts |
 Posted - 2009-12-18 : 00:40:21
|
| HiI am new in Sql Server 2005,i have two tables named Account ,Tran, Tran has AccountId as Forign key.In account account have different Transaction date and finaldate for each Account.In transaction table transaction of each account.My problem is to select account who don't make any transaction betweentheir Transaction date and finaldate.table fields likeAccountId, Name, Address, CretedDate ,---101 , SAM ,jhhj, 1/10/2009102 , Arun ,iyuy, 26/11/2009TransTranId,AccId,TranDate,Amount,--1 101 2/10/2009 500Each account has made an instalment everymonth same day to 5 more days when they created .i want a report to list all account who fail to made their instalmenttheir Due date interval |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
rajdaksha
Aged Yak Warrior
595 Posts |
Posted - 2009-12-18 : 03:19:19
|
| HiWhere is finaldate field in your table. can you please post clear table structure and expected output.-------------------------R... |
 |
|
|
|
|
|
|
|
SQL Select Query